Question

asp.net c#

public static string GetCode(string codeId, string codeKey)
{
StringBuilder strb = new StringBuilder();
strb.Append("SELECT code_name FROM code_dict ");
strb.Append("WHERE code_id='" + codeId + "' ");
strb.Append("AND code_key='" + codeKey + "' ");

try
{
return DbHelper.ExecuteScalar(CommandType.Text, strb.ToString(), null).ToString();
}
catch(Exception e)
{
throw new Exception("Code取得错误，请重新操作");
}
}

有这么一段代码 我要调用它 并让他返回code name的值
请问代码要怎么写 谢谢

Answer 1

public static string GetCode(string codeId, string codeKey)
{
StringBuilder strb = new StringBuilder();
strb.Append("SELECT code_name FROM code_dict ");
strb.Append("WHERE code_id='" + codeId + "' ");
strb.Append("AND code_key='" + codeKey + "' ");

try
{
return DbHelper.ExecuteScalar(CommandType.Text, strb.ToString(), null).ToString();
}
catch(Exception e)
{
throw new Exception("Code取得错误，请重新操作");
}
}
-------------------
string r1="";//自己赋值
string r2="";//自己赋值
string str1=GetCode(r1, r2);

Answer 2

在你要调用的地方写 string gc= new GetCode(string codeId, string codeKey);

Answer 3

我想具体点的话我能给你帮助，你的问题描述的都不清除，详情591434722

Answer 4

你可以在你的程序中直接调用stirng name = GetCode(string codeId,string codeKey);不行吗?