public ActionResult CancelAdtDtl(String wmsno, String gdsid, int rcdidx)
{
//检查单号是否存在
var qrymst = from e in WmsDc.wms_cang_105
where e.wmsno == wmsno &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrymst = qrymst.ToArray();
var qrydtl = from e in WmsDc.wms_cangdtl_105
where e.wmsno == wmsno &&
e.gdsid == gdsid && e.rcdidx == rcdidx &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrydtl = qrydtl.ToArray();
//单据是否找到
if (arrqrymst.Length <= 0)
{
return(RNoData("N0106"));
}
//检查是否有数据权限
wms_cang_105 mst = arrqrymst[0];
////正在生成拣货单，请稍候重试
//string quRetrv = mst.qu;
//if (DoingRetrieve(LoginInfo.DefStoreid, quRetrv))
//{
// return RInfo( "I0161" );
//}
/*if (!qus.Contains(mst.qu))
* {
* return RInfo( "I0162" );
* }*/
// 判断有无重新复核的权限
// 检查单号是否已经审核
if (mst != null && mst.chkflg == GetY())
{
return(RInfo("I0163"));
}
if (arrqrydtl.Length <= 0)
{
return(RNoData("N0107"));
}
wms_cangdtl_105 dtl = arrqrydtl[0];
dtl.bokflg = GetN();
dtl.bokdat = GetCurrentDate();
dtl.bkr = "";
try
{
WmsDc.SubmitChanges();
return(RSucc("成功", null, "S0092"));
}
catch (Exception ex)
{
return(RErr(ex.Message, "E0020"));
}
}
public ActionResult HasChecked(String boci, String barcode, String gdsid, String gdstype)
{
wms_cangdtl_105 d = new wms_cangdtl_105();
d.oldbarcode = boci; //oldbarcode 临时传入盘点批次
d.barcode = barcode;
d.gdsid = gdsid;
d.gdstype = gdstype;
//判断分区是否有效
if (!IsExistBarcode(barcode))
{
return(RInfo("I0157", barcode.Trim()));
}
if (HasChecked(d))
{
return(RInfo("I0158"));
}
return(RSucc("该商品尚未盘过", null, "S0084"));
}
/// <summary>
/// 是否已经盘过点了
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
private bool HasChecked(wms_cangdtl_105 d)
{
/*var q1 = from e in WmsDc.wms_cang_105
* join e1 in WmsDc.wms_cang_105 on new { e.lnkbocino, e.times } equals new { e1.lnkbocino, e1.times }
* where e.wmsno == d.wmsno && e.times == "2"
* select e1.wmsno;*/
var qry = from e in WmsDc.wms_cangdtl_105
join e1 in WmsDc.wms_cang_105 on new { e.wmsno, e.bllid } equals new { e1.wmsno, e1.bllid }
where
//q1.Contains(e.wmsno.Trim())
e1.lnkbocino == d.oldbarcode.Trim() &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK &&
e1.times == "2" &&
e.gdsid == d.gdsid.Trim() && e.gdstype == d.gdstype.Trim() && //&& e.bthno == d.bthno && e.vlddat == d.vlddat
(e1.savdptid == LoginInfo.DefSavdptid || e1.savdptid == LoginInfo.DefCsSavdptid) &&
e.barcode == d.barcode.Trim()
select e;
var arrqry = qry.ToArray();
return(arrqry.Length > 0);
}
private ActionResult _MakeParam(String wmsno, String oldbarcodes, String gdsids, String gdstypes, String bthnos, String vlddats, String qtys)
{
String[] oldbarcode = oldbarcodes.Split(',');
String[] gdsid = gdsids.Split(',');
String[] qty = qtys.Split(',');
String[] gdstype = gdstypes.Split(',');
String[] bthno = bthnos.Split(',');
String[] vlddat = vlddats.Split(',');
//String[] newsbarcode = newbarcodes.Split(',');
List <wms_cangdtl_105> lstDtl = new List <wms_cangdtl_105>();
if ((oldbarcode.Length != gdsid.Length) &&
(oldbarcode.Length != qty.Length) &&
(oldbarcode.Length != gdstype.Length))
{
return(RInfo("I0131"));
}
//检查盘点抄账单是否有单据
var qrycz = from e in WmsDc.wms_cang_105
where e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK &&
e.wmsno == wmsno && e.times == "2"
select e;
var arrqrycz = qrycz.ToArray();
if (arrqrycz.Length <= 0)
{
return(RNoData("N0087"));
}
//判断盘点是否结束，结束不允许制单
wms_cang_105 czmst = arrqrycz[0];
if (czmst.chkflg == GetY())
{
return(RInfo("I0132"));
}
//盘点传来的参数是否有barcode的权限
String[] pwdBarcodes = GetBarcodesByBoci(czmst.lnkbocino);
if (pwdBarcodes == null)
{
return(RInfo("I0133"));
}
var qryPdcang = from e in oldbarcode
where pwdBarcodes.Contains(e.Trim())
select e;
if (qryPdcang.Count() <= 0)
{
return(RNoData("N0088"));
}
//查询idx最大值
var qrymx = from e in WmsDc.wms_cangdtl_105
where e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK &&
e.wmsno == wmsno
orderby e.rcdidx descending
select e;
var arrqrymx = qrymx.ToArray();
int i = 0, ii = 0;
if (arrqrymx.Length > 0)
{
i = arrqrymx[0].rcdidx;
}
foreach (String s in oldbarcode)
{
if (!String.IsNullOrEmpty(s))
{
//判断分区是否有效
if (!IsExistBarcode(s))
{
return(RInfo("I0134", s.Trim()));
}
wms_cangdtl_105 dtl = new wms_cangdtl_105();
dtl.wmsno = wmsno;
dtl.bllid = WMSConst.BLL_TYPE_INVENTORY_CHECK;
dtl.rcdidx = i + 1;
dtl.barcode = s;
dtl.gdsid = gdsid[ii];
dtl.gdstype = gdstype[ii];
dtl.pkgid = "01";
double fQty = 0;
if (!double.TryParse(qty[ii], out fQty))
{
return(RInfo("I0135", gdsid[i], qty[ii]));
}
dtl.qty = Math.Round(fQty, 4, MidpointRounding.AwayFromZero);
dtl.preqty = Math.Round(fQty, 4, MidpointRounding.AwayFromZero);
dtl.pkgqty = Math.Round(fQty, 4, MidpointRounding.AwayFromZero);
dtl.gdstype = gdstype[ii];
dtl.bthno = string.IsNullOrEmpty(bthno[ii]) ? "1" : bthno[ii];
dtl.vlddat = string.IsNullOrEmpty(vlddat[ii]) ? GetCurrentDay() : vlddat[ii];
if (gdsid[ii] != "1")
{
JsonResult jr = (JsonResult)GetBcdByGdsid(gdsid[ii]);
ResultMessage rm = (ResultMessage)jr.Data;
if (rm.ResultCode != ResultMessage.RESULTMESSAGE_SUCCESS)
{
return(RInfo("I0136", gdsid[ii]));
}
bcd[] b = (bcd[])rm.ResultObject;
dtl.bcd = b[0].bcd1;
}
else
{
dtl.bcd = "";
}
dtl.bkr = "";
dtl.bokflg = GetN();
dtl.bokdat = GetCurrentDate();
lstDtl.Add(dtl);
i++;
ii++;
}
}
return(RSucc("成功", lstDtl.ToArray(), "S0077"));
}
/// <summary>
/// 盘点单明细修改
/// </summary>
/// <param name="wmsno"></param>
/// <param name="gdsid"></param>
/// <param name="rcdidx"></param>
/// <param name="qty"></param>
/// <returns></returns>
public ActionResult MdInvCkBllDtl(String wmsno, String gdsid, int rcdidx, double qty)
{
//检查单号是否存在
var qrymst = from e in WmsDc.wms_cang_105
where e.wmsno == wmsno &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrymst = qrymst.ToArray();
var qrydtl = from e in WmsDc.wms_cangdtl_105
where e.wmsno == wmsno &&
e.gdsid == gdsid && e.rcdidx == rcdidx &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrydtl = qrydtl.ToArray();
//单据是否找到
if (arrqrymst.Length <= 0)
{
return(RNoData("N0092"));
}
//检查是否有数据权限
wms_cang_105 mst = arrqrymst[0];
////正在生成拣货单，请稍候重试
//string quRetrv = mst.qu;
//if (DoingRetrieve(LoginInfo.DefStoreid, quRetrv))
//{
// return RInfo( "I0144" );
//}
if (!qus.Contains(mst.qu.Trim()))
{
return(RInfo("I0145"));
}
//检查单号是否已经审核
if (mst != null && mst.chkflg == GetY())
{
return(RInfo("I0146"));
}
if (arrqrydtl.Length <= 0)
{
return(RNoData("N0093"));
}
wms_cangdtl_105 dtl = arrqrydtl[0];
//明细如果已经确认就不能修改明细了
if (dtl.bokflg == GetY())
{
return(RInfo("I0147"));
}
dtl.qty = Math.Round(qty, 4, MidpointRounding.AwayFromZero);
dtl.pkgqty = dtl.qty;
dtl.preqty = dtl.qty;
try
{
WmsDc.SubmitChanges();
return(RSucc("成功", null, "S0081"));
}
catch (Exception ex)
{
return(RErr(ex.Message, "E0017"));
}
}
public ActionResult AdtInvChkDtl(String wmsno, String gdsid, int rcdidx, double?qty)
{
//检查单号是否存在
var qrymst = from e in WmsDc.wms_cang_105
where e.wmsno == wmsno &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrymst = qrymst.ToArray();
var qrydtl = from e in WmsDc.wms_cangdtl_105
where e.wmsno == wmsno &&
e.gdsid == gdsid && e.rcdidx == rcdidx &&
e.bllid == WMSConst.BLL_TYPE_INVENTORY_CHECK
select e;
var arrqrydtl = qrydtl.ToArray();
//单据是否找到
if (arrqrymst.Length <= 0)
{
return(RNoData("N0108"));
}
//检查是否有数据权限
wms_cang_105 mst = arrqrymst[0];
////正在生成拣货单，请稍候重试
//string quRetrv = mst.qu;
//if (DoingRetrieve(LoginInfo.DefStoreid, quRetrv))
//{
// return RInfo( "I0164" );
//}
/*if (!qus.Contains(mst.qu))
* {
* return RInfo( "I0165" );
* }*/
// 判断有无重新复核的权限
// 检查单号是否已经审核
if (mst.chkflg == GetY())
{
return(RInfo("I0166"));
}
if (arrqrydtl.Length <= 0)
{
return(RNoData("N0109"));
}
wms_cangdtl_105 dtl = arrqrydtl[0];
if (dtl.bokflg == GetY())
{
return(RInfo("I0167"));
}
dtl.bokflg = GetY();
dtl.bokdat = GetCurrentDay();
dtl.bkr = LoginInfo.Usrid;
if (qty != null)
{
dtl.qty = qty.Value;
dtl.pkgqty = qty.Value;
dtl.preqty = qty.Value;
}
try
{
WmsDc.SubmitChanges();
return(RSucc("成功", null, "S0093"));
}
catch (Exception ex)
{
return(RErr(ex.Message, "E0021"));
}
}
