/// <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); }