// <summary> ///条件查询盘点计划(记录列表) /// </summary> /// <returns></returns> public ActionResult TiaoSelectCheckgh(Vo.BsgridPage bsgridPage, int StockPlaceID, string Remter) { var linq = (from tbGoodBiao in MyModels.B_CheckRemerbenList join tbStock in MyModels.S_StockPlaceList on tbGoodBiao.StockPlaceID equals tbStock.StockPlaceID where tbGoodBiao.Remter == Remter && tbGoodBiao.GoodsNot == false || tbGoodBiao.StockPlaceID == StockPlaceID && tbGoodBiao.GoodsNot == false select new LY.WareHouseDeitaLL { CheckRermeberID = tbGoodBiao.CheckRermeberID, Remember = tbGoodBiao.Remter, PablData = tbGoodBiao.PablData.ToString(), CommodityType = tbGoodBiao.CommodityType, DrugType = tbGoodBiao.DrugType, StockPlaceName = tbStock.StockPlaceName, ExamineName = tbGoodBiao.ExamineName, ExamineTime = tbGoodBiao.ExamineTime.ToString(), }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsChopID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 点击 查询 进仓单 /// </summary> /// <param name=""></param> /// <returns></returns> public ActionResult ChaXunJinCang(Vo.BsgridPage bsgridPage) { var linq = (from tbSelectWanHtsList in myModels.B_WareHouseList //进仓单ID join tbHeTong in myModels.B_OrderFormPactList on tbSelectWanHtsList.OrderFormPactID equals tbHeTong.OrderFormPactID //合同ID join tbPeiHuoBuMen in myModels.S_SpouseBRanchList on tbSelectWanHtsList.SpouseBRanchID equals tbPeiHuoBuMen.SpouseBRanchID //配货部门 join tbKuCuDiDian in myModels.S_StockPlaceList on tbSelectWanHtsList.StockPlaceID equals tbKuCuDiDian.StockPlaceID //库存地点 where tbSelectWanHtsList.ExamineNot == true && tbSelectWanHtsList.QuFenLeiXingID == 1 && tbSelectWanHtsList.CrushRedNot == false || tbSelectWanHtsList.ExamineNot == true && tbSelectWanHtsList.QuFenLeiXingID == 2 && tbSelectWanHtsList.CrushRedNot == false select new LY.WareHouseDeitaLL { WareHouseID = tbSelectWanHtsList.WareHouseID, //进仓ID Remember = tbSelectWanHtsList.Remember, //进仓编号 ContractNumber = tbHeTong.ContractNumber, //合同编号 SpouseBRanchName = tbPeiHuoBuMen.SpouseBRanchName, //进货部门 StockPlaceName = tbKuCuDiDian.StockPlaceName, //库存地点 RegisterName = tbSelectWanHtsList.RegisterName, // RegisterTime = tbSelectWanHtsList.RegisterTime.ToString(), // ExamineName = tbSelectWanHtsList.ExamineName, // ExamineTime = tbSelectWanHtsList.ExamineTime.ToString(), // }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.WareHouseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询 转库单 /// </summary> /// <param name=""></param> /// <returns></returns> public ActionResult ChaXunZhuanKu(Vo.BsgridPage bsgridPage) { var linq = (from tbZhuanKu in myModels.B_ChangeList //转库单ID join tbPeiHuoBuMen in myModels.S_SpouseBRanchList on tbZhuanKu.SpouseBRanchID equals tbPeiHuoBuMen.SpouseBRanchID //部门 join tbKuCuDiDian in myModels.S_StockPlaceList on tbZhuanKu.StockPlaceID equals tbKuCuDiDian.StockPlaceID //原库存地点 join tbNewKuCuDiDian in myModels.S_StockPlaceList on tbZhuanKu.StockPlaceIDtwo equals tbNewKuCuDiDian.StockPlaceID //新库存地点 where tbZhuanKu.ExamineNot == false select new LY.PeiHuoDan { ChangeID = tbZhuanKu.ChangeID, WareHouseID = tbZhuanKu.WareHouseID, Remember = tbZhuanKu.Remember, SpouseBRanchName = tbPeiHuoBuMen.SpouseBRanchName, StockPlaceName = tbKuCuDiDian.StockPlaceName, StockPlaceNametwo = tbNewKuCuDiDian.StockPlaceName, payName = tbZhuanKu.payName, furlName = tbZhuanKu.furlName, RegisterName = tbZhuanKu.RegisterName, registerTime = tbZhuanKu.RegisterTime.ToString() }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ChangeID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询要货单 /// </summary> /// <param name="bsgridPage"></param> /// <param name="stockPlaceID"></param> /// <returns></returns> public ActionResult SelectWanMetr(Vo.BsgridPage bsgridPage) { var linq = (from tbWanMetre in myModels.B_WanManifestList//要货单 join tbSpatouKrdg in myModels.S_SpouseBRanchList on tbWanMetre.PurchaseSectionID equals tbSpatouKrdg.SpouseBRanchID select new LY.PeiHuoDan { WanManifestID = tbWanMetre.WanManifestID, SellID = tbWanMetre.SellID, //要货id Remember = tbWanMetre.Remember, //编号 SpouseBRanchName = tbSpatouKrdg.SpouseBRanchName, //部门 RegisterName = tbWanMetre.RegisterName, //制单人 registerTime = tbWanMetre.RegisterTime.ToString(), //制单时间 ExamineName = tbWanMetre.ExamineName, //制单人 examineTime = tbWanMetre.ExamineTime.ToString(), //制单时间 ExamineNot = tbWanMetre.ExamineNot // }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ConverID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询进仓单(一) /// </summary> /// <param name="bsgridPage"></param> /// <returns></returns> public ActionResult ChaXunWareFonf(Vo.BsgridPage bsgridPage, int GongHuoBianHao, int AdjLeiXing) { string dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd"); DateTime d = Convert.ToDateTime(dateTimeNow); var Linq = from tbWaerHouse in myModels.B_WareHouseList join tbStall in myModels.B_StaffList on tbWaerHouse.StaffID equals tbStall.StaffID //员工 join tbQuFen in myModels.S_QuFenLeiXingList on tbWaerHouse.QuFenLeiXingID equals tbQuFen.QuFenLeiXingID //区分类型 join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID //合同 join tbAdjLeiXing in myModels.S_AdjustAccountsFashionList on tbHeTong.AdjustAccountsFashionID equals tbAdjLeiXing.AdjustAccountsFashionID join tbSupplier in myModels.B_SupplierList on tbHeTong.SupplierID equals tbSupplier.SupplierID //供货商 join tbJieSuan in myModels.S_MethodOfSettlingAccountsList on tbHeTong.MethodOfSettlingAccountsID equals tbJieSuan.MethodOfSettlingAccountsID //结算 where tbWaerHouse.ExamineNot == true && tbWaerHouse.Status == true && tbWaerHouse.CrushRedNot == false && tbWaerHouse.ExamineTime == d select new LY.WareHouseDeitaLL { WareHouseID = tbWaerHouse.WareHouseID, //进仓ID Remember = tbWaerHouse.Remember, //进仓编号 OrderFormPactID = tbHeTong.OrderFormPactID, //合同ID ContractNumber = tbHeTong.ContractNumber, //合同编号 MethodOfSettlingAccounts = tbJieSuan.MethodOfSettlingAccounts, //结算方式 SupplierCHName = tbSupplier.SupplierCHName, //供货商名称 StaffID = tbStall.StaffID, //员工ID StaffCode = tbStall.StaffCode, //员工编号 StaffName = tbStall.StaffName, //姓名 RegisterTime = tbWaerHouse.RegisterTime.ToString(), //登记时间 ExamineNot = tbWaerHouse.ExamineNot, //审核状态 Status = tbWaerHouse.Status, //生效状态 CrushRedNot = tbWaerHouse.CrushRedNot, //冲红状态 QuFenLeiXingID = tbQuFen.QuFenLeiXingID, //区分ID QuFenLeiXingMC = tbQuFen.QuFenLeiXingMC, //区分 SupplierID = tbSupplier.SupplierID, AdjustAccountsFashionID = tbAdjLeiXing.AdjustAccountsFashionID, }; //区分ID不为空(因为是下拉框) if (GongHuoBianHao > 0) { Linq = Linq.Where(p => p.SupplierID == GongHuoBianHao); } if (AdjLeiXing > 0) { Linq = Linq.Where(p => p.AdjustAccountsFashionID == AdjLeiXing); } int totalRow = Linq.Count(); List <LY.WareHouseDeitaLL> notices = Linq.OrderByDescending(p => p.Remember). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询盘点表(条件) /// </summary> /// <returns></returns> public ActionResult TiaoSelectHoaSun(Vo.BsgridPage bsgridPage, DateTime chertempatd) { var linq = (from tbCheckRemerben in myModels.B_CheckRemerbenList //计划盘点表 join tbPanlBuMen in myModels.B_PanlList on tbCheckRemerben.DrugTypeID equals tbPanlBuMen.DrugTypeID //盘点部门表 join tbDerterm in myModels.B_DepatmenList on tbPanlBuMen.DrugTypeID equals tbDerterm.DrugTypeID where tbCheckRemerben.Entering == true && tbCheckRemerben.PablData == chertempatd select new LY.WareHouseDeitaLL { CheckRermeberID = tbCheckRemerben.CheckRermeberID, // Remter = tbCheckRemerben.Remter, // EnteringTime = tbCheckRemerben.PablData.ToString(), // RegisterTime = tbCheckRemerben.EnteringTime.ToString(), // departmentCodes = tbDerterm.departmentCodes, // departmentName = tbDerterm.departmentName, // }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsClassifyID). Skip(bsgridPage.GetStartIndex()).//F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
///查询损益 /// </summary> /// <returns></returns> public ActionResult SelectInsfdr(Vo.BsgridPage bsgridPage) { var linq = (from tbIncrea in MyModels.B_IncreaseList join tbbumen in MyModels.B_PanlList on tbIncrea.DrugTypeID equals tbbumen.DrugTypeID join tbKuCun in MyModels.S_StockPlaceList on tbIncrea.StockPlaceID equals tbKuCun.StockPlaceID where tbIncrea.ExamineNot == false select new LY.WareHouseDeitaLL { IncreaseID = tbIncrea.IncreaseID, Remember = tbIncrea.Remember, IncreaseCause = tbIncrea.IncreaseCause, DrugType = tbbumen.DrugType, StockPlaceName = tbKuCun.StockPlaceName, RegisterName = tbIncrea.RegisterName, RegisterTime = tbIncrea.RegisterTime.ToString(), }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsChopID).//noboer表达式 Skip(bsgridPage.GetStartIndex()). Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询(员工表) /// </summary> /// <returns></returns> public ActionResult SelectYuanGong(Vo.BsgridPage bsgridPage) { var linq = (from tbYuanGong in myModels.B_StaffList join tbStaffName in myModels.S_StaffClassList on tbYuanGong.StaffClassID equals tbStaffName.StaffClassID where tbYuanGong.StaffClassID == 3 select new Vo.Staffl { StaffID = tbYuanGong.StaffID, StaffName = tbYuanGong.StaffName, StaffCode = tbYuanGong.StaffCode }).ToList(); int totalRow = linq.Count(); List <Vo.Staffl> notices = linq.OrderByDescending(p => p.StaffID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <Vo.Staffl> bsgrid = new Vo.Bsgrid <Vo.Staffl>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询返仓单 /// </summary> /// <param name="bsgridPage"></param> /// <param name="stockPlaceID"></param> /// <returns></returns> public ActionResult SelectSellctRect(Vo.BsgridPage bsgridPage) { var linq = (from tbSellct in MyModels.B_SellRetuerList//返仓单 join tbSpuBuMen in MyModels.S_StockPlaceList on tbSellct.StockPlaceID equals tbSpuBuMen.StockPlaceID where tbSellct.ExamineNot == false select new LY.PeiHuoDan { SellRetuerID = tbSellct.SellRetuerID, //返仓id SellID = tbSellct.SellID, //销售id Remember = tbSellct.Remember, //返仓单编号 StockPlaceName = tbSpuBuMen.StockPlaceName, //收货部门 payName = tbSellct.payName, //实物付 furlName = tbSellct.furlName, //实物收 Remarks = tbSellct.Remarks, //备注 RegisterName = tbSellct.RegisterName, //制单 registerTime = tbSellct.RegisterTime.ToString(), //时间 }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.SellRetuerID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
// <summary> ///查询盘点计划 /// </summary> /// <returns></returns> public ActionResult SelectCheck(Vo.BsgridPage bsgridPage) { string dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd");//获取当前时间 DateTime d = Convert.ToDateTime(dateTimeNow); var linq = (from tbGoodBiao in MyModels.B_CheckRemerbenList join tbStock in MyModels.S_StockPlaceList on tbGoodBiao.StockPlaceID equals tbStock.StockPlaceID where tbGoodBiao.PablData == d select new LY.WareHouseDeitaLL { CheckRermeberID = tbGoodBiao.CheckRermeberID, PablData = tbGoodBiao.PablData.ToString(), CommodityType = tbGoodBiao.CommodityType, DrugType = tbGoodBiao.DrugType, StockPlaceName = tbStock.StockPlaceName, ExamineName = tbGoodBiao.ExamineName, ExamineTime = tbGoodBiao.ExamineTime.ToString(), }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsChopID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询配货单 /// </summary> /// <returns></returns> public ActionResult SelectConverList(Vo.BsgridPage bsgridPage) { var linq = (from tbConverlist in MyModels.B_ConverList join tbFaHuoBuMen in MyModels.S_SpouseBRanchList on tbConverlist.SpouseBRanchID equals tbFaHuoBuMen.SpouseBRanchID join tbShouHuoBuMen in MyModels.S_StockPlaceList on tbConverlist.StockPlaceID equals tbShouHuoBuMen.StockPlaceID where tbConverlist.ExamineNot == true select new LY.PeiHuoDan { ConverID = tbConverlist.ConverID, //id P_Remember = tbConverlist.P_Remember, //编号 payName = tbConverlist.payName, furlName = tbConverlist.furlName, SpouseBRanchName = tbFaHuoBuMen.SpouseBRanchName, StockPlaceName = tbShouHuoBuMen.StockPlaceName, Remarks = tbConverlist.Remarks }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ConverID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
//不用了 //public ActionResult ChaXunWareFonGuiTai(Vo.BsgridPage bsgridPage) //{ // //tbWaerHouse.ExamineNot == true && tbWaerHouse.Status == true && tbWaerHouse.CrushRedNot == false && // var Linq = from tbWaerHouse in myModels.B_WareHouseList // join tbStoucRcu in myModels.S_StockPlaceList on tbWaerHouse.StockPlaceID equals tbStoucRcu.StockPlaceID // join tbStall in myModels.B_StaffList on tbWaerHouse.StaffID equals tbStall.StaffID//员工 // join tbQuFen in myModels.S_QuFenLeiXingList on tbWaerHouse.QuFenLeiXingID equals tbQuFen.QuFenLeiXingID//区分类型 // join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID//合同 // join tbSupplier in myModels.B_SupplierList on tbHeTong.SupplierID equals tbSupplier.SupplierID//供货商 // join tbJieSuan in myModels.S_MethodOfSettlingAccountsList on tbHeTong.MethodOfSettlingAccountsID equals tbJieSuan.MethodOfSettlingAccountsID//结算 // join tbWanHouDateil in myModels.B_WareHouseDetiailList on tbWaerHouse.WareHouseID equals tbWanHouDateil.WareHouseID//明细 // join tbGoods in myModels.B_GoodsList on tbWanHouDateil.OrderFormDetailID equals tbGoods.GoodsID // join tbCheckemDateil in myModels.B_CheckRemerbenDetillList on tbGoods.GoodsID equals tbCheckemDateil.GoodsID//明细 // join tbChemckem in myModels.B_CheckRemerbenList on tbCheckemDateil.CheckRermeberID equals tbChemckem.CheckRermeberID // where tbStoucRcu.StockPlaceID == 4 // select new LY.WareHouseDeitaLL // { // WareHouseID = tbWaerHouse.WareHouseID,//进仓ID // Remember = tbWaerHouse.Remember,//进仓编号 // OrderFormPactID = tbHeTong.OrderFormPactID,//合同ID // ContractNumber = tbHeTong.ContractNumber,//合同编号 // MethodOfSettlingAccounts = tbJieSuan.MethodOfSettlingAccounts,//结算方式 // SupplierCHName = tbSupplier.SupplierCHName,//供货商名称 // StaffCode = tbStall.StaffCode,//员工编号 // StaffName = tbStall.StaffName,//姓名 // RegisterTime = tbWaerHouse.RegisterTime.ToString(),//登记时间 // ExamineNot = tbWaerHouse.ExamineNot,//审核状态 // Status = tbWaerHouse.Status,//生效状态 // CrushRedNot = tbWaerHouse.CrushRedNot,//冲红状态 // QuFenLeiXingMC = tbQuFen.QuFenLeiXingMC//区分 // }; // int totalRow = Linq.Count(); // List<LY.WareHouseDeitaLL> notices = Linq.OrderByDescending(p => p.WareHouseID).//noboer表达式 // Skip(bsgridPage.GetStartIndex()).//F12(看) // Take(bsgridPage.pageSize). // ToList(); // Vo.Bsgrid<LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid<LY.WareHouseDeitaLL>(); // bsgrid.success = true; // bsgrid.totalRows = totalRow;//总的行数 // bsgrid.curPage = bsgridPage.curPage;//请求当前页 // bsgrid.data = notices;//查出的数据 // return Json(bsgrid, JsonRequestBehavior.AllowGet); //} /// <summary> /// 查询对应商品(二) /// </summary> /// <param name="bsgridPage"></param> /// <returns></returns> public ActionResult ChaXunShangPinPanl(Vo.BsgridPage bsgridPage, int goodsID) { var Linq = (from tbSelectGoods in myModels.B_GoodsList//商品 join tbPanlDateil in myModels.B_CheckRemerbenDetillList on tbSelectGoods.GoodsID equals tbPanlDateil.GoodsID join tbCheckRem in myModels.B_CheckRemerbenList on tbPanlDateil.CheckRermeberID equals tbCheckRem.CheckRermeberID where tbSelectGoods.GoodsID == goodsID select new LY.PeiHuoDan { GoodsIDs = tbSelectGoods.GoodsID, //商品ID MumberOfPackages = tbPanlDateil.MumberOfPackages, Subdivision = tbPanlDateil.Subdivision, Number = tbPanlDateil.SunYiShu, SpouseBRanchNsame = tbCheckRem.CommodityType, registerTime = tbCheckRem.PablData.ToString(), }).ToList(); int totalRow = Linq.Count(); List <LY.PeiHuoDan> notices = Linq.OrderByDescending(p => p.WareHouseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 绑定合同 /// </summary> /// <returns></returns> public ActionResult BangOrderFrom(Vo.BsgridPage bsgridPage, int OrderFormPact) { var linq = (from tbOrderFrom in MyModels.B_OrderFormPactList where tbOrderFrom.OrderFormPactID == OrderFormPact select new LY.WareHouseDeitaLL { OrderFormPactID = tbOrderFrom.OrderFormPactID, ContractNumber = tbOrderFrom.ContractNumber, ValidBegin = tbOrderFrom.ValidBegin.ToString(), ValidTip = tbOrderFrom.ValidTip.ToString() }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.OrderFormPactID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据所选的 合同ID(查询商品表) /// </summary> /// <returns></returns> public ActionResult SelectShangPin(Vo.BsgridPage bsgridPage, int orderformPactID1) { var linq = (from tbSelect in myModels.B_DefaulGoodsList //缺省表 join tbSelectDetail in myModels.B_DefaulGoodsDetaiLList on tbSelect.DefaulGoodsID equals tbSelectDetail.DefaulGoodsID //缺省明细表 join tbGoods in myModels.B_GoodsList on tbSelectDetail.GoodsID equals tbGoods.GoodsID //商品表 join tbHeTong in myModels.B_OrderFormPactList on tbSelect.OrderFormPactID equals tbHeTong.OrderFormPactID //合同表 where tbSelect.OrderFormPactID == orderformPactID1 select new LY.DefaulGoods { DefaulGoodsID = tbSelect.DefaulGoodsID, //缺省商品表ID DefaulGoodsDetaiLLID = tbSelectDetail.DefaulGoodsDetaiLLID, //缺省商品明细表ID GoodsIDs = tbGoods.GoodsID, //商品ID GoodsCodes = tbGoods.GoodsCode, //商品代码 GoodsTiaoMas = tbGoods.GoodsTiaoMa, //商品条码 GoodsNames = tbGoods.GoodsName, //商品名称 ArtNos = tbGoods.ArtNo, //商品货号 }).ToList(); int totalRow = linq.Count(); List <LY.DefaulGoods> notices = linq.OrderByDescending(p => p.DefaulGoodsID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.DefaulGoods> bsgrid = new Vo.Bsgrid <LY.DefaulGoods>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询商品代码 /// </summary> /// <returns></returns> public ActionResult BangFanChangGoodel(Vo.BsgridPage bsgridPage) { var linq = (from tbShangPin in myModels.B_GoodsList //商品 join tbGoodDetail in myModels.B_GoodsDetailList on tbShangPin.GoodsID equals tbGoodDetail.GoodsID //商品明细 join tbPackln in myModels.S_PackInfoIDList on tbGoodDetail.GoodsDetailID equals tbPackln.GoodsDetailID //包装信息表 select new LY.PeiHuoDan { GoodsIDs = tbShangPin.GoodsID, GoodsCode = tbShangPin.GoodsCode, GoodsName = tbShangPin.GoodsName, }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.GoodsCode). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
///查询对应部门(右) /// </summary> /// <returns></returns> public ActionResult SelecBuMnesright(Vo.BsgridPage bsgridPage) { var linq = (from tbChterm in myModels.B_CheckRemerbenList join tbDruyt in myModels.B_PanlList on tbChterm.DrugTypeID equals tbDruyt.DrugTypeID select new LY.WareHouseDeitaLL { PablData = tbChterm.PablData.ToString(), DrugType = tbDruyt.DrugType, DrugTypeID = tbDruyt.DrugTypeID }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsChopID).//noboer表达式 Skip(bsgridPage.GetStartIndex()). Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 联营合同查询 /// </summary> /// <returns></returns> public ActionResult LianYingHeTong(Vo.BsgridPage bsgridPage) { var linq = (from tbSelectOrPac in myModels.B_OrderFormPactList //合同表 join tbHeTongLeiXing in myModels.S_AgreementTypeList on tbSelectOrPac.AgreementTypeID equals tbHeTongLeiXing.AgreementTypeID //合同类型 join tbJieSuanFangShi in myModels.S_MethodOfSettlingAccountsList on tbSelectOrPac.MethodOfSettlingAccountsID equals tbJieSuanFangShi.MethodOfSettlingAccountsID //结算方式 join tbSutall in myModels.B_SupplierList on tbSelectOrPac.SupplierID equals tbSutall.SupplierID //供货商 where tbHeTongLeiXing.AgreementTypeID == 3 select new LY.SelectOrderPact { OrderFormPactID = tbSelectOrPac.OrderFormPactID, //合同ID ContractNumber = tbSelectOrPac.ContractNumber, //合同号 AgreementTypeName = tbHeTongLeiXing.AgreementTypeName, //合同类型 MethodOfSettlingAccounts = tbJieSuanFangShi.MethodOfSettlingAccounts, //结算方式 SupplierCHName = tbSutall.SupplierCHName, //供货商名称 ContractValidRised = tbSelectOrPac.ValidBegin.ToString(), //合同有效期(起) ContractValidBegins = tbSelectOrPac.ValidTip.ToString(), //合同有效期(始) ConclusionTimes = tbSelectOrPac.ConclusionTime.ToString(), //签订时间 ConclusionSite = tbSelectOrPac.ConclusionSite, //签订地点 }).ToList(); int totalRow = linq.Count(); List <LY.SelectOrderPact> notices = linq.OrderByDescending(p => p.OrderFormPactID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.SelectOrderPact> bsgrid = new Vo.Bsgrid <LY.SelectOrderPact>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询合同单 /// </summary> /// <returns></returns> public ActionResult SeleHeTong(Vo.BsgridPage bsgridPage) { var linq = (from tbPeiHuo in MyModels.B_ConverList join tbJinCang in MyModels.B_WareHouseList on tbPeiHuo.WareHouseID equals tbJinCang.WareHouseID join tbHeTong in MyModels.B_OrderFormPactList on tbJinCang.OrderFormPactID equals tbHeTong.OrderFormPactID join tbGongHuo in MyModels.B_SupplierList on tbHeTong.SupplierID equals tbGongHuo.SupplierID join tbHeSuan in MyModels.S_AdjustAccountsFashionList on tbHeTong.AdjustAccountsFashionID equals tbHeSuan.AdjustAccountsFashionID where tbPeiHuo.ExamineNot == true select new LY.PeiHuoDan { ConverID = tbPeiHuo.ConverID, ContractNumber = tbHeTong.ContractNumber, SupplierCHName = tbGongHuo.SupplierCHName, AdjustAccountsFashion = tbHeSuan.AdjustAccountsFashion }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.WareHouseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询商品代码(一) public ActionResult SelectSellctGoods(Vo.BsgridPage bsgridPage) { var linq = (from tbSellct in myModels.B_SellList //销售单 join tbSellDatelst in myModels.B_SellDeTaLsit on tbSellct.SellID equals tbSellDatelst.SellID //销售明细单 join tbConverDaTe in myModels.B_ConverDeTailList on tbSellDatelst.ConverDeTaiID equals tbConverDaTe.ConverDeTaiID //配货明细单 join tbGoods in myModels.B_GoodsList on tbConverDaTe.GoodsID equals tbGoods.GoodsID //商品 select new LY.PeiHuoDan { GoodsIDs = tbGoods.GoodsID, //商品id GoodsCode = tbGoods.GoodsCode, //代码 GoodsNames = tbGoods.GoodsName, //商品名称 }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.SellID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 绑定调整单商品( /// </summary> /// <returns></returns> public ActionResult DuiYingSdSellctGoodsfd(Vo.BsgridPage bsgridPage, int AllocateID) { var linq = (from tbConverlist in myModels.B_SellCheckBatchList join tbSeChdeDetail in myModels.B_SellCheckBatchDetaiList on tbConverlist.SellCheckBatchID equals tbSeChdeDetail.SellCheckBatchID //明细 join tbConverDaTe in myModels.B_ConverDeTailList on tbSeChdeDetail.ConverDeTaiID equals tbConverDaTe.ConverDeTaiID //配货明细单 join tbGoods in myModels.B_GoodsList on tbConverDaTe.GoodsID equals tbGoods.GoodsID //商品 join tbJiLiangDanWei in myModels.S_EstimateUnitList on tbGoods.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 join tbGoodDetail in myModels.B_GoodsDetailList on tbGoods.GoodsID equals tbGoodDetail.GoodsID //商品明细 where tbSeChdeDetail.SellCheckBatchID == AllocateID select new LY.PeiHuoDan { GoodsNames = tbGoods.GoodsName, MumberOfPackages = tbConverDaTe.MumberOfPackages, // Subdivision = tbSeChdeDetail.MumberOfPackages, RetailMonovalents = tbGoodDetail.RetailMonovalent, //零售单价 Number = tbConverDaTe.Number, }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ConverID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询销售单 /// </summary> /// <param name="bsgridPage"></param> /// <param name="stockPlaceID"></param> /// <returns></returns> public ActionResult SelectSellct(Vo.BsgridPage bsgridPage) { var linq = (from tbSellct in MyModels.B_SellList//销售单 join tbSpuBuMen in MyModels.S_SpouseBRanchList on tbSellct.SpouseBRanchID equals tbSpuBuMen.SpouseBRanchID where tbSellct.ExamineNot == true select new LY.PeiHuoDan { SellID = tbSellct.SellID, //销售id Remember = tbSellct.Remember, //销售单编号 SpouseBRanchName = tbSpuBuMen.SpouseBRanchName, //新部门 PanlDate = tbSellct.PanlDate.ToString(), //启动计划日期 RegisterName = tbSellct.RegisterName, //制单人 registerTime = tbSellct.RegisterTime.ToString(), //制单时间 }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ConverID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询商标 /// </summary> /// <param name="bsgridPage"></param> /// <param name="stockPlaceID"></param> /// <returns></returns> public ActionResult SelectBangDingPeiHuo(Vo.BsgridPage bsgridPage, int stockPlaceID, int converID) { var linq = (from tbConverlist in MyModels.B_ConverList join tbConverDaTe in MyModels.B_ConverDeTailList on tbConverlist.ConverID equals tbConverDaTe.ConverID //配货明细 join tbGoods in MyModels.B_GoodsList on tbConverDaTe.GoodsID equals tbGoods.GoodsID //商品 join tbShangBiao in MyModels.B_GoodsChopList on tbGoods.GoodsChopID equals tbShangBiao.GoodsChopID //商标 where tbConverlist.StockPlaceID == stockPlaceID && tbConverlist.ConverID == converID select new LY.PeiHuoDan { ConverID = tbConverlist.ConverID, //id GoodsIDs = tbGoods.GoodsID, GoodsCode = tbGoods.GoodsCode, GoodsChopName = tbShangBiao.GoodsChopName, }).ToList(); int totalRow = linq.Count(); List <LY.PeiHuoDan> notices = linq.OrderByDescending(p => p.ConverID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询销售(起)条件 /// </summary> /// <param name="bsgridPage"></param> /// <param name="stockPlaceID"></param> /// <returns></returns> public ActionResult SelectBSellHuo(Vo.BsgridPage bsgridPage, int spouseBRanchID) { var linq = (from tbYaoHuo in MyModels.B_WanManifestList //要货单 join tbBuMne in MyModels.S_SpouseBRanchList on tbYaoHuo.PurchaseSectionID equals tbBuMne.SpouseBRanchID join tbSellDatelst in MyModels.B_WanManifestDetailList on tbYaoHuo.WanManifestID equals tbSellDatelst.WanManifestID //销售明细单 join tbGoods in MyModels.B_GoodsList on tbSellDatelst.GoodsID equals tbGoods.GoodsID //商品 join tbShangBiao in MyModels.B_GoodsChopList on tbGoods.GoodsChopID equals tbShangBiao.GoodsChopID //商标 join tbJiLiangDanWei in MyModels.S_EstimateUnitList on tbGoods.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 join tbGoodDetail in MyModels.B_GoodsDetailList on tbGoods.GoodsID equals tbGoodDetail.GoodsID //商品明细 where tbYaoHuo.PurchaseSectionID == spouseBRanchID select new LY.WareHouseDeitaLL { SupplierID = tbYaoHuo.WanManifestID, SpouseBRanchName = tbBuMne.SpouseBRanchName, RegisterName = tbYaoHuo.RegisterName, //FactPrice = tbGoodDetail.FactPrice * tbSellDatelst.MumberOfPackages,//商品单价(销售价) RegisterTime = tbYaoHuo.RegisterTime.ToString(), }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.IncreaseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize).ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 绑定商品类型 /// </summary> /// <returns></returns> public ActionResult BangDGoodsClass(Vo.BsgridPage bsgridPage, int goodsClassifyID) { var linq = (from tbGoodClass in MyModels.B_GoodsClassifyList where tbGoodClass.GoodsClassifyID == goodsClassifyID select new LY.WareHouseDeitaLL { GoodsClassifyID = tbGoodClass.GoodsClassifyID, Code = tbGoodClass.Code, GoodsClassifyName = tbGoodClass.GoodsClassifyName }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.GoodsClassifyID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询商品 信息 /// </summary> /// <returns></returns> public ActionResult SelectStudentA(BsgridPage bsgridPage) //查询信息 { var linq = from tbSpaouc in myModels.S_SpouseBRanchList join tbDetrem in myModels.B_DepatmenList on tbSpaouc.SpouseBRanchID equals tbDetrem.SpouseBRanchID //orderby tbDetrem.departmentID select new LY.WareHouseDeitaLL { departmentID = tbDetrem.departmentID, DfrugTypeID = tbDetrem.DrugTypeID, SpouseBRancfdhID = tbSpaouc.SpouseBRanchID, departmentCodes = tbDetrem.departmentCodes, departmentName = tbDetrem.departmentName, HaoSunLv = tbDetrem.HaoSunLv, }; int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.DfrugTypeID). Skip(bsgridPage.GetStartIndex()).//F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询进仓单(一) /// </summary> /// <param name="bsgridPage"></param> /// <returns></returns> public ActionResult ChaXunWareFonZongHe(Vo.BsgridPage bsgridPage, int quFenLeiXingID, int stockPlaceID) { //进仓、员工、类型、合同、供货商、结算方式 var Linq = from tbWaerHouse in myModels.B_WareHouseList join tbStoucRcu in myModels.S_StockPlaceList on tbWaerHouse.StockPlaceID equals tbStoucRcu.StockPlaceID join tbStall in myModels.B_StaffList on tbWaerHouse.StaffID equals tbStall.StaffID //员工 join tbQuFen in myModels.S_QuFenLeiXingList on tbWaerHouse.QuFenLeiXingID equals tbQuFen.QuFenLeiXingID //区分类型 join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID //合同 join tbSupplier in myModels.B_SupplierList on tbHeTong.SupplierID equals tbSupplier.SupplierID //供货商 join tbJieSuan in myModels.S_MethodOfSettlingAccountsList on tbHeTong.MethodOfSettlingAccountsID equals tbJieSuan.MethodOfSettlingAccountsID //结算 where tbWaerHouse.ExamineNot == true && tbWaerHouse.Status == true && tbWaerHouse.CrushRedNot == false select new LY.WareHouseDeitaLL { WareHouseID = tbWaerHouse.WareHouseID, //进仓ID StockPlaceID = tbStoucRcu.StockPlaceID, Remember = tbWaerHouse.Remember, //进仓编号 OrderFormPactID = tbHeTong.OrderFormPactID, //合同ID ContractNumber = tbHeTong.ContractNumber, //合同编号 MethodOfSettlingAccounts = tbJieSuan.MethodOfSettlingAccounts, //结算方式 SupplierCHName = tbSupplier.SupplierCHName, //供货商名称 StaffID = tbStall.StaffID, //员工ID StaffCode = tbStall.StaffCode, //员工编号 StaffName = tbStall.StaffName, //姓名 RegisterTime = tbWaerHouse.RegisterTime.ToString(), //登记时间 ExamineNot = tbWaerHouse.ExamineNot, //审核状态 Status = tbWaerHouse.Status, //生效状态 CrushRedNot = tbWaerHouse.CrushRedNot, //冲红状态 QuFenLeiXingID = tbQuFen.QuFenLeiXingID, //区分ID QuFenLeiXingMC = tbQuFen.QuFenLeiXingMC //区分 }; if (quFenLeiXingID > 0) { Linq = Linq.Where(p => p.QuFenLeiXingID == quFenLeiXingID); } if (stockPlaceID > 0) { Linq = Linq.Where(p => p.StockPlaceID == stockPlaceID); } int totalRow = Linq.Count(); List <LY.WareHouseDeitaLL> notices = Linq.OrderByDescending(p => p.WareHouseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 选择绑定 订单(商品)到页面(2) /// </summary> /// <returns></returns> public ActionResult BfdangDingShangPin(Vo.BsgridPage bsgridPage, string goodsCode) { try { var linq = (from tbOrderFormDeill in myModels.B_OrderFormDetailList//订单明细 join tbOrderForm in myModels.B_OrderFormList on tbOrderFormDeill.OrderFormID equals tbOrderForm.OrderFormID join tbOrderFormPactID in myModels.B_OrderFormPactList on tbOrderForm.OrderFormPactID equals tbOrderFormPactID.OrderFormPactID join tbGongHuo in myModels.B_SupplierList on tbOrderFormPactID.SupplierID equals tbGongHuo.SupplierID join tbShangPin in myModels.B_GoodsList on tbOrderFormDeill.GoodsID equals tbShangPin.GoodsID //商品 join tbShangPinDeill in myModels.B_GoodsDetailList on tbShangPin.GoodsID equals tbShangPinDeill.GoodsID //商品明细 join tbBaoZhuangXin in myModels.S_PackInfoIDList on tbShangPinDeill.GoodsDetailID equals tbBaoZhuangXin.GoodsDetailID //包装信息 join tbJiLiangDanWei in myModels.S_EstimateUnitList on tbShangPin.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 where tbShangPin.GoodsCode == goodsCode select new LY.SelectListDingDan { ContractNumber = tbOrderFormPactID.ContractNumber, ValidTip = tbOrderFormPactID.ValidTip.ToString(), ValidBegin = tbOrderFormPactID.ValidBegin.ToString(), SupplierNumber = tbGongHuo.SupplierNumber, SupplierCHName = tbGongHuo.SupplierCHName, GoodsIDs = tbShangPinDeill.GoodsID, GoodsCodes = tbShangPin.GoodsCode, //商品代码 GoodsTiaoMas = tbShangPin.GoodsTiaoMa, //商品条码 GoodsNames = tbShangPin.GoodsName, //商品名称 ArtNos = tbShangPin.ArtNo, //商品货号 SpecificationsModels = tbShangPin.SpecificationsModel, //规格 EstimateUnitNames = tbJiLiangDanWei.EstimateUnitName, //计量单位 TaxBids = tbShangPinDeill.TaxBid, //含税进价 RetailMonovalents = tbShangPinDeill.RetailMonovalent, //零售单价 }).ToList(); int totalRow = linq.Count(); List <LY.SelectListDingDan> notices = linq.OrderByDescending(p => p.OrderFormID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.SelectListDingDan> bsgrid = new Vo.Bsgrid <LY.SelectListDingDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); return(Json("", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 绑定商品到(主界面) /// </summary> /// <returns></returns> public ActionResult BangDingPiGoodel(Vo.BsgridPage bsgridPage, Array jiLuChaekID) { List <PeiHuoDan> list = new List <PeiHuoDan>(); // int goodsIDs string Z = ((string[])jiLuChaekID)[0]; string[] intsZ = Z.Split(','); for (int P = 0; P < intsZ.Length;) { var goodsIDs = Convert.ToInt32(intsZ[P]); var linq = (from tbSellct in MyModels.B_SellList //销售单 join tbSellDatelst in MyModels.B_SellDeTaLsit on tbSellct.SellID equals tbSellDatelst.SellID //销售明细单 join tbBumen in MyModels.S_SpouseBRanchList on tbSellct.SpouseBRanchID equals tbBumen.SpouseBRanchID join tbConverDaTe in MyModels.B_ConverDeTailList on tbSellDatelst.ConverDeTaiID equals tbConverDaTe.ConverDeTaiID //配货明细单 join tbGoods in MyModels.B_GoodsList on tbConverDaTe.GoodsID equals tbGoods.GoodsID //商品 join tbJiLiangDanWei in MyModels.S_EstimateUnitList on tbGoods.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 join tbGoodDetail in MyModels.B_GoodsDetailList on tbGoods.GoodsID equals tbGoodDetail.GoodsID //商品明细 join tbPackln in MyModels.S_PackInfoIDList on tbGoodDetail.GoodsDetailID equals tbPackln.GoodsDetailID //包装信息表 where tbSellDatelst.SellDeTaliID == goodsIDs select new LY.PeiHuoDan { SellDeTaliID = tbSellDatelst.SellDeTaliID, //销售明细id GoodsIDs = tbGoods.GoodsID, //商品id GoodsCode = tbGoods.GoodsCode, //代码 GoodsNames = tbGoods.GoodsName, //商品名称 PackContents = tbPackln.PackContent, //包装含量 GoodsTiaoMas = tbGoods.GoodsTiaoMa, //商品条码 MumberOfPackages = tbConverDaTe.MumberOfPackages, // RetailMonovalents = tbGoodDetail.RetailMonovalent, //零售单价 SpecificationsModels = tbGoods.SpecificationsModel, //规格 EstimateUnitNames = tbJiLiangDanWei.EstimateUnitName, //计量单位 ArtNos = tbGoods.ArtNo, //商品货号 SpouseBRanchName = tbBumen.SpouseBRanchName, //商品货号 TaxBids = tbGoodDetail.TaxBid, //含税进价 }).ToList(); list.AddRange(linq); P++; } int totalRow = list.Count(); List <LY.PeiHuoDan> notices = list.OrderByDescending(p => p.GoodsIDs). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.PeiHuoDan> bsgrid = new Vo.Bsgrid <LY.PeiHuoDan>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 点击选择“进仓单”绑定到界面( 附 带 商品table)(二) /// </summary> /// <returns></returns> public ActionResult BangSahfnJinCangShangPin(Vo.BsgridPage bsgridPage, int WareHouseID1) { try { var linq = (from tbSelectWanHtsList in myModels.B_WareHouseList //进仓单ID join tbWanHofDeaill in myModels.B_WareHouseDetiailList on tbSelectWanHtsList.WareHouseID equals tbWanHofDeaill.WareHouseID //进仓明细 join tbShangPin in myModels.B_GoodsList on tbWanHofDeaill.OrderFormDetailID equals tbShangPin.GoodsID //商品 join tbShangPinDeill in myModels.B_GoodsDetailList on tbShangPin.GoodsID equals tbShangPinDeill.GoodsID //商品明细 join tbPackln in myModels.S_PackInfoIDList on tbShangPinDeill.GoodsDetailID equals tbPackln.GoodsDetailID //包装信息表 join tbJiLiangDanWei in myModels.S_EstimateUnitList on tbShangPin.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 where tbWanHofDeaill.WareHouseID == WareHouseID1 //根据进仓明细中的“进仓ID” select new LY.WareHouseDeitaLL { WareHouseDetiailID = tbWanHofDeaill.WareHouseDetiailID, //进仓明细ID WareHouseID = tbSelectWanHtsList.WareHouseID, //进仓ID GoodsIDs = tbShangPin.GoodsID, //商品ID GoodsCodes = tbShangPin.GoodsCode, //商品代码 GoodsTiaoMas = tbShangPin.GoodsTiaoMa, //商品条码 GoodsNames = tbShangPin.GoodsName, //商品名称 ArtNos = tbShangPin.ArtNo, //商品货号 SpecificationsModels = tbShangPin.SpecificationsModel, //规格 EstimateUnitNames = tbJiLiangDanWei.EstimateUnitName, //计量单位 TaxBids = tbShangPinDeill.TaxBid, //含税进价 PackInfos = tbPackln.PackContent, //包装含量 RetailMonovalents = tbShangPinDeill.RetailMonovalent, //零售单价 MumberOfPackages = tbWanHofDeaill.MumberOfPackages, //进仓件数 Subdivision = tbWanHofDeaill.Subdivision, //入库细数 }).ToList(); int totalRow = linq.Count(); List <LY.WareHouseDeitaLL> notices = linq.OrderByDescending(p => p.WareHouseID). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; bsgrid.curPage = bsgridPage.curPage; bsgrid.data = notices; return(Json(bsgrid, JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); return(Json("", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 绑定商品到(主界面) /// </summary> /// <returns></returns> public ActionResult BangDingPiGoodel(Vo.BsgridPage bsgridPage, Array jiLuChaekID) { List <WareHouseDeitaLL> list = new List <WareHouseDeitaLL>(); // int goodsIDs string Z = ((string[])jiLuChaekID)[0]; string[] intsZ = Z.Split(','); for (int P = 0; P < intsZ.Length;) { var goodsIDs = Convert.ToInt32(intsZ[P]); var linq = (from tbGoods in MyModels.B_GoodsList //商品 join tbGoodChoClass in MyModels.B_GoodsClassifyList on tbGoods.GoodsClassifyID equals tbGoodChoClass.GoodsClassifyID //商品分类 join tbShangBiao in MyModels.B_GoodsChopList on tbGoods.GoodsChopID equals tbShangBiao.GoodsChopID //商标 join tbJiLiangDanWei in MyModels.S_EstimateUnitList on tbGoods.EstimateUnitID equals tbJiLiangDanWei.EstimateUnitID //计量单位 join tbGoodDetail in MyModels.B_GoodsDetailList on tbGoods.GoodsID equals tbGoodDetail.GoodsID //商品明细 join tbBaoZhuangXin in MyModels.S_PackInfoIDList on tbGoodDetail.GoodsDetailID equals tbBaoZhuangXin.GoodsDetailID //包装信息 where tbGoods.GoodsID == goodsIDs select new LY.WareHouseDeitaLL { //CheckRermeberID = tbChredgRe.CheckRermeberID, //CheckRemerbenDetillD = tbChredgReDateil.CheckRemerbenDetillD, GoodsIDs = tbGoods.GoodsID, GoodsCodes = tbGoods.GoodsCode, //代码 GoodsNames = tbGoods.GoodsName, //商品名称 GoodsTiaoMas = tbGoods.GoodsTiaoMa, //商品条码 ArtNos = tbGoods.ArtNo, //商品货号 PackInfos = tbBaoZhuangXin.PackContent, //包装含量 EstimateUnitNames = tbJiLiangDanWei.EstimateUnitName, //计量单位 }).ToList(); list.AddRange(linq); P++; } int totalRow = list.Count(); List <LY.WareHouseDeitaLL> notices = list.OrderByDescending(p => p.GoodsIDs). //noboer表达式 Skip(bsgridPage.GetStartIndex()). //F12(看) Take(bsgridPage.pageSize). ToList(); Vo.Bsgrid <LY.WareHouseDeitaLL> bsgrid = new Vo.Bsgrid <LY.WareHouseDeitaLL>(); bsgrid.success = true; bsgrid.totalRows = totalRow; //总的行数 bsgrid.curPage = bsgridPage.curPage; //请求当前页 bsgrid.data = notices; //查出的数据 return(Json(bsgrid, JsonRequestBehavior.AllowGet)); }