public ContentResult GetViewReciptList(Lib.GridPager pager, string orderCode, string startTime, string endTime) { IQueryable <T_Receipt> list = db.T_Receipt.Where(s => s.IsDelete == 0).AsQueryable(); if (!string.IsNullOrWhiteSpace(orderCode)) { list = list.Where(s => s.OrderCode.Equals(orderCode)); } if (!string.IsNullOrWhiteSpace(startTime)) { DateTime start = Convert.ToDateTime(startTime + " 00:00:00"); list = list.Where(s => s.Date >= start); } if (!string.IsNullOrWhiteSpace(endTime)) { DateTime end = Convert.ToDateTime(endTime + " 23:59:59"); list = list.Where(s => s.Date <= end); } pager.totalRows = list.Count(); List <T_Receipt> querData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetHandwrittenExpressList(Lib.GridPager pager, string queryStr) { string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); IQueryable <T_HandwrittenExpress> queryData = db.T_HandwrittenExpress.Where(a => a.Isdelete == 0).AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Telephone != null && a.Telephone.Contains(queryStr)); } pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_HandwrittenExpress> list = new List <T_HandwrittenExpress>(); foreach (var item in queryData) { T_HandwrittenExpress i = new T_HandwrittenExpress(); item.Warehouse = Com.GetWarehouseName(item.Warehouse); i = item; list.Add(i); } //分页 // List<T_ManualBilling> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetDepartmentActivityList(Lib.GridPager pager, string queryStr, int isMy = 0, int isUncheck = 0) { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); IQueryable <T_DepartmentActivity> queryData = db.T_DepartmentActivity.Where(a => a.isDelete == 0); if (isMy == 1) { queryData = queryData.Where(a => a.PostUser == name); } else if (isUncheck == 1) { int[] step = (from r in db.T_DepartmentActivityConfig where r.isMultiple == "1" && r.Name.Contains(name) select r.Step).ToArray(); queryData = queryData.Where(a => (a.Status == -1 || a.Status == 0) && (a.CurrentApprove == name || step.Contains(a.Step))); } if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.PostUser != null && a.PostUser.Contains(queryStr)); } pager.totalRows = queryData.Count(); //分页 List <T_DepartmentActivity> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetManualExpressList(Lib.GridPager pager, string queryStr, string DetailsQuery) { string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); IQueryable <T_ManualExpress> queryData = db.T_ManualExpress.Where(a => a.Isdelete == 0).AsQueryable(); if (!string.IsNullOrEmpty(DetailsQuery)) { queryData = db.Database.SqlQuery <T_ManualExpress>("select * from T_ManualExpress where ID in (select oid from T_ManualExpressDetail where express like '%" + DetailsQuery + "%'or Remarks like '%" + DetailsQuery + "%')and IsDelete = '0'").AsQueryable(); } if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Reason != null && a.Reason.Contains(queryStr) || a.ApplyName != null && a.ApplyName.Contains(queryStr)); } pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_ManualExpress> list = new List <T_ManualExpress>(); foreach (var item in queryData) { T_ManualExpress i = new T_ManualExpress(); i = item; list.Add(i); } //分页 // List<T_ManualBilling> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
//获取苏宁订单数据 public ContentResult GetSuningList(Lib.GridPager pager, string queryStr, string sel) { IQueryable <T_HtSuNing> queryData = db.T_HtSuNing.AsQueryable(); if (!string.IsNullOrWhiteSpace(queryStr)) { queryData = queryData.Where(a => a.OrderNumber.Contains(queryStr)); } if (!string.IsNullOrWhiteSpace(sel)) { int s = Convert.ToInt32(sel); queryData = queryData.Where(a => a.Istijiao.Equals(s)); } else { queryData = queryData.Where(a => a.Istijiao.Equals(0)); } if (queryData != null) { List <T_HtSuNing> list = queryData.OrderByDescending(a => a.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); pager.totalRows = queryData.Count(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); } else { return(Content("")); } }
public ContentResult GetMailSample(Lib.GridPager pager, string queryStr) { string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); IQueryable <T_MailSample> queryData = db.T_MailSample.Where(a => a.ApplyName == Nickname && a.Isdelete == 0).AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.OrderNumber != null && a.OrderNumber.Contains(queryStr)); } pager.totalRows = queryData.Count(); //分页 queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_MailSample> list = new List <T_MailSample>(); foreach (var item in queryData) { T_MailSample i = new T_MailSample(); item.DeliverGoodsWarehouse = GetWarehouseString(item.DeliverGoodsWarehouse); i = item; list.Add(i); } // List<T_ManualBilling> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
/// <summary> /// 支付宝账单 /// </summary> /// <param name="pager"></param> /// <param name="orderNumber"></param> /// <param name="shopName"></param> /// <returns></returns> public ContentResult GetaLicostList(Lib.GridPager pager, string orderNumber, string shopName) { IQueryable <T_ZD_Cost> list = db.T_ZD_Cost.AsQueryable(); if (!string.IsNullOrWhiteSpace(orderNumber)) { list = list.Where(s => s.Number.Equals(orderNumber)); } if (!string.IsNullOrWhiteSpace(shopName)) { list = list.Where(s => s.DepartName.Equals(shopName)); } pager.totalRows = list.Count(); //List<FinancialCost> footList = new List<FinancialCost>(); //FinancialCost foot = new FinancialCost //{ // DepartName = "总计:", // Cost = list.Count() > 0 ? list.Sum(s => s.Cost) : "0" //}; //footList.Add(foot); List <T_ZD_Cost> querData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetInterviewList(Lib.GridPager pager, string queryStr, int isWait = 0, int isManage = 0) { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); IQueryable <T_PersonnelFile> queryData = db.T_PersonnelFile; if (isWait == 1) //待面试列表数据 { int[] step = (from r in db.T_PersonnelInterviewConfig where r.isMultiple == "1" && r.Name.Contains(name) select r.Step).ToArray(); queryData = queryData.Where(a => (a.InterviewState == -1 || a.InterviewState == 0) && (a.CurrentInterviewer == name)); } else if (isManage == 1)//简历管理数据 { queryData = queryData.Where(a => a.DemandID == null); } if (!string.IsNullOrWhiteSpace(queryStr)) { queryData = queryData.Where(a => a.TrueName != null && a.TrueName.Contains(queryStr)); } if (queryData != null) { List <T_PersonnelFile> list = queryData.OrderBy(a => a.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); pager.totalRows = queryData.Count(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); } else { return(Content("")); } }
public ContentResult PaymentListForMyList(Lib.GridPager pager, string code, int status = -2) { IQueryable <T_Payment> list = db.T_Payment.Where(s => s.PostUser.Equals(UserModel.Name) && s.IsDelete == 0).AsQueryable(); if (!string.IsNullOrWhiteSpace(code)) { list = list.Where(s => s.Reun_Code.Equals(code)); } if (status != -2) { list = list.Where(s => s.Status == status); } pager.totalRows = list.Count(); List <ExpenseCost> footerList = new List <ExpenseCost>(); ExpenseCost footer = new ExpenseCost(); footer.Car_Number = "总计:"; if (list.Count() > 0) { footer.Reun_Cost = list.Sum(s => s.Reun_Cost); } else { footer.Reun_Cost = 0; } footerList.Add(footer); List <T_Payment> querData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData, Lib.Comm.setTimeFormat()) + ",\"footer\":" + JsonConvert.SerializeObject(footerList, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetList(Lib.GridPager pager, string queryStr) { IQueryable <R_Basics> queryData = db.R_Basics.Where(a => a.IsDelete == 0); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => (a.NickName != null && a.NickName.Contains(queryStr)) || (a.Name != null && a.Name.Contains(queryStr))); } if (queryData != null) { pager.totalRows = queryData.Count(); //分页 //queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <R_Basics> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"; return(Content(json)); } else { return(Content("{\"total\":\"0 \",\"rows\":\"0\"")); } }
public ContentResult GetList(Lib.GridPager pager, string queryStr, int isUncheck = 0, int isMy = 0) { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); IQueryable <T_ToRegularWorker> queryData = db.T_ToRegularWorker.Where(a => a.isDelete == 0); if (isMy == 1) //我的转正申请 { queryData = queryData.Where(a => a.PostName == name); } else if (isUncheck == 1) //转正未审核 { int[] step = (from r in db.T_ToRegularConfig where r.isMultiple == "1" && r.Name.Contains(name) select r.Step).ToArray(); queryData = queryData.Where(a => a.CurrentApprove == name || step.Contains(a.Step)); } if (!string.IsNullOrWhiteSpace(queryStr)) { queryData = queryData.Where(a => (a.Job != null && a.Job.Contains(queryStr)) || (a.PostName.Contains(queryStr))); } if (queryData != null) { List <T_ToRegularWorker> list = queryData.OrderByDescending(a => a.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); pager.totalRows = queryData.Count(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); } else { return(Content("")); } }
/// <summary> /// 我的推广列表 /// </summary> /// <param name="pager"></param> /// <param name="query"></param> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> public ContentResult GetGeneralizeForMyList(Lib.GridPager pager, string query, int status = -2) { IQueryable <T_Generalize> list = db.T_Generalize.Where(s => s.UploadName.Equals(UserModel.Nickname) && s.IsDelete != 1).AsQueryable(); if (status != -2) { list = list.Where(s => s.Status == status); } if (!string.IsNullOrWhiteSpace(query)) { list = list.Where(s => s.StoreName.Contains(query) || s.ProductName.Contains(query) || s.ResponsibleName.Contains(query) || s.PlatformCode.Contains(query) || s.BorrowCode.Contains(query)); } pager.totalRows = list.Count(); //List<GrneralizeCost> footerList = new List<GrneralizeCost>(); //GrneralizeCost cost = new GrneralizeCost(); //cost.BankNumber = "合计:"; //if (list.Count() > 0) //{ // cost.Cost = list.Sum(s => s.Cost); // cost.CommissionCost = list.Sum(s => s.CommissionCost); //} //else //{ // cost.Cost = 0; // cost.CommissionCost = 0; //} //footerList.Add(cost); List <T_Generalize> querData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
/// <summary> /// 获取订单旗帜列表 /// </summary> /// <param name="pager"></param> /// <param name="query"></param> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> public JsonResult GetOrderListFlag(Lib.GridPager pager, string query, string startDate, string endDate) { IQueryable <GeneralizeFlag> list = null; string sql = "select paytime,shop_name,platform_code,vip_name,warehouse_name,payment,order_type_name from T_OrderList where platform_flag='4' and paytime>='" + startDate + "' and paytime<='" + endDate + "' "; if (!string.IsNullOrWhiteSpace(query)) { sql += " and shop_name = '" + query + "'"; } list = db.Database.SqlQuery <GeneralizeFlag>(sql).AsQueryable(); pager.totalRows = list.Count(); List <GeneralizeFlag> querData = list.OrderByDescending(c => c.paytime).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); var json = new { total = pager.totalRows, rows = (from r in querData select new GeneralizeFlag { paytime = r.paytime, shop_name = r.shop_name, platform_code = r.platform_code, vip_name = r.vip_name, warehouse_name = r.warehouse_name, payment = r.payment, order_type_name = r.order_type_name }).ToArray() }; return(Json(json, JsonRequestBehavior.AllowGet)); }
public ContentResult UnCheckQuitList(Lib.GridPager pager, string queryStr) { string name = Server.UrlDecode(Request.Cookies["Name"].Value); List <T_QuitApprove> ApproveMod = db.T_QuitApprove.Where(a => a.ApproveName == name && a.ApproveTime == null).ToList(); int[] Arry = new int[ApproveMod.Count]; for (int i = 0; i < ApproveMod.Count; i++) { Arry[i] = int.Parse(ApproveMod[i].Oid.ToString()); } IQueryable <T_Quit> queryData = from r in db.T_Quit where Arry.Contains(r.ID) && r.IsDelete == 0 && (r.Status == -1 || r.Status == 0 || r.Status == 2) select r; if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Code != null && a.Code.Contains(queryStr) || a.PostUser != null && a.PostUser.Contains(queryStr)); } pager.totalRows = queryData.Count(); //分页 queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_Quit> list = new List <T_Quit>(); foreach (var item in queryData) { T_Quit i = new T_Quit(); i = item; list.Add(i); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetStockDetail(Lib.GridPager pager, string queryStr, string WarehouseCode) { IQueryable <T_StockStorage> queryData = db.T_StockStorage.Where(a => a.Type == "入库").AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.SupplierName != null && a.SupplierName.Contains(queryStr)); } if (!string.IsNullOrEmpty(WarehouseCode)) { queryData = queryData.Where(a => a.WarehouseCode.Contains(WarehouseCode)); } pager.totalRows = queryData.Count(); //分页 queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_StockStorage> list = new List <T_StockStorage>(); foreach (var item in queryData) { T_StockStorage i = new T_StockStorage(); item.WarehouseCode = WarehouseByName(item.WarehouseCode); item.SupplierName = SupplierGY(item.SupplierName); i = item; list.Add(i); } // List<T_ManualBilling> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetElectronicInvoiceList(Lib.GridPager pager, string queryStr, string selStatus, string txtShop, string txtinvoiceNum, string txtName) { IQueryable <T_ElectronicInvoice> queryData = db.T_ElectronicInvoice.Where(a => a.Isdelete == "0").AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.OrderNumber != null && a.OrderNumber.Contains(queryStr) || (a.PostUser != null && a.PostUser.Contains(queryStr))); } if (!string.IsNullOrEmpty(txtinvoiceNum)) { queryData = queryData.Where(a => a.invoiceNum != null && a.invoiceNum.Contains(txtinvoiceNum)); } if (!string.IsNullOrEmpty(txtShop)) { queryData = queryData.Where(a => a.ShopName != null && a.ShopName.Contains(txtShop)); } if (!string.IsNullOrEmpty(selStatus) && selStatus != "-2") { int status = int.Parse(selStatus); queryData = queryData.Where(a => a.Status == status); } if (!string.IsNullOrEmpty(txtName)) { queryData = queryData.Where(a => a.PostUser != null && a.PostUser.Contains(txtName)); } pager.totalRows = queryData.Count(); //分页 List <T_ElectronicInvoice> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetUserList(Lib.GridPager pager, string queryStr) { //查询出所有未删除的 IQueryable <T_User> queryData = db.T_User.AsQueryable(); //根据订单号,提交者姓名,会员号码查询 if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Nickname.Contains(queryStr) || a.Name.Contains(queryStr)); } //根据状态查询 //分页 pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_User> list = new List <T_User>(); foreach (var item in queryData) { T_User i = new T_User(); i = item; list.Add(i); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult ShowQuitList(Lib.GridPager pager, string queryStr, int status) { string name = Server.UrlDecode(Request.Cookies["Name"].Value); IQueryable <T_Quit> queryData = db.T_Quit.Where(a => a.IsDelete == 0); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Code != null && a.Code.Contains(queryStr) || (a.PostUser != null && a.PostUser.Contains(queryStr))); } if (status != 9999) { queryData = queryData.Where(a => a.Status == status); } pager.totalRows = queryData.Count(); //分页 queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_Quit> list = new List <T_Quit>(); foreach (var item in queryData) { T_Quit i = new T_Quit(); i = item; list.Add(i); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetMethodList(Lib.GridPager pager, string queryStr, string method) { List <T_CashbackMethod> queryData = db.T_CashbackMethod.AsQueryable().ToList(); string sql = "select Method from T_CashbackMethod where 1=1 "; if (!string.IsNullOrEmpty(method)) { sql += " and Method = " + method + " "; } sql += " group by Method "; List <MethodMod> model = db.Database.SqlQuery <MethodMod>(sql).ToList(); for (int i = 0; i < model.Count(); i++) { string manList = ""; int _method = int.Parse(model[i].Method.ToString()); List <T_CashbackMethod> MethodList = db.T_CashbackMethod.Where(a => a.Method == _method).ToList(); for (int j = 0; j < MethodList.Count(); j++) { manList += MethodList[j].Name + ">"; } model[i].Name = manList.Substring(0, manList.Length - 1); } if (!string.IsNullOrEmpty(queryStr)) { model = model.Where(a => a.Name.Contains(queryStr)).ToList(); } //分页 pager.totalRows = model.Count(); model = model.OrderBy(c => int.Parse(c.Method.ToString())).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(model, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public JsonResult GetPrintReturn(Lib.GridPager pager, string ISqualified) { try { string name = Server.UrlDecode(Request.Cookies["Nickname"].Value); List <int> PidList = db.T_ReturnToStorage.Where(a => a.SortingName == name).Select(a => a.ID).ToList(); if (ISqualified == "合格") //合格数据 { List <ReturnPrintQualifiedData_Result> list = db.ReturnPrintQualifiedData(name).ToList(); pager.totalRows = list.Count; list = list.OrderByDescending(s => s.item_code).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); return(Json(new { total = pager.totalRows, rows = list }, JsonRequestBehavior.AllowGet)); } else { List <ReturnPrintUnqualifiedData_Result> list = db.ReturnPrintUnqualifiedData(name).ToList(); pager.totalRows = list.Count; list = list.OrderByDescending(s => s.item_code).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); return(Json(new { total = pager.totalRows, rows = list }, JsonRequestBehavior.AllowGet)); } //string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; } catch (Exception e) { return(Json(new { total = 0 }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 查询配件详情 /// </summary> /// <param name="pager"></param> /// <param name="query"></param> /// <returns></returns> public ContentResult GetGoodsGyPartsList(Lib.GridPager pager, string query, string Code) { List <T_GoodsGyParts> model = db.T_GoodsGyParts.Where(a => a.goodsGyCode == Code).ToList(); string goodsCode = ""; for (int i = 0; i < model.Count; i++) { if (i == 0) { goodsCode += "'" + model[i].PartsCode + "'"; } else { goodsCode += "," + "'" + model[i].PartsCode + "'"; } } string sql = "select * from T_goodsGY where code in (" + goodsCode + ")"; IQueryable <T_goodsGY> list = db.Database.SqlQuery <T_goodsGY>(sql).AsQueryable(); if (!string.IsNullOrWhiteSpace(query)) { list = list.Where(s => s.code.Contains(query) || s.name.Contains(query)); } pager.totalRows = list.Count(); List <T_goodsGY> queryData = list.OrderByDescending(a => a.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(queryData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetHandwrittenExpressCheck(Lib.GridPager pager, string queryStr) { string name = Server.UrlDecode(Request.Cookies["Name"].Value); string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value); List <T_HandwrittenExpressGroup> GroupModel = db.T_HandwrittenExpressGroup.Where(a => a.Crew != null && (a.Crew.Contains(name) || a.Crew.Contains(Nickname))).ToList(); string[] shenheName = new string[GroupModel.Count]; for (int z = 0; z < GroupModel.Count; z++) { shenheName[z] = GroupModel[z].GroupName; } List <T_HandwrittenExpressAppRove> ApproveMod = db.T_HandwrittenExpressAppRove.Where(a => (shenheName.Contains(a.ApproveName) || a.ApproveName == name || a.ApproveName == Nickname) && a.ApproveTime == null).ToList(); string arrID = ""; for (int i = 0; i < ApproveMod.Count; i++) { if (i == 0) { arrID += ApproveMod[i].Oid.ToString(); } else { arrID += "," + ApproveMod[i].Oid.ToString(); } } string sql = "select * from T_HandwrittenExpress r where isdelete=0 and (Status = -1 or Status = 0 or Status = 2) "; if (arrID != null && arrID != "") { sql += " and ID in (" + arrID + ")"; } else { sql += " and 1=2"; } IQueryable <T_HandwrittenExpress> queryData = db.Database.SqlQuery <T_HandwrittenExpress>(sql).AsQueryable(); // IQueryable<T_MajorInvoice> queryData = db.T_MajorInvoice.Where(a=>a.).AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { queryData = queryData.Where(a => a.Telephone != null && a.Telephone.Contains(queryStr)); } pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows); List <T_HandwrittenExpress> list = new List <T_HandwrittenExpress>(); foreach (var item in queryData) { T_HandwrittenExpress i = new T_HandwrittenExpress(); item.Warehouse = Com.GetWarehouseName(item.Warehouse); i = item; list.Add(i); } //分页 // List<T_ManualBilling> list = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetList(Lib.GridPager pager, string queryStr, string startSendTime, string endSendTime) { var list = db.T_Deliver.AsQueryable(); //根据名称或者单号查询 if (!string.IsNullOrWhiteSpace(queryStr)) { list = list.Where(s => s.MailNo.Equals(queryStr) || s.PostName.Equals(queryStr)); } //根据日期查询 if (!string.IsNullOrWhiteSpace(startSendTime) && !string.IsNullOrWhiteSpace(endSendTime)) { DateTime startTime = DateTime.Parse(startSendTime); DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59"); list = list.Where(s => s.PostTime >= startTime && s.PostTime <= endTime); } else if (!string.IsNullOrWhiteSpace(startSendTime)) { DateTime startTime = DateTime.Parse(startSendTime); DateTime endTime = startTime.AddDays(5); list = list.Where(s => s.PostTime >= startTime); } else if (!string.IsNullOrWhiteSpace(endSendTime)) { DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59"); DateTime startTime = endTime.AddDays(-5); list = list.Where(s => s.PostTime <= endTime); } //分页 pager.totalRows = list.Count(); var queryData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).Select(item => new { item.ID, item.MailNo, item.WarehouseCode, item.Note, item.OrderNum, item.PostName, item.PostTime }); //结果集合重新包装成需要的数据返回 List <listResult> ResultMod = new List <listResult>(); foreach (var item in queryData) { listResult ietmMOD = new listResult(); ietmMOD.ID = item.ID; ietmMOD.MailNo = item.MailNo; ietmMOD.Note = item.Note; ietmMOD.OrderNum = item.OrderNum; ietmMOD.PostName = item.PostName; ietmMOD.PostTime = item.PostTime; ietmMOD.WarehouseCode = getWarehouse(item.WarehouseCode); ResultMod.Add(ietmMOD); } string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(ResultMod, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public JsonResult GetCollectionCostList(Lib.GridPager pager, string number, string overStartTime, string overEndTime, string settementStartTime, string settementEndTime, string ordersFrom) { IQueryable <CollectionQuidco> queryData = null; string sql = string.Format(@"select c.Number,c.OverTime, c.OrdersFrom,c.CollectionMoney,c.FinanceQuidcoDate,c.FinanceQuidcoStatus, cs.ReceiveCompany,cs.ReceivableCost,cs.SendCompany,cs.ReceivableCostBySend,cs.SettlementDate from T_CollectionQuidcoStatus(NOLOCK) c inner join T_CollectionServiceCost(NOLOCK) cs on cs.Number=c.Number where 1=1"); if (!string.IsNullOrWhiteSpace(overStartTime)) { sql += " AND c.OverTime>='" + overStartTime + " 00:00:00" + "'"; } if (!string.IsNullOrWhiteSpace(overEndTime)) { sql += " AND c.OverTime<='" + overEndTime + " 23:59:59" + "'"; } if (!string.IsNullOrEmpty(settementStartTime)) { sql += " AND cs.SettlementDate>='" + settementStartTime + "'"; } if (!string.IsNullOrWhiteSpace(settementEndTime)) { sql += " AND cs.SettlementDate<='" + settementStartTime + "'"; } if (!string.IsNullOrWhiteSpace(number)) { sql += " AND c.Number LIKE '%" + number + "%'"; } if (!string.IsNullOrWhiteSpace(ordersFrom)) { sql += " AND c.OrdersFrom LIKE '%" + ordersFrom + "%'"; } queryData = db.Database.SqlQuery <CollectionQuidco>(sql).AsQueryable(); pager.totalRows = queryData.Count(); queryData = queryData.OrderByDescending(s => s.OverTime).Skip((pager.page - 1) * pager.rows).Take(pager.rows); var json = new { total = pager.totalRows, rows = (from c in queryData select new CollectionQuidco { Number = c.Number, OverTime = c.OverTime, OrdersFrom = c.OrdersFrom, CollectionMoney = c.CollectionMoney, FinanceQuidcoDate = c.FinanceQuidcoDate, FinanceQuidcoStatus = c.FinanceQuidcoStatus, ReceiveCompany = c.ReceiveCompany, ReceivableCost = c.ReceivableCost, SendCompany = c.SendCompany, ReceivableCostBySend = c.ReceivableCostBySend, SettlementDate = c.SettlementDate }).ToArray() }; return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult GetOrderProductList(Lib.GridPager pager, string productName, string startDate, string endDate) { string sql = string.Format(@"select cd.item_code as Code,convert(nvarchar(10),c.createtime,120) as OdersTime, cd.item_name as ProductName,ISNULL(SUM(cd.qty),0) as Num,ISNULL(SUM(cd.amount_after),0) as Amount, ISNULL(SUM(cb.cost_price*cd.qty),0) as Cost,ISNULL(SUM(eq.Total),0) as ExpressCost, (ISNULL(SUM(cd.amount_after),0)-ISNULL(SUM(cb.cost_price*cd.qty),0))-ISNULL(SUM(eq.Total),0) Profit from T_OrderDetail cd inner join T_OrderList c on cd.oid=c.code left join T_goodsGY cb on cb.code=cd.item_code left join T_ExpressMoney_Query eq on eq.Number=c.mail_no WHERE 1=1"); if (!string.IsNullOrWhiteSpace(productName)) { sql += " AND cd.item_name like'%" + productName + "%' OR cd.item_code like'%" + productName + "%'"; } if (!string.IsNullOrWhiteSpace(startDate)) { sql += " AND convert(nvarchar(10),c.createtime,120)>='" + startDate + "'"; } if (!string.IsNullOrWhiteSpace(endDate)) { sql += " AND convert(nvarchar(10),c.createtime,120)<='" + endDate + "'"; } sql += " group by convert(nvarchar(10),c.createtime,120),cd.item_name,cd.item_code order by convert(nvarchar(10),c.createtime,120) desc"; IQueryable <OrdersProduct> list = db.Database.SqlQuery <OrdersProduct>(sql).AsQueryable(); pager.totalRows = list.Count(); List <OrdersProduct1> listSum = new List <OrdersProduct1>(); OrdersProduct1 model = new OrdersProduct1(); model.ProductName = "总费用:"; model.Amount = list.Sum(s => s.Amount); model.Cost = list.Sum(s => s.Cost); model.ExpressCost = list.Sum(s => s.ExpressCost); model.Profit = list.Sum(s => s.Profit); listSum.Add(model); List <OrdersProduct> querData = list.Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); var json = new { total = pager.totalRows, rows = (from c in querData select new OrdersProduct { Code = c.Code, OdersTime = c.OdersTime, ProductName = c.ProductName, Num = c.Num, Amount = c.Amount, Cost = c.Cost, ExpressCost = c.ExpressCost, Profit = c.Profit }).ToArray(), footer = listSum }; return(Json(json, JsonRequestBehavior.AllowGet)); }
public ContentResult GetList(Lib.GridPager pager, string queryStr, string seasonSel, string startSendTime, string endSendTime, string finalsSel) { var list = db.T_MeetShare.Where(a => a.IsDel == 0).AsQueryable(); if (!string.IsNullOrEmpty(queryStr)) { list = list.Where(a => a.Name == queryStr); } if (!string.IsNullOrEmpty(seasonSel)) { int _seasonSel = int.Parse(seasonSel); list = list.Where(a => a.Season == _seasonSel); } if (!string.IsNullOrEmpty(finalsSel)) { int _finalsSel = int.Parse(finalsSel); list = list.Where(a => a.Finals == _finalsSel); } //根据日期查询 if (!string.IsNullOrWhiteSpace(startSendTime) && !string.IsNullOrWhiteSpace(endSendTime)) { DateTime startTime = DateTime.Parse(startSendTime); DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59"); list = list.Where(s => s.ShareDate >= startTime && s.ShareDate <= endTime); } else if (!string.IsNullOrWhiteSpace(startSendTime)) { DateTime startTime = DateTime.Parse(startSendTime); DateTime endTime = startTime.AddDays(5); list = list.Where(s => s.ShareDate >= startTime); } else if (!string.IsNullOrWhiteSpace(endSendTime)) { DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59"); DateTime startTime = endTime.AddDays(-5); list = list.Where(s => s.ShareDate <= endTime); } pager.totalRows = list.Count(); var queryData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).Select(item => new { item.ID, item.Name, item.Score, item.ShareDate, item.Total, item.Season, item.IsEnd, item.Finals }); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(queryData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetReceiptDetail(int receiptId, Lib.GridPager pager) { List <T_ReceiptDetails> list = db.T_ReceiptDetails.Where(s => s.ReceiptOrderID == receiptId).ToList(); pager.totalRows = list.Count(); List <T_ReceiptDetails> querData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData) + "}"; return(Content(json)); }
public ContentResult GetViewDetailsList(Lib.GridPager pager, string oid) { IQueryable <T_OrderDetail> detailList = db.T_OrderDetail.Where(s => s.oid.Equals(oid)); pager.totalRows = detailList.Count(); List <T_OrderDetail> querData = detailList.OrderByDescending(s => s.id).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(querData, Lib.Comm.setTimeFormat()) + "}"; return(Content(json)); }
public ContentResult GetDetailList(Lib.GridPager pager, int ID) { var list = db.T_DeliverDetail.Where(a => a.Oid == ID); pager.totalRows = list.Count(); var queryData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(queryData) + "}"; return(Content(json)); }
public ContentResult GetJPWOrdersDetailList(Lib.GridPager pager, string code) { IQueryable <T_ManualorderDetail> list = db.T_ManualorderDetail.Where(s => s.OrderCode.Equals(code)); pager.totalRows = list.Count(); List <T_ManualorderDetail> queryData = list.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(queryData) + "}"; return(Content(json)); }