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