/// <summary>
/// 获取临时缴费信息json
/// </summary>
/// <param name="pageModel"></param>
/// <param name="tCharge"></param>
/// <param name="itemCount"></param>
/// <returns></returns>
public List <dynamic> Search(EasyUIGridParamModel pageModel, Model.TempCharge tCharge, out int itemCount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT tCharge.ID,customerName,chargeName,Money,createTime,oper.Name ");
strSql.Append("FROM T_TempCharge tCharge ");
strSql.Append("left join T_Operator oper on oper.ID=tCharge.OperatorID ");
strSql.Append("where 1=1 ");
Dictionary <string, object> param = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(tCharge.CustomerName))
{
strSql.Append("and customerName like @customerName ");
param.Add("customerName", string.Format("%{0}%", tCharge.CustomerName));
}
DateTime firstTime = new DateTime();
if (tCharge.CreateTime > firstTime)
{
strSql.Append("and convert(varchar(10),createTime,121)=@createTime ");
param.Add("createTime", Convert.ToDateTime(tCharge.CreateTime).ToString("yyyy-MM-dd"));
}
if (tCharge.Status != -1)
{
strSql.Append("and tCharge.Status=@status ");
param.Add("status", tCharge.Status);
}
int pageIndex = Convert.ToInt32(pageModel.page) - 1;
int pageSize = Convert.ToInt32(pageModel.rows);
using (DBHelper db = DBHelper.Create())
{
string sql = strSql.ToString();
itemCount = db.GetCount(string.Format(DBHelper.StrGetCountSql, sql), param);
return(db.GetDynaminObjectList(sql, pageIndex, pageSize, "ID", param));
}
}
/// <summary>
/// 获取临时缴费信息json
/// </summary>
/// <param name="pageModel"></param>
/// <param name="tCharge"></param>
/// <param name="itemCount"></param>
/// <returns></returns>
public List <dynamic> Search(EasyUIGridParamModel pageModel, Model.TempCharge tCharge, out int itemCount)
{
return(new DAL.TempChargeDAL().Search(pageModel, tCharge, out itemCount));
}
