public static string GetSqlStr(string sql)
{
using (SqlConnection connection = DB.con())
{
try
{
string str = "";
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
sda.Fill(ds, "str");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (!dr.IsNull(0) && !dr.IsNull(1) && dr[1].ToString() != "" && dr[1].ToString() != " ")
{
str += dr[0].ToString() + "#" + dr[1] + "#" + GetChineseSpellClass.GetChineseSpell(dr[1].ToString()) + "|";
}
}
return str;
}
catch
{
return "";
}
finally
{
connection.Close();
} }
}
{
using (SqlConnection connection = DB.con())
{
try
{
string str = "";
connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
sda.Fill(ds, "str");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (!dr.IsNull(0) && !dr.IsNull(1) && dr[1].ToString() != "" && dr[1].ToString() != " ")
{
str += dr[0].ToString() + "#" + dr[1] + "#" + GetChineseSpellClass.GetChineseSpell(dr[1].ToString()) + "|";
}
}
return str;
}
catch
{
return "";
}
finally
{
connection.Close();
} }
}
{
public static string GetChineseSpell(string str)
{
return str;
}
}
下面是对这个函数的引用:
string empStr = SelectEasy.GetSqlStr("select empId,empName from T_H_employee where hosId = " + Session["hosId"].ToString());