private string updatetbStockMain(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbStockMain tbStockMain = Uow.tbStockMain.GetById(g => g.cnnMainId == Convert.ToInt64(context.Request.Form["cnnId"]));
tbStockMain.cnvcSupplierCode = context.Request.Form["cnvcSupplierCode"];
tbStockMain.cnvcWhCode = context.Request.Form["cnvcWhCode"];
tbStockMain.cnvcDeptId = context.Request.Form["cnvcDeptId"];
tbStockMain.cndCheckDate = Convert.ToDateTime(context.Request.Form["cndCheckDate"]);
tbStockMain.cnvcCheckerId = context.Request.Form["cnvcCheckerId"];
tbStockMain.cnvcCheckerName = context.Request.Form["cnvcCheckerName"];
tbStockMain.cndBusinessDate = Convert.ToDateTime(context.Request.Form["cndBusinessDate"]);
tbStockMain.cnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]);
tbStockMain.cnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]);
tbStockMain.cnnStatus = Convert.ToInt32(context.Request.Form["cnnStatus"]);
tbStockMain.cnvcComments = context.Request.Form["cnvcComments"];
Uow.Commit();
//}
}
catch (NullReferenceException nex)
{
ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message)));
}
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 DXInfo.Models.tbStockMain AddStockMain(string cnvcWhCode, string cnvcDeptId, string strOperId, string strOperName,
int cnnOperType, DateTime cndBusinessDate)
{
DXInfo.Models.tbStockMain tbStockMain = new DXInfo.Models.tbStockMain();
tbStockMain.cnvcWhCode = cnvcWhCode;
tbStockMain.cnvcDeptId = cnvcDeptId;
tbStockMain.cnnOperType = cnnOperType;
tbStockMain.cnnSource = 1;
tbStockMain.cndCreateDate = DateTime.Now;
tbStockMain.cnvcCreaterId = strOperId;
tbStockMain.cnvcCreaterName = strOperName;
tbStockMain.cndCheckDate = tbStockMain.cndCreateDate;
tbStockMain.cnvcCheckerId = tbStockMain.cnvcCreaterId;
tbStockMain.cnvcCheckerName = tbStockMain.cnvcCreaterName;
tbStockMain.cndBusinessDate = cndBusinessDate;
tbStockMain.cnnYear = cndBusinessDate.Year;
tbStockMain.cnnMonth = cndBusinessDate.Month;
tbStockMain.cnnStatus = (int)StockStatus.Check;
tbStockMain.cnvcComments = "月结自动生成下月期初库存";
Uow.tbStockMain.Add(tbStockMain);
Uow.Commit();
DXInfo.Models.tbStockMainLog tbStockMainLog = new DXInfo.Models.tbStockMainLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockMain, DXInfo.Models.tbStockMainLog>(tbStockMain, tbStockMainLog);
Uow.tbStockMainLog.Add(tbStockMainLog);
return(tbStockMain);
}
private string removetbStockMain(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbStockMain tbStockMain = Uow.tbStockMain.GetById(g => g.cnnMainId == Convert.ToInt64(context.Request.Form["cnnId"]));
Uow.tbStockMain.Delete(tbStockMain);
Uow.Commit();
//}
}
catch (ArgumentNullException aex)
{
ExceptionPolicy.HandleException(aex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, aex.Message)));
}
catch (DbUpdateException dex)
{
ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy);
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message)));
}
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, "")));
}
public static void AddStockDetal(IAMSCMUow uow, DXInfo.Models.tbStockMain tbStockMain, string cnvcInvCode
, string cnvcComUnitCode, decimal cnnQuantity, string cnvcMainComUnitCode, decimal cnnMainQuantity, decimal cnnPrice, decimal cnnAmount)
{
DXInfo.Models.tbStockDetail tbStockDetail = new DXInfo.Models.tbStockDetail();
tbStockDetail.cnnMainId = tbStockMain.cnnMainId;
tbStockDetail.cnvcInvCode = cnvcInvCode;
tbStockDetail.cnvcComUnitCode = cnvcComUnitCode;
tbStockDetail.cnnQuantity = cnnQuantity;
tbStockDetail.cnvcMainComUnitCode = cnvcMainComUnitCode;
tbStockDetail.cnnMainQuantity = cnnMainQuantity;
tbStockDetail.cnnPrice = cnnPrice;
tbStockDetail.cnnAmount = cnnAmount;
tbStockDetail.cndOperDate = tbStockMain.cndCreateDate;
tbStockDetail.cnvcOper = tbStockMain.cnvcCreaterId;
tbStockDetail.cnvcOperName = tbStockMain.cnvcCreaterName;
uow.tbStockDetail.Add(tbStockDetail);
uow.Commit();
DXInfo.Models.tbStockDetailLog tbStockDetailLog = new DXInfo.Models.tbStockDetailLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockDetail, DXInfo.Models.tbStockDetailLog>(tbStockDetail, tbStockDetailLog);
uow.tbStockDetailLog.Add(tbStockDetailLog);
}
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);
}
}
}
}
}