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