public DataTable Select()
{
if (!string.IsNullOrEmpty(_SelectPrc))
{
List <SqlParameter> parms = new List <SqlParameter>();
foreach (string key in _Params.Keys)
{
parms.Add(DbHelperSQLServer.newSqlParameter("@" + key, _Params[key]));
}
DataSet ds = DbHelperSQLServer.Get_DataSet_By_StoredProc(_SelectPrc, parms.ToArray());
if (null != ds && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
else if (!string.IsNullOrEmpty(_SelectSQL))
{
DataSet ds;
if (_Params.Count > 0)
{
ds = DbHelperSQLServer.Get_DataSet_By_Sql(_SelectSQL, _Params);
}
else
{
ds = DbHelperSQLServer.Get_DataSet_By_Sql(_SelectSQL);
}
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
}
return(null);
}
public int Oper(string proc, string action, out string msg)
{
List <SqlParameter> parms = new List <SqlParameter>();
parms.Add(DbHelperSQLServer.newSqlParameter("@Action", action));
foreach (string key in _Params.Keys)
{
parms.Add(DbHelperSQLServer.newSqlParameter("@" + key, _Params[key]));
}
SqlParameter pMsg = DbHelperSQLServer.newSqlParameter("@Msg",
SqlDbType.VarChar, ParameterDirection.Output);
parms.Add(pMsg);
SqlParameter pReturn = DbHelperSQLServer.newSqlParameter("@returnValue",
SqlDbType.Int, ParameterDirection.ReturnValue);
parms.Add(pReturn);
DbHelperSQLServer.Exec_StoredProc_NonQuery(proc, parms.ToArray());
msg = null == pMsg.Value ? "" : pMsg.Value.ToString();
return((int)pReturn.Value);
}
