private string newtbMonthlyBalance(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbMonthlyBalance tbMonthlyBalance = new DXInfo.Models.tbMonthlyBalance();
tbMonthlyBalance.cnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]);
tbMonthlyBalance.cnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]);
tbMonthlyBalance.cnbIsBalance = false;
tbMonthlyBalance.cndCreateDate = DateTime.Now;
tbMonthlyBalance.cnvcCreater = context.User.Identity.Name;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"];
tbMonthlyBalance.cnvcCreaterName = ls1.strOperName;
Uow.tbMonthlyBalance.Add(tbMonthlyBalance);
DXInfo.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new DXInfo.Models.tbMonthlyBalanceLog();
ServiceHelper.SetEntity <DXInfo.Models.tbMonthlyBalance, DXInfo.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog);
Uow.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog);
Uow.Commit();
//}
}
catch (DbUpdateException dex)
{
ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message)));
}
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, "")));
}
private string balance(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
using (TransactionScope transaction = new TransactionScope())
{
//更新月结表
int icnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]);
int icnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]);
int icount = (from d in Uow.tbMonthlyBalance.GetAll()
where d.cnnYear <= icnnYear && d.cnnMonth < icnnMonth && !d.cnbIsBalance
select d).Count();
if (icount > 0)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "请先月结以前月份！")));
}
DXInfo.Models.tbMonthlyBalance tbMonthlyBalance = Uow.tbMonthlyBalance.GetById(g => g.cnnYear == icnnYear && g.cnnMonth == icnnMonth);
if (tbMonthlyBalance.cnbIsBalance)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "已月结！")));
}
tbMonthlyBalance.cnbIsBalance = true;
string strOperId = context.User.Identity.Name;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"];
string strOperName = ls1.strOperName;
tbMonthlyBalance.cndBalanceDate = DateTime.Now;
tbMonthlyBalance.cnvcBalancer = strOperId;
tbMonthlyBalance.cnvcBalancerName = strOperName;
DXInfo.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new DXInfo.Models.tbMonthlyBalanceLog();
ServiceHelper.SetEntity <DXInfo.Models.tbMonthlyBalance, DXInfo.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog);
Uow.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog);
//更新盘点和领料单的成本
Compute(tbMonthlyBalance, strOperId, strOperName);
Uow.Commit();
transaction.Complete();
}
//}
}
catch (DbUpdateException dex)
{
ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message)));
}
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, "")));
}
private string cancelBalance(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
using (TransactionScope transaction = new TransactionScope())
{
int icnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]);
int icnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]);
int icount = (from d in Uow.tbMonthlyBalance.GetAll()
where d.cnnYear >= icnnYear && d.cnnMonth > icnnMonth && d.cnbIsBalance
select d).Count();
if (icount > 0)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "请先取消以前月份月结！")));
}
DXInfo.Models.tbMonthlyBalance tbMonthlyBalance = Uow.tbMonthlyBalance.GetById(g => g.cnnYear == icnnYear && g.cnnMonth == icnnMonth);
if (!tbMonthlyBalance.cnbIsBalance)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "未月结！")));
}
tbMonthlyBalance.cnbIsBalance = false;
tbMonthlyBalance.cndModifyDate = DateTime.Now;
tbMonthlyBalance.cnvcModifier = context.User.Identity.Name;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"];
tbMonthlyBalance.cnvcModifierName = ls1.strOperName;
tbMonthlyBalance.cndBalanceDate = null;
tbMonthlyBalance.cnvcBalancer = string.Empty;
tbMonthlyBalance.cnvcBalancerName = string.Empty;
Uow.Commit();
DXInfo.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new DXInfo.Models.tbMonthlyBalanceLog();
ServiceHelper.SetEntity <DXInfo.Models.tbMonthlyBalance, DXInfo.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog);
Uow.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog);
int icnnCheckStatus = (int)StockStatus.Check;
List <long> lcnnDetailId = (from main in Uow.tbStockMain.GetAll()
join d in Uow.tbStockDetail.GetAll() on main.cnnMainId equals d.cnnMainId into md
from detail in md.DefaultIfEmpty()
where main.cnnYear == tbMonthlyBalance.cnnYear && main.cnnMonth == tbMonthlyBalance.cnnMonth &&
main.cnnStatus == icnnCheckStatus && main.cnnOperType != 0 && main.cnnOperType != 1
orderby main.cnnMainId
select detail.cnnDetailId).Distinct().ToList();
foreach (long cnnDetailId in lcnnDetailId)
{
DXInfo.Models.tbStockDetail tbStockDetail = Uow.tbStockDetail.GetById(g => g.cnnDetailId == cnnDetailId);
tbStockDetail.cnnPrice = 0;
tbStockDetail.cnnAmount = 0;
DXInfo.Models.tbStockDetailLog tbStockDetailLog = new DXInfo.Models.tbStockDetailLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockDetail, DXInfo.Models.tbStockDetailLog>(tbStockDetail, tbStockDetailLog);
Uow.tbStockDetailLog.Add(tbStockDetailLog);
}
int inextcnnYear = icnnYear;
int inextcnnMonth = icnnMonth + 1;
if (icnnMonth == 12)
{
inextcnnYear += 1;
inextcnnMonth = 1;
}
var q = (from main in Uow.tbStockMain.GetAll()
join d in Uow.tbStockDetail.GetAll() on main.cnnMainId equals d.cnnMainId into md
from detail in md.DefaultIfEmpty()
where main.cnnYear == inextcnnYear && main.cnnMonth == inextcnnMonth &&
main.cnnStatus == icnnCheckStatus && main.cnnSource == 1
orderby main.cnnMainId
select new { detail.cnnMainId, detail.cnnDetailId }).Distinct().ToList();
var q1 = (from d in q select d.cnnMainId).Distinct().ToList();
var q2 = (from d in q select d.cnnDetailId).Distinct().ToList();
if (q1.Count > 0)
{
foreach (long cnnMainId in q1)
{
DXInfo.Models.tbStockMain tbStockMain = Uow.tbStockMain.GetById(g => g.cnnMainId == cnnMainId);
tbStockMain.cnnStatus = (int)StockStatus.Delete;
Uow.tbStockMain.Delete(tbStockMain);
DXInfo.Models.tbStockMainLog tbStockMainLog = new DXInfo.Models.tbStockMainLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockMain, DXInfo.Models.tbStockMainLog>(tbStockMain, tbStockMainLog);
Uow.tbStockMainLog.Add(tbStockMainLog);
}
}
if (q2.Count > 0)
{
foreach (long cnnDetailId in q2)
{
DXInfo.Models.tbStockDetail tbStockDetail = Uow.tbStockDetail.GetById(g => g.cnnDetailId == cnnDetailId);
Uow.tbStockDetail.Delete(tbStockDetail);
DXInfo.Models.tbStockDetailLog tbStockDetailLog = new DXInfo.Models.tbStockDetailLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockDetail, DXInfo.Models.tbStockDetailLog>(tbStockDetail, tbStockDetailLog);
Uow.tbStockDetailLog.Add(tbStockDetailLog);
}
}
Uow.Commit();
transaction.Complete();
}
//}
}
catch (DbUpdateException dex)
{
ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message)));
}
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, "")));
}
private void Compute(DXInfo.Models.tbMonthlyBalance tbMonthlyBalance, string strOperId, string strOperName)
{
int icnnCheckStatus = (int)StockStatus.Check;
List <tbStockMainAndDetail> ltbStockMainAndDetail = (from main in Uow.tbStockMain.GetAll()
join d in Uow.tbStockDetail.GetAll() on main.cnnMainId equals d.cnnMainId into md
from detail in md.DefaultIfEmpty()
where main.cnnYear == tbMonthlyBalance.cnnYear && main.cnnMonth == tbMonthlyBalance.cnnMonth &&
main.cnnStatus == icnnCheckStatus
orderby main.cnnMainId
select new tbStockMainAndDetail
{
cnnMainId = main.cnnMainId,
cnvcWhCode = main.cnvcWhCode,
cnvcDeptId = main.cnvcDeptId,
cnnOperType = main.cnnOperType,
cnnYear = main.cnnYear,
cnnMonth = main.cnnMonth,
cnnDetailId = detail.cnnDetailId,
cnvcInvCode = detail.cnvcInvCode,
cnvcComUnitCode = detail.cnvcComUnitCode,
cnnQuantity = detail.cnnQuantity,
cnvcMainComUnitCode = detail.cnvcMainComUnitCode,
cnnMainQuantity = detail.cnnMainQuantity,
cnnPrice = detail.cnnPrice,
cnnAmount = detail.cnnAmount,
isHave = false
}).ToList();
var ltbInventory = (from d in Uow.tbInventory.GetAll()
join d1 in Uow.tbComputationUnit.GetAll() on d.cnvcSTComUnitCode equals d1.cnvcComunitCode into dd1
from dd1s in dd1.DefaultIfEmpty()
join d2 in Uow.tbProductClass.GetAll() on d.cnvcInvCCode equals d2.cnvcProductClassCode into dd2
from dd2s in dd2.DefaultIfEmpty()
join d3 in Uow.tbComputationUnit.GetAll() on d.cnvcProduceUnitCode equals d3.cnvcComunitCode into dd3
from dd3s in dd3.DefaultIfEmpty()
select new { d.cnvcInvCode, dd2s.cnvcProductType, d.cnvcProduceUnitCode, d.cnvcSTComUnitCode,
cniChangRate = dd1s == null?0:dd1s.cniChangRate,
cniChangeRate2 = dd3s == null?0:dd3s.cniChangRate }).ToList();
//利用期初、采购的数据计算成本
var g1 = (from d in ltbStockMainAndDetail
where d.cnnOperType == 0 || d.cnnOperType == 1
group d by new { d.cnvcInvCode, d.cnvcWhCode, d.cnvcDeptId } into g
select new { cnvcInvCode = g.Key.cnvcInvCode, cnvcWhCode = g.Key.cnvcWhCode,
cnvcDeptId = g.Key.cnvcDeptId,
cnnAvgPrice = g.Sum(s => s.cnnAmount) / g.Sum(s => s.cnnMainQuantity) }).ToList();
//1、已有的取出成本
foreach (var g2 in g1)
{
ltbStockMainAndDetail.ForEach(delegate(tbStockMainAndDetail md)
{
if (md.cnvcInvCode == g2.cnvcInvCode && md.cnvcWhCode == g2.cnvcWhCode &&
md.cnvcDeptId == g2.cnvcDeptId &&
md.cnnOperType != 0 && md.cnnOperType != 1
)
{
md.cnnMainPrice = g2.cnnAvgPrice;
md.cnnPrice = md.cnnMainPrice * (md.cnnMainQuantity / md.cnnQuantity);
md.cnnAmount = md.cnnMainPrice * md.cnnMainQuantity;
md.isHave = true;
}
});
}
//2、根据配方算出用量
var lInv = (from d in ltbStockMainAndDetail where d.cnnOperType != 0 && d.cnnOperType != 1 && !d.isHave select d.cnvcInvCode).Distinct().ToList();
List <DXInfo.Models.tbBillOfMaterials> lbom = ServiceHelper.getBOM(Uow);
List <tbStockMainAndDetail> lm = new List <tbStockMainAndDetail>();
foreach (string strInvCode in lInv)
{
if (!string.IsNullOrEmpty(strInvCode))
{
//获取所有子件
List <DXInfo.Models.tbBillOfMaterials> lComponentInv = ServiceHelper.ProcBOM(lbom, strInvCode);
//获取子件生产单位数量
var lcis = from d in lComponentInv
group d by d.cnvcComponentInvCode into g
select new { cnvcInvCode = g.Key, cnnQuantity = g.Sum(s => s.cnnBaseQtyN) };
//获取主计量单位成本
decimal dPrice = (from d in lcis
join d1 in ltbInventory on d.cnvcInvCode equals d1.cnvcInvCode into dd1
from dd1s in dd1.DefaultIfEmpty()
join d2 in g1 on d.cnvcInvCode equals d2.cnvcInvCode into dd2
from dd2s in dd2.DefaultIfEmpty()
select d.cnnQuantity *(dd1s == null ? 0 : dd1s.cniChangeRate2) * (dd2s == null || !dd2s.cnnAvgPrice.HasValue ? 0 : dd2s.cnnAvgPrice.Value)).Sum();
lm.Add(new tbStockMainAndDetail()
{
cnvcInvCode = strInvCode, cnnMainPrice = dPrice
});
}
}
;
ltbStockMainAndDetail.ForEach(delegate(tbStockMainAndDetail md)
{
if (md.cnnOperType != 0 && md.cnnOperType != 1 && !md.isHave)
{
decimal?dcnnMainPrice = (from d in lm where d.cnvcInvCode == md.cnvcInvCode select d.cnnMainPrice).FirstOrDefault();
md.cnnMainPrice = dcnnMainPrice;
md.cnnAmount = dcnnMainPrice * md.cnnMainQuantity;
md.cnnPrice = md.cnnAmount / md.cnnQuantity;
}
});
//3、更新成本
ltbStockMainAndDetail.ForEach(delegate(tbStockMainAndDetail md)
{
if (md.cnnOperType != 0 && md.cnnOperType != 1 && md.cnnDetailId.HasValue)
{
DXInfo.Models.tbStockDetail tbStockDetail = Uow.tbStockDetail.GetById(g => g.cnnDetailId == md.cnnDetailId);
tbStockDetail.cnnPrice = md.cnnPrice.Value;
tbStockDetail.cnnAmount = md.cnnAmount.Value;
}
});
//计算下月的期初库存
var g3 = (from d in ltbStockMainAndDetail
join d1 in ltbInventory on d.cnvcInvCode equals d1.cnvcInvCode into dd1
from dd1s in dd1.DefaultIfEmpty()
group d by new { d.cnvcInvCode, d.cnvcWhCode, d.cnvcDeptId, d.cnvcMainComUnitCode, cnvcSTComUnitCode = dd1s == null ? "" : dd1s.cnvcSTComUnitCode, cniChangRate = dd1s == null?0:dd1s.cniChangRate } into g
select new
{
cnvcWhCode = g.Key.cnvcWhCode,
cnvcDeptId = g.Key.cnvcDeptId,
cnvcInvCode = g.Key.cnvcInvCode,
cnvcMainComUnitCode = g.Key.cnvcMainComUnitCode,
cnvcComUnitCode = g.Key.cnvcSTComUnitCode,
cniChangRate = g.Key.cniChangRate,
cnnAmount = g.Sum(s => s.cnnAmount),
cnnMainQuantity = g.Sum(s => s.cnnMainQuantity),
cnnQuantity = g.Key.cniChangRate == 0?0:g.Sum(s => s.cnnMainQuantity) / g.Key.cniChangRate,
cnnPrice = g.Sum(s => s.cnnMainQuantity) == 0?0:(g.Sum(s => s.cnnAmount) / g.Sum(s => s.cnnMainQuantity)) * g.Key.cniChangRate
}).ToList();
var g4 = (from d in g3 select new { d.cnvcWhCode, d.cnvcDeptId }).Distinct();
int icnnYear = tbMonthlyBalance.cnnYear;
int icnnMonth = tbMonthlyBalance.cnnMonth;
if (icnnMonth == 12)
{
icnnYear += 1;
icnnMonth = 1;
}
else
{
icnnMonth += 1;
}
DateTime cndBusinessDate = new DateTime(icnnYear, icnnMonth, 1);
foreach (var g5 in g4)
{
var g6 = (from d in g3 where d.cnvcDeptId == g5.cnvcDeptId && d.cnvcWhCode == g5.cnvcWhCode && d.cnvcInvCode != null select d).ToList();
if (g6.Count > 0)
{
DXInfo.Models.tbStockMain tbStockMain = AddStockMain(g5.cnvcWhCode, g5.cnvcDeptId, strOperId, strOperName, 0, cndBusinessDate);
foreach (var g7 in g6)
{
if (g7.cnnQuantity < 0 && g7.cnnAmount < 0 && g7.cnnMainQuantity < 0)
{
DXInfo.Models.tbStockMain tbStockMain2 = AddStockMain(g5.cnvcWhCode, g5.cnvcDeptId, strOperId, strOperName, 4, cndBusinessDate);
ServiceHelper.AddStockDetal(Uow, tbStockMain2, g7.cnvcInvCode, g7.cnvcComUnitCode, -g7.cnnQuantity.Value, g7.cnvcMainComUnitCode, -g7.cnnMainQuantity.Value, g7.cnnPrice.Value, -g7.cnnAmount.Value);
ServiceHelper.AddStockDetal(Uow, tbStockMain, g7.cnvcInvCode, g7.cnvcComUnitCode, 0, g7.cnvcMainComUnitCode, 0, g7.cnnPrice.Value, 0);
}
else
{
ServiceHelper.AddStockDetal(Uow, tbStockMain, g7.cnvcInvCode, g7.cnvcComUnitCode, g7.cnnQuantity.Value, g7.cnvcMainComUnitCode, g7.cnnMainQuantity.Value, g7.cnnPrice.Value, g7.cnnAmount.Value);
}
}
}
}
}