请帮我写一下方法中的查询 [英] Please help me in writing a query inside the method

问题描述

您好我有以下标准，我想写一个方法，请帮助我任何一个。

Hi i have the following criteria and i want to write a method please help me any one.

Method name: GetEvalTypeByEvalCode<br />
    Parameter: string evalCode<br />
    Return Type: string<br />
    Attribute: [MapperFunction(Constants.AppID.ALL, "GetEvalTypeByEvalCode")]

逻辑：



从EVAL_TYPE @ LU_EEN_DETAILS获取值，条件为EEN_NO = evalCode
为此我编写的方法如下：

Logic:

Get value from EVAL_TYPE@LU_EEN_DETAILS with criteria EEN_NO = evalCode
for this i wrote the method like:

[MapperFunction(Constants.AppID.ALL,"GetEvalTypeByEvalCode"]
      public string GetEvalTypeByEvalCode(string evalCode)
      {
          string query = string.Format("SELECT EVAL_TYPE FROM [LU_EEN_DETAILS] WITH (NOLOCK) WHERE EEN_NO ={0}", evalCode);
          return query;
      }

请帮我修正..



非常感谢，

KPR

please help me the corrections..

Many thanks,
KPR

推荐答案

试试这样：

Try like this:

string query = string.Format("SELECT EVAL_TYPE FROM [LU_EEN_DETAILS] WHERE EEN_NO ='{0}'", evalCode);

这篇关于请帮我写一下方法中的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！