public bool Update(int psid, int IsChekUp)
{
SqlParameter[] parameters =
{
new SqlParameter("@Psid", SqlDbType.Int),
new SqlParameter("@IsChekUp", SqlDbType.Int),
};
parameters[0].Value = psid;
parameters[1].Value = IsChekUp;
return(DBHelpers.RunProcLob("RCUpdate", parameters));
}
/// <summary>
/// 通用查询列表
/// </summary>
/// <param name="tblName">表名或视图名</param>
/// <param name="strGetFields">需要返回的列,*为全部列</param>
/// <param name="fldName">排序字段</param>
/// <param name="PageSize">页尺码</param>
/// <param name="PageIndex">页码</param>
/// <param name="doCount">回记录总数，非0值则返，0则返回查询的记录</param>
/// <param name="OrderType">设置排序方式，非0值则降序列，0为升序列</param>
/// <param name="strWhere">查询条件，不需要加where</param>
/// <returns>DataTable</returns>
public DataTable GetList(string tblName, string strGetFields, string fldName, int PageSize, int PageIndex, int doCount,
int OrderType, string strWhere)
{
DataSet ds = null;
SqlParameter[] Parameters = new SqlParameter[] {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int, 4),
new SqlParameter("@PageIndex", SqlDbType.Int, 4),
new SqlParameter("@doCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar, 1500)
};
Parameters[0].Value = tblName;
Parameters[1].Value = strGetFields;
Parameters[2].Value = fldName;
Parameters[3].Value = PageSize;
Parameters[4].Value = PageIndex;
Parameters[5].Value = doCount;
Parameters[6].Value = OrderType;
Parameters[7].Value = strWhere;
try
{
ds = DBHelpers.RunProcedure("Sp_Conn_Sort", Parameters, "ds");
}
catch (Exception err)
{
throw err;
}
finally
{
}
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
return(ds.Tables[0]);
}
else
{
return(new DataTable());
}
}
/// <summary>
/// 获取全部的信息列表
/// </summary>
/// <param name="SPName">存储过程的名字</param>
/// <param name="SelectStr">选择列字符串</param>
/// <param name="Criteria">查询条件</param>
/// <param name="Sort">排序字符串</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="TotalCount">通过该查询条件，返回的查询记录的总页数</param>
/// <returns>返回当前页的信息列表</returns>
public DataView GetList(
string SPName,
string SelectStr,
string Criteria,
string Sort,
ref long CurrentPage,
long PageSize,
ref long TotalCount
)
{
DataView dv = null;
TotalCount = 0;
SqlParameter[] parameters =
{
new SqlParameter("@SelectStr", SqlDbType.VarChar, 500),
new SqlParameter("@Criteria", SqlDbType.VarChar, 8000),
new SqlParameter("@Sort", SqlDbType.VarChar, 255),
new SqlParameter("@Page", SqlDbType.BigInt),
new SqlParameter("@CurrentPageRow", SqlDbType.BigInt),
new SqlParameter("@TotalCount", SqlDbType.BigInt),
};
parameters[0].Value = SelectStr;
parameters[1].Value = Criteria;
parameters[2].Value = Sort;
parameters[3].Direction = ParameterDirection.InputOutput;
parameters[3].Value = CurrentPage;
parameters[4].Value = PageSize;
parameters[5].Direction = ParameterDirection.InputOutput;
parameters[5].Value = 1;
DataSet ds = DBHelpers.RunProcedure(SPName, parameters, "ds");
if (ds != null && ds.Tables.Count > 0)
{
dv = ds.Tables["ds"].DefaultView;
if (PageSize > 0)
{
TotalCount = Convert.ToInt64(parameters[5].Value);
CurrentPage = Convert.ToInt64(parameters[3].Value);
}
else
{
TotalCount = dv.Count;
if (TotalCount > 0)
{
CurrentPage = 1;
}
else
{
CurrentPage = 0;
}
}
}
return(dv);
}
