private void CkBzFlg(sivc q)
{
//盘点是否有为空的明细
var qrydtl = q.sivcdtl.Where(e => e.qty == 0 && e.bzflg == GetN());
foreach (sivcdtl d in qrydtl)
{
d.bzflg = GetY();
d.bzr = LoginInfo.Usrid;
d.bzdat = GetCurrentDate();
}
WmsDc.SubmitChanges();
//修改播种标记
q.bzflg = GetY();
//审核配送单
q.chkflg = GetY();
q.chkdat = GetCurrentDay();
q.ckr = LoginInfo.Usrid;
//记账gdsbs
List <gdsbs> lstGdsbs = new List <gdsbs>();
foreach (var t in q.sivcdtl)
{
gdsbs g = new gdsbs();
//g.actid = t.actid;
//g.brief = t.brief;
g.srcbllno = t.sivcno;
g.srcrcdidx = t.rcdidx;
g.fscprdid = GetCurrentFscprdid();
g.bllid = t.sivc.bllid;
g.dptid = t.sivc.dptid;
g.depid = t.depid;
g.empid = LoginInfo.Usrid;
g.gdsid = t.gdsid;
g.actdat = GetCurrentDay();
g.dbtcrt = '1';
g.qty = t.qty;
g.prc = t.prc;
g.amt = t.amt;
g.bthno = t.bthno;
g.vlddat = t.vlddat;
g.bcd = t.bcd;
g.mctortrust = t.mctortrust;
g.prvid = t.prvid;
g.dlvprc = t.dlvprc;
g.taxflg = t.taxflg;
g.branchid = GetBranchid(t.sivc.savdptid);
lstGdsbs.Add(g);
}
WmsDc.gdsbs.InsertAllOnSubmit(lstGdsbs);
stklst astklst = new stklst();
astklst.stkouno = q.sivcno;
WmsDc.stklst.InsertOnSubmit(astklst);
}
private void CkBzFlg(stkot p)
{
//盘点是否有为空的明细
var qrydtl = p.stkotdtl.Where(e => e.qty == 0 && e.bzflg == GetN());
foreach (stkotdtl d in qrydtl)
{
d.bzflg = GetY();
d.bzr = LoginInfo.Usrid;
d.bzdat = GetCurrentDate();
}
WmsDc.SubmitChanges();
//修改播种标记
p.bzflg = GetY();
//审核配送单
p.chkflg = GetY();
p.chkdat = GetCurrentDay();
p.ckr = LoginInfo.Usrid;
WmsDc.SubmitChanges();
//写入dtrlog
//查看是否dtrlog已经有单据,没有就插入
var qry = WmsDc.dtrlog
.Where(e => e.rcvdptid == p.rcvdptid && e.bllno == p.stkouno && e.bllid == p.bllid)
.Select(e => e.bllno);
var arrqry = qry.ToArray();
if (arrqry.Length <= 0)
{
dtrlog dl = new dtrlog();
dl.bllid = p.bllid;
dl.bllno = p.stkouno;
dl.rcvdptid = p.rcvdptid;
WmsDc.dtrlog.InsertOnSubmit(dl);
}
WmsDc.SubmitChanges();
if (!(WmsDc.stklst.Where(e => e.stkouno == p.stkouno)).Any())
{
stklst astklst = new stklst();
astklst.stkouno = p.stkouno;
WmsDc.stklst.InsertOnSubmit(astklst);
//WmsDc.SubmitChanges();
}
WmsDc.SubmitChanges();
}
private void CkBzFlg(stkot p)
{
i(p.wmsno, "", System.DateTime.Now.ToString("yyyyMMddHHmmss.fff"), Request["rnd"], "3", LoginInfo.DefSavdptid);
//盘点是否有为空的明细
var qrydtl = p.stkotdtl.Where(e => e.qty == 0 && e.bzflg == GetN());
foreach (stkotdtl d in qrydtl)
{
d.bzflg = GetY();
d.bzr = LoginInfo.Usrid;
d.bzdat = GetCurrentDate();
}
WmsDc.SubmitChanges();
//修改播种标记
p.bzflg = GetY();
//审核配送单
p.chkflg = GetY();
p.chkdat = GetCurrentDay();
p.ckr = LoginInfo.Usrid;
//写入dtrlog
//查看是否dtrlog已经有单据,没有就插入
var qry = WmsDc.dtrlog
.Where(e => e.rcvdptid == p.rcvdptid && e.bllno == p.stkouno && e.bllid == p.bllid)
.Select(e => e.bllno);
var arrqry = qry.ToArray();
if (arrqry.Length <= 0)
{
dtrlog dl = new dtrlog();
dl.bllid = p.bllid;
dl.bllno = p.stkouno;
dl.rcvdptid = p.rcvdptid;
WmsDc.dtrlog.InsertOnSubmit(dl);
}
if (!(WmsDc.stklst.Where(e => e.stkouno == p.stkouno)).Any())
{
stklst astklst = new stklst();
astklst.stkouno = p.stkouno;
WmsDc.stklst.InsertOnSubmit(astklst);
WmsDc.SubmitChanges();
}
i(p.wmsno, "", System.DateTime.Now.ToString("yyyyMMddHHmmss.fff"), Request["rnd"], "4", LoginInfo.DefSavdptid);
}
private void CkBzFlg(stkin q)
{
//盘点是否有为空的明细
var qrydtl = q.stkindtl.Where(e => e.qty == 0 && e.bzflg == GetN());
foreach (stkindtl d in qrydtl)
{
d.bzflg = GetY();
d.bzr = LoginInfo.Usrid;
d.bzdat = GetCurrentDate();
}
WmsDc.SubmitChanges();
//修改播种标记
q.outflg = GetY();
q.outdat = GetCurrentDay();
//审核配送单
q.chkflg = GetY();
q.chkdat = GetCurrentDay();
q.ckr = LoginInfo.Usrid;
//记账gdsbs
//记账gdsbs
List <gdsbs> lstGdsbs = new List <gdsbs>();
foreach (var t in q.stkindtl)
{
gdsbs g = new gdsbs();
//g.actid = t.actid;
//g.brief = t.brief;
g.srcbllno = t.stkinno;
g.srcrcdidx = t.rcdidx;
g.fscprdid = GetCurrentFscprdid();
g.bllid = t.stkin.bllid;
g.dptid = t.stkin.dptid;
g.depid = t.depid;
g.empid = LoginInfo.Usrid;
g.gdsid = t.gdsid;
g.actdat = GetCurrentDay();
g.dbtcrt = '0';
g.qty = t.qty;
g.prc = t.prc.Value;
g.amt = t.amt.Value;
g.bthno = t.bthno;
g.vlddat = t.vlddat;
g.bcd = t.bcd;
g.mctortrust = t.mctortrust;
g.prvid = t.prvid;
g.dlvprc = t.dlvprc;
g.taxflg = t.taxflg;
g.branchid = GetBranchid(t.stkin.savdptid);
lstGdsbs.Add(g);
}
var qrysftdtl = from e in WmsDc.sftdtl
where e.stkinno == q.stkinno
select e;
sftdtl sd = qrysftdtl.ToArray()[0];
foreach (var t in q.stkindtl)
{
gdsbs g = new gdsbs();
//g.actid = t.actid;
//g.brief = t.brief;
g.srcbllno = t.stkinno;
g.srcrcdidx = t.rcdidx;
g.fscprdid = GetCurrentFscprdid();
g.bllid = t.stkin.bllid;
g.dptid = sd.sft_dptout;
g.depid = sd.sft_depout;
g.empid = LoginInfo.Usrid;
g.gdsid = t.gdsid;
g.actdat = GetCurrentDay();
g.dbtcrt = '1';
g.qty = t.qty;
g.prc = t.prc.Value;
g.amt = t.amt.Value;
g.bthno = t.bthno;
g.vlddat = t.vlddat;
g.bcd = t.bcd;
g.mctortrust = t.mctortrust;
g.prvid = t.prvid;
g.dlvprc = t.dlvprc;
g.taxflg = t.taxflg;
g.branchid = GetBranchid(sd.sft_sdtout);
lstGdsbs.Add(g);
}
WmsDc.gdsbs.InsertAllOnSubmit(lstGdsbs);
stklst astklst = new stklst();
astklst.stkouno = q.stkinno;
WmsDc.stklst.InsertOnSubmit(astklst);
}
