static public sqlResult ExecuteScalar_n(string strcom, List <cmdParameters> pars)
{
string temp = "";
sqlResult sRe = new sqlResult();
try
{
using (SqlConnection con = new SqlConnection(strcon))
{
con.Open();
using (SqlCommand com = new SqlCommand(strcom, con))
{
foreach (cmdParameters par in pars)
{
if (par.size == 0)
{
com.Parameters.Add(par.name, par.type);
}
else
{
com.Parameters.Add(par.name, par.type, par.size);
}
com.Parameters[par.name].Value = par.value;
}
temp = SafeValue.SafeString(com.ExecuteScalar());
sRe.status = true;
sRe.context = temp;
}
}
}
catch { }
return(sRe);
}
/// <summary>
/// 返回受影响的行数
/// </summary>
/// <param name="strcom"></param>
/// <returns></returns>
static public sqlResult ExecuteNonQuery(string strcom, List <cmdParameters> pars)
{
int temp;
sqlResult sRe = new sqlResult();
try
{
using (SqlConnection con = new SqlConnection(strcon))
{
con.Open();
using (SqlCommand com = new SqlCommand(strcom, con))
{
foreach (cmdParameters par in pars)
{
if (par.size == 0)
{
com.Parameters.Add(par.name, par.type);
}
else
{
com.Parameters.Add(par.name, par.type, par.size);
}
com.Parameters[par.name].Value = par.value;
}
temp = com.ExecuteNonQuery();
sRe.status = true;
sRe.context = temp.ToString();
}
}
}
catch (Exception ex)
{
sRe.context = ex.Message + ex.StackTrace;
}
return(sRe);
}
