public static string ExecuteFuntionSql(string ip_str_funtion_name, params object[] parameters)
{
string v_str_select = "select dbo." + ip_str_funtion_name;
string v_str_param = "";
foreach(object item in parameters)
{
v_str_param = v_str_param + "'" + item.ToString()+ "'" + ",";
}
string v_query = v_str_select + "(" + v_str_param;
if(parameters.Length > 0)
{
v_query = v_query.Substring(0, v_query.LastIndexOf(","));
}
v_query = v_query + ")";
CStoredProc v_sp = new CStoredProc("pr_execute_funtion_sql");
v_sp.addNVarcharInputParam("@ip_str_query", v_query);
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
v_sp.fillDataSetByCommand(v_us, v_ds);
return v_ds.Tables[0].Rows[0][0].ToString();
}