public CouponManagePagedSearchRD ManageCouponPagedSearch(CouponManagePagedSearchRP manageCouponSearchRP) { CouponManagePagedSearchRD rd = new CouponManagePagedSearchRD(); DataSet dataSet = new DataSet(); dataSet = _currentDAO.ManageCouponPagedSearch(manageCouponSearchRP.CouponTypeID, manageCouponSearchRP.CouponName, manageCouponSearchRP.CouponUseStatus, manageCouponSearchRP.CouponStatus, manageCouponSearchRP.BeginTime, manageCouponSearchRP.EndTime, manageCouponSearchRP.CouponCode, manageCouponSearchRP.Comment, manageCouponSearchRP.UseTime, manageCouponSearchRP.CreateByName, manageCouponSearchRP.UseEndTime, int.Parse(manageCouponSearchRP.PageIndex), int.Parse(manageCouponSearchRP.PageSize)); if (dataSet.Tables.Count == 2) { var couponList = (from d in dataSet.Tables[0].AsEnumerable() select new CouponManageEntity { CouponID = d["CouponID"].ToString(), CouponTypeName = d["CouponTypeName"].ToString(), CouponName = d["CouponName"].ToString(), CouponCode = d["CouponCode"].ToString(), CouponUseStatus = d["CouponUseStatus"].ToString(), BeginTime = d["BeginDate"].ToString() != "" ? Convert.ToDateTime(d["BeginDate"].ToString()).ToLongDateString().ToString() : "", EndTime = d["EndDate"].ToString() != "" ? Convert.ToDateTime(d["EndDate"].ToString()).ToLongDateString().ToString() : "", CouponStatus = d["Status"].ToString(), IsDelete = d["IsDelete"].ToString(), CreateByName = d["CreateByName"].ToString(), Comment = d["Comment"].ToString(), UseTime = d["UseTime"].ToString() != "" ? Convert.ToDateTime(d["UseTime"].ToString()).ToLongDateString().ToString() : "" }); rd.CouponList = couponList.ToArray(); rd.TotalPage = int.Parse(dataSet.Tables[1].Rows[0][0].ToString()); rd.TotalCount = int.Parse(dataSet.Tables[1].Rows[0][1].ToString()); } return(rd); }
public CouponManagePagedSearchRD GetCouponList(GetCouponListRP getCouponListRP) { CouponManagePagedSearchRD rd = new CouponManagePagedSearchRD(); DataSet dataSet = new DataSet(); dataSet = this.GetCouponList(getCouponListRP.VipID, ""); if (Utils.IsDataSetValid(dataSet)) { var couponList = (from d in dataSet.Tables[0].AsEnumerable() where d["Status"].ToString() == "0" select new CouponManageEntity { CouponID = d["CouponID"].ToString(), CouponTypeName = d["CouponTypeName"].ToString(), CouponName = d["CouponName"].ToString(), CouponCode = d["CouponCode"].ToString(), BeginTime = d["BeginDate"].ToString() != "" ? Convert.ToDateTime(d["BeginDate"].ToString()).ToLongDateString().ToString() : "", EndTime = d["EndDate"].ToString() != "" ? Convert.ToDateTime(d["EndDate"].ToString()).ToLongDateString().ToString() : "" }); rd.CouponList = couponList.ToArray(); } return(rd); }
public DataTable GetExportData(CouponManagePagedSearchRP manageCouponSearchRP) { CouponManagePagedSearchRD rd = new CouponManagePagedSearchRD(); DataSet dataSet = new DataSet(); int pageSize = 999999999; //int.Parse(manageCouponSearchRP.PageSize) int pageIndex = 0; //int.Parse(manageCouponSearchRP.PageIndex) dataSet = _currentDAO.ManageCouponPagedSearch(manageCouponSearchRP.CouponTypeID, manageCouponSearchRP.CouponName, manageCouponSearchRP.CouponUseStatus, manageCouponSearchRP.CouponStatus, manageCouponSearchRP.BeginTime, manageCouponSearchRP.EndTime, manageCouponSearchRP.CouponCode, manageCouponSearchRP.Comment, manageCouponSearchRP.UseTime, manageCouponSearchRP.CreateByName, manageCouponSearchRP.UseEndTime, pageIndex, pageSize); DataTable dataTable = dataSet.Tables[0]; //删除不需要的列 dataTable.Columns.Remove("CouponID"); dataTable.Columns.Remove("CouponDesc"); dataTable.Columns.Remove("CouponTypeID"); dataTable.Columns.Remove("BeginDate"); dataTable.Columns.Remove("EndDate"); dataTable.Columns.Remove("CouponUrl"); dataTable.Columns.Remove("ImageUrl"); dataTable.Columns.Remove("Status"); dataTable.Columns.Remove("CreateTime"); dataTable.Columns.Remove("CreateBy"); dataTable.Columns.Remove("LastUpdateTime"); dataTable.Columns.Remove("LastUpdateBy"); dataTable.Columns.Remove("IsDelete"); dataTable.Columns.Remove("CouponPwd"); dataTable.Columns.Remove("CollarCardMode"); dataTable.Columns.Remove("CustomerID"); dataTable.Columns.Remove("IsDel"); dataTable.Columns.Remove("CouponUseStatus"); dataTable.Columns.Remove("CoupnName"); dataTable.Columns.Remove("DoorID"); for (int i = 1; i <= 50; i++) { dataTable.Columns.Remove("Col" + i); } dataTable.Columns["RowNo"].ColumnName = "序号"; dataTable.Columns["CouponCode"].ColumnName = "优惠券号"; dataTable.Columns["CouponName"].ColumnName = "优惠券名称"; dataTable.Columns["CreateByName"].ColumnName = "核销人"; dataTable.Columns["Comment"].ColumnName = "组单号"; dataTable.Columns["UseTime"].ColumnName = "核销日期"; dataTable.Columns["CouponTypeName"].ColumnName = "优惠券类型"; if (dataSet != null) { return(dataTable); } else { return(null); } }