/// <summary>
/// 浏览器打印调拨单
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverList()
{
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 == true
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(),
ExamineName = tbZhuanKu.ExamineName,
examineTime = tbZhuanKu.ExamineTime.ToString(),
ExamineNots = tbZhuanKu.ExamineNot.ToString(), //审核否
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.StockPlaceName = Linq[i].StockPlaceName;
myWareHouseDeitaLL.StockPlaceNametwo = Linq[i].StockPlaceNametwo;
myWareHouseDeitaLL.payName = Linq[i].payName;
myWareHouseDeitaLL.furlName = Linq[i].furlName;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印调拨单
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverList()
{
var Linq = (from tbSellct in MyModels.B_SellRetuerList//返仓单
join tbSpuBuMen in MyModels.S_StockPlaceList on tbSellct.StockPlaceID equals tbSpuBuMen.StockPlaceID
join tbSpudfdBuMen in MyModels.S_SpouseBRanchList on tbSellct.SpouseBRanchID equals tbSpudfdBuMen.SpouseBRanchID
where tbSellct.ExamineNot == true
select new LY.PeiHuoDan
{
SellRetuerID = tbSellct.SellRetuerID, //返仓id
SellID = tbSellct.SellID, //销售id
Remember = tbSellct.Remember, //返仓单编号
StockPlaceName = tbSpuBuMen.StockPlaceName, //收货部门
SpouseBRanchName = tbSpudfdBuMen.SpouseBRanchName, //收货部门
payName = tbSellct.payName, //实物付
furlName = tbSellct.furlName, //实物收
Remarks = tbSellct.Remarks, //备注
RegisterName = tbSellct.RegisterName, //制单
registerTime = tbSellct.RegisterTime.ToString(), //时间
ExamineName = tbSellct.ExamineName, //审核
examineTime = tbSellct.ExamineTime.ToString(), //时间
ExamineNots = tbSellct.ExamineNot.ToString(), //审核否
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.StockPlaceName = Linq[i].StockPlaceName;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.payName = Linq[i].payName;
myWareHouseDeitaLL.furlName = Linq[i].furlName;
myWareHouseDeitaLL.Remarks = Linq[i].Remarks;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印调拨单
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverList()
{
var Linq = (from tbConverlist in MyModels.B_AllocateList
join tbFaHuoBuMen in MyModels.S_SpouseBRanchList on tbConverlist.SpouseBRanchID equals tbFaHuoBuMen.SpouseBRanchID
join tbShouHuoBuMen in MyModels.S_SpouseBRanchList on tbConverlist.SpouseBRanchIDtwo equals tbShouHuoBuMen.SpouseBRanchID
where tbConverlist.ExamineNot == true
select new LY.PeiHuoDan
{
AllocateID = tbConverlist.AllocateID, //id
Remember = tbConverlist.Remember, //编号
payName = tbConverlist.payNamel, //发货人
furlName = tbConverlist.furlNamel, //收货人
SpouseBRanchName = tbFaHuoBuMen.SpouseBRanchName, //发货部门
SpouseBRanchNsame = tbShouHuoBuMen.SpouseBRanchName, //发货部门
Remarks = tbConverlist.Remarks, //备注
RegisterName = tbConverlist.RegisterName, //制单人
registerTime = tbConverlist.RegisterTime.ToString(), //制单时间
ExamineName = tbConverlist.ExamineName, //审核人
examineTime = tbConverlist.ExecuteTime.ToString(), //审核时间
ExamineNots = tbConverlist.ExamineNot.ToString() //审核否
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.payName = Linq[i].payName;
myWareHouseDeitaLL.furlName = Linq[i].furlName;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.SpouseBRanchNsame = Linq[i].SpouseBRanchNsame;
myWareHouseDeitaLL.Remarks = Linq[i].Remarks;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverList()
{
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(), //制单时间
ExamineName = tbSellct.ExamineName, //审核人
examineTime = tbSellct.ExecuteTime.ToString(), //审核时间
QiDongName = tbSellct.QiDongName, //启动人
QiDongTime = tbSellct.QiDongTime.ToString(), //启动时间
ExamineNots = tbSellct.ExamineNot.ToString(), //启动时间
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.PanlDate = Linq[i].PanlDate;
myWareHouseDeitaLL.Remarks = Linq[i].Remarks;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
myWareHouseDeitaLL.QiDongName = Linq[i].QiDongName;
myWareHouseDeitaLL.QiDongTime = Linq[i].QiDongTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印要货单
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverListYaoHuo()
{
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(), //制单时间
ExamineNots = tbWanMetre.ExamineNot.ToString(), //审核否
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印调拨单
/// </summary>
/// <returns></returns>
public ActionResult DaYinConverList()
{
var Linq = (from tbFanChan in MyModels.B_RetureFactoryList
join tbConver in MyModels.B_ConverList on tbFanChan.ConverID equals tbConver.ConverID
join tbWareHou in MyModels.B_WareHouseList on tbConver.WareHouseID equals tbWareHou.WareHouseID
join tbOrderFormPactI in MyModels.B_OrderFormPactList on tbWareHou.OrderFormPactID equals tbOrderFormPactI.OrderFormPactID
join tbSupptoc in MyModels.B_SupplierList on tbOrderFormPactI.SupplierID equals tbSupptoc.SupplierID
join tbHeSuan in MyModels.S_AdjustAccountsFashionList on tbOrderFormPactI.AdjustAccountsFashionID equals tbHeSuan.AdjustAccountsFashionID
join tbTuiHuo in MyModels.S_SpouseBRanchList on tbFanChan.SpouseBRanchID equals tbTuiHuo.SpouseBRanchID
join tbKuCun in MyModels.S_StockPlaceList on tbFanChan.StockPlaceID equals tbKuCun.StockPlaceID
join tbTuiYuanYin in MyModels.S_ReturnofList on tbFanChan.ReturnofID equals tbTuiYuanYin.ReturnofID
select new LY.PeiHuoDan
{
RetureFactoryID = tbFanChan.RetureFactoryID,
ConverID = tbConver.ConverID,
Remember = tbFanChan.Remember,
SpouseBRanchName = tbTuiHuo.SpouseBRanchName,
StockPlaceName = tbKuCun.StockPlaceName,
Returnof = tbTuiYuanYin.Returnof,
SupplierCHName = tbSupptoc.SupplierCHName,
ContractNumber = tbOrderFormPactI.ContractNumber,
AdjustAccountsFashion = tbHeSuan.AdjustAccountsFashion,
RegisterName = tbFanChan.RegisterName,
registerTime = tbFanChan.RegisterTime.ToString(),
ExamineName = tbFanChan.ExamineName,
examineTime = tbFanChan.ExamineTime.ToString(),
Settlement = tbFanChan.Settlement,
ExamineNots = tbFanChan.ExamineNot.ToString(),
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNots) == true)
{
myWareHouseDeitaLL.ExamineNots = "已审核";
}
else
{
myWareHouseDeitaLL.ExamineNots = "未审核";
}
myWareHouseDeitaLL.Remember = Linq[i].Remember;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.StockPlaceName = Linq[i].StockPlaceName;
myWareHouseDeitaLL.Returnof = Linq[i].Returnof;
myWareHouseDeitaLL.SupplierCHName = Linq[i].SupplierCHName;
myWareHouseDeitaLL.ContractNumber = Linq[i].ContractNumber;
myWareHouseDeitaLL.AdjustAccountsFashion = Linq[i].AdjustAccountsFashion;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
myWareHouseDeitaLL.Settlement = Linq[i].Settlement;
myWareHouseDeitaLL.ExamineNot = Linq[i].ExamineNot;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
/// <summary>
/// 浏览器打印
/// </summary>
/// <returns></returns>
public ActionResult WidowesDaYin()
{
var Linq = (from tbGoodsListedList in myModels.B_GoodsListedList
join tbFaHuoBuMen in myModels.S_SpouseBRanchList on tbGoodsListedList.SpouseBRanchID equals tbFaHuoBuMen.SpouseBRanchID
join tbHuoDongZhuan in myModels.S_HuoDongZhuanQu on tbGoodsListedList.GoodsDingYiQuID equals tbHuoDongZhuan.GoodsDingYiQuID
join tbConver in myModels.B_ConverList on tbGoodsListedList.ConverID equals tbConver.ConverID
join tbWanHour in myModels.B_WareHouseList on tbConver.WareHouseID equals tbWanHour.WareHouseID
join tbOrerHovg in myModels.B_OrderFormPactList on tbWanHour.OrderFormPactID equals tbOrerHovg.OrderFormPactID
join tbGongHuo in myModels.B_SupplierList on tbOrerHovg.SupplierID equals tbGongHuo.SupplierID
join tbHuoDong in myModels.S_HuoDongZhuanQu on tbGoodsListedList.GoodsDingYiQuID equals tbHuoDong.GoodsDingYiQuID
where tbGoodsListedList.ExamineNot == true
//orderby tbGoodsListedList.ListedNumber descending
select new LY.PeiHuoDan
{
P_Remember = tbGoodsListedList.ListedNumber, //编号
SpouseBRanchID = tbFaHuoBuMen.SpouseBRanchID,
SpouseBRanchName = tbFaHuoBuMen.SpouseBRanchName,
StockPlaceName = tbGoodsListedList.ConsigneeShop,
Remarks = tbGongHuo.SupplierCHName,
payName = tbGoodsListedList.payName,
furlName = tbGoodsListedList.furlName,
RegisterName = tbGoodsListedList.RegisterName,
registerTime = tbGoodsListedList.RegisterTime.ToString(),
ExamineName = tbGoodsListedList.ExamineName,
examineTime = tbGoodsListedList.ExamineTime.ToString(),
QiDongName = tbHuoDong.GoodsDingYiQuMC,
GoodsDingYiQuID = tbHuoDong.GoodsDingYiQuID,
ExamineNotSt = tbGoodsListedList.StoopSellNot.ToString()
}).ToList();
List <PeiHuoDan> listWareHouseDeitaLL = new List <PeiHuoDan>();
for (int i = 0; i < Linq.Count; i++)
{
PeiHuoDan myWareHouseDeitaLL = new PeiHuoDan();
if (Convert.ToBoolean(Linq[i].ExamineNotSt) == true)
{
myWareHouseDeitaLL.ExamineNotSt = "已停售";
}
else
{
myWareHouseDeitaLL.ExamineNotSt = "销售中";
}
myWareHouseDeitaLL.P_Remember = Linq[i].P_Remember;
myWareHouseDeitaLL.SpouseBRanchName = Linq[i].SpouseBRanchName;
myWareHouseDeitaLL.StockPlaceName = Linq[i].StockPlaceName;
myWareHouseDeitaLL.Remarks = Linq[i].Remarks;
myWareHouseDeitaLL.payName = Linq[i].payName;
myWareHouseDeitaLL.furlName = Linq[i].furlName;
myWareHouseDeitaLL.RegisterName = Linq[i].RegisterName;
myWareHouseDeitaLL.registerTime = Linq[i].registerTime;
myWareHouseDeitaLL.ExamineName = Linq[i].ExamineName;
myWareHouseDeitaLL.examineTime = Linq[i].examineTime;
myWareHouseDeitaLL.QiDongName = Linq[i].QiDongName;
listWareHouseDeitaLL.Add(myWareHouseDeitaLL);
}
return(PartialView(listWareHouseDeitaLL));
}
