/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "ScheduleAnalysis";
* parameters[1].Value = "id";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion Method
public bool Exists(Model.ScheduleAnalysis model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ScheduleAnalysis");
strSql.Append(" where scheduleid=@scheduleid");
strSql.Append(" and perwin=@perwin and perdraw=@perdraw and perlost=@perlost");
SqlParameter[] parameters =
{
new SqlParameter("@scheduleid", SqlDbType.Int),
new SqlParameter("@perwin", SqlDbType.Decimal),
new SqlParameter("@perdraw", SqlDbType.Decimal),
new SqlParameter("@perlost", SqlDbType.Decimal)
};
parameters[0].Value = model.scheduleid;
parameters[1].Value = model.perwin;
parameters[2].Value = model.perdraw;
parameters[3].Value = model.perlost;
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion Method
public bool Exists(Model.ScheduleAnalysis model)
{
return(dal.Exists(model));
}
