/// <summary>
/// 执行语句，返回受影响的行数 ，select 语句不返回受影响行数
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public RemotingSQLResult ExecuteNonQuery(string sql, Hashtable parsHashtable)
{
RemotingSQLResult reslut = new RemotingSQLResult();
try
{
int i = parsHashtable.Count;
//以下构造存储过程参数
SqlParameter[] cmdParms = new SqlParameter[i];
int j = 0;
foreach (DictionaryEntry de in parsHashtable)
{
cmdParms[j] = new SqlParameter(de.Key.ToString(), de.Value);
j++;
}
int r = SqlCmd.ExecuteNonQuery(sql, cmdParms);
//reslut.ResultDataType = 1;
reslut.Total = r;
}
catch (Exception exp)
{
reslut.Code = 1;
reslut.Msg = exp.Message;
}
return(reslut);
}
/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public RemotingSQLResult getDataTable(string sql)
{
RemotingSQLResult reslut = new RemotingSQLResult();
try
{
DataTable dt = SqlCmd.getDataTable(sql);
reslut.DataTable = dt;
}
catch (Exception exp)
{
reslut.Code = 1;
reslut.Msg = exp.Message;
}
return(reslut);
}
