public ServerResponse <string> LockAuthority(JObject form) { if (_zl11Repository.GetCtrl("QSBN_LOCK", "01").drpValue.Contains(GetUser())) { return(ServerResponse <string> .CreateBySuccessMessage("OK!")); } else { return(ServerResponse <string> .CreateByErrorMessage("操作错误,仅关务有加锁和解锁的权限 !")); } }
public ServerResponse <string> LockClick(JObject form) { try { _zl11Repository.LockClick(form["BUKRS"].ToString(), form["MATNR"].ToString(), form["Vendorcode"].ToString(), form["Type"].ToString(), form["LOCK"].ToString()); return(ServerResponse <string> .CreateBySuccessMessage("Success")); } catch (Exception e) { return(ServerResponse <string> .CreateByErrorMessage("Error" + e.Message)); } }
public ServerResponse <JArray> Query(JObject form) { //TODO。。。判空 //太慢 var result = _zl11Repository.Query(form); if (result == null || result.Count() == 0) { return(ServerResponse <JArray> .CreateByErrorMessage("无数据!")); } else { return(ServerResponse <JArray> .CreateBySuccess(JArray.FromObject(_zl11Repository.Query(form)))); } }
public ServerResponse <string> Delete(JObject form) { JArray forms = JArray.FromObject(form["data"]); var delReason = form["delReason"].ToString(); try { foreach (var data in forms) { _zl11Repository.Delete(form["Type"].ToString(), form["MANDT"].ToString(), form["BUKRS"].ToString(), form["MATNR"].ToString(), form["Vendorcode"].ToString(), form["DECLITEM"].ToString(), GetUser(), delReason); } return(ServerResponse <string> .CreateBySuccessMessage("删除成功!")); } catch { return(ServerResponse <string> .CreateByErrorMessage("删除失败!")); } }
public ServerResponse <string> Save(JArray form) { var userName = GetUser(); string strBeiZhu = ""; bool flag = false; IList <VIEW_spare_All> zl11s = form.ToObject <IList <VIEW_spare_All> >(); foreach (var zl11 in zl11s) { zl11.CHNAME = userName; zl11.CHDATE = DateTime.Now.Date.ToString("yyyyMMdd"); if (!zl11.Type.Equals("放弃退税") && _zl11Repository.CheckDiff(zl11.BUKRS, zl11.MATNR, zl11.SMAKTX, zl11.TAX_CODE, zl11.CGEWEI, zl11.DECLITEM) && !_zl11Repository.GetCtrl("QSBN_CheckDiff", "01").drpValue.Contains(userName)) { return(ServerResponse <string> .CreateByErrorMessage("料号" + zl11.MATNR + "备案不一致,请确认!")); } #region 国内Vendor Beizhu必填 境外Vendor 能效标识必填 if (zl11.Vendorcode.Equals("QCI_MRO") || zl11.Vendorcode.Substring(zl11.Vendorcode.Length - 1, 1) == "F") { if ((_tdsYitemRepository.Is3C(zl11.BUKRS, zl11.DECLITEM) & zl11.C3FLAG == "不涉及") & (_tdsYitemRepository.IsEnergy(zl11.BUKRS, zl11.DECLITEM) & zl11.CELFLAG == "不涉及")) { strBeiZhu += "【" + zl11.BUKRS + ',' + zl11.DECLITEM + ',' + zl11.MATNR + "涉及3C验证;" + zl11.Vendorcode + ',' + zl11.MATNR + "涉及能效标识" + "】"; } else if ((_tdsYitemRepository.Is3C(zl11.BUKRS, zl11.DECLITEM) & zl11.C3FLAG == "不涉及")) { strBeiZhu += "【" + zl11.BUKRS + ',' + zl11.DECLITEM + ',' + zl11.MATNR + "涉及3C验证】"; } else if (_tdsYitemRepository.IsEnergy(zl11.BUKRS, zl11.DECLITEM) & zl11.CELFLAG == "不涉及") { strBeiZhu += "【" + zl11.BUKRS + ',' + zl11.Vendorcode + ',' + zl11.MATNR + "涉及能效标识" + "】"; } else { if (zl11.BRGEW != "")//BRGEW zhengsui { strBeiZhu += "【" + zl11.BUKRS + ',' + zl11.Vendorcode + ',' + zl11.MATNR + "涉及" + zl11.BRGEW + "】"; } flag = InsertMro(zl11); } } else if (zl11.Vendorcode.Substring(zl11.Vendorcode.Length - 1, 1) == "L" || zl11.Vendorcode != "QCI_MRO") { if (zl11.C3REMARK == "无备注") { strBeiZhu += "【" + zl11.BUKRS + ',' + zl11.Vendorcode + ',' + zl11.MATNR + "备注栏位必填" + "】"; } else { flag = InsertMro(zl11); } } #endregion } //todo...有问题,循环插入没办法判断是否保存成功 if (flag) { return(ServerResponse <string> .CreateBySuccessMessage("Save Successfully" + strBeiZhu)); } else { return(ServerResponse <string> .CreateByErrorMessage("Save Error" + strBeiZhu)); } }
public ServerResponse <string> Save(JArray forms) { IList <tdsAupo> tdsAupos = new List <tdsAupo>(); string user = GetUser(); if (string.IsNullOrEmpty(user)) { return(ServerResponse <string> .CreateByErrorMessage("请求超时,请刷新主页重进!")); } foreach (var form in forms) { if (form["REMARK"].ToString().Equals("申请人确认抽单") && string.IsNullOrEmpty(form["DECLITEM"].ToString())) { } else { # region 境外po if (form["LIFNR"].ToString().Equals("QCI_MRO") || form["LIFNR"].ToString().Substring(form["LIFNR"].ToString().Length - 1, 1) == "F") //境外PO { if (_tdsYitemRepository.Is3C(form["BUKRS"].ToString(), form["DECLITEM"].ToString()) && form["MARK"].ToString().Equals("0")) { return(ServerResponse <string> .CreateByErrorMessage("此序号涉及3C认证!不能设置为不涉及!")); } if (_tdsYitemRepository.IsEnergy(form["BUKRS"].ToString(), form["DECLITEM"].ToString()) && form["CELFLAG"].ToString().Equals("0")) { return(ServerResponse <string> .CreateByErrorMessage("此序号涉及能源标识!不能设置为不涉及!")); } } #endregion #region 境内po else { string strFlag = _tdsYitemRepository.IsMonitorRule(form["BUKRS"].ToString(), form["DECLITEM"].ToString()); if (strFlag != "") { switch (strFlag) { case "3": return(ServerResponse <string> .CreateByErrorMessage("此序号涉及证件:3两用物项和技术出口许可证 ")); break; case "4": return(ServerResponse <string> .CreateByErrorMessage("此序号涉及证件:4出口许可证")); break; case "8": return(ServerResponse <string> .CreateByErrorMessage("此序号涉及证件:8禁止出口商品")); break; case "G": return(ServerResponse <string> .CreateByErrorMessage("此序号涉及证件:G两用物项和技术出口许可证(定向)")); break; default: break; } } } #endregion if (form["vendortype"].ToString() == "自主报关" || form["vendortype"].ToString() == "代理报关") { #region 料号的po:当有料号的po: 自主报关、代理报关、 在归类有料号的PO时,系统校验公司别+料号是否存在不一致的底账序号,如果有,系统提示;如果没有,系统保存成功 if (form["matnrE"].ToString() != "COASSET" && form["matnrE"].ToString() != "FOCCONSU" && form["matnrE"].ToString() != "") { if (!_tdsAupoRepository.IsExistZl11(form["BUKRS"].ToString(), form["matnrE"].ToString(), form["LIFNR"].ToString())) { return(ServerResponse <string> .CreateByErrorMessage("料号:" + form["matnrE"].ToString() + "在ZL11未备案!")); } if (!_tdsAupoRepository.SameDecMatnr(form["BUKRS"].ToString(), form["LIFNR"].ToString(), form["matnrE"].ToString(), form["DECLITEM"].ToString())) { return(ServerResponse <string> .CreateByErrorMessage("归并序号与ZL11序号不一致,请核实!")); } if (!_tdsAupoRepository.SameDecDiffEbeln(form["BUKRS"].ToString(), form["matnrE"].ToString(), form["DECLITEM"].ToString())) { if ((user != "03070472" && user != "06030239" && user != "A0070028" && user != "A0070116" && user != "A7100040" && user != "QSBN")) { return(ServerResponse <string> .CreateByErrorMessage("相同料号,不同PO中的底账序号不一致!")); } } } #endregion #region 无料号po:当没有料号的po:自主报关、代理报关、 同厂区(QSMC及QCMC公司别)、同VENDOR CODE、同Shorttext、归并底账序号不同时,无法保存 else { if (!"TFC_MRO,TFQ_MRO,TCC_MRO,TLC_MRO,TGC_MRO,TWW_MRO,TWQ_MRO,ZYS_MRO,ZYQ_MRO".Contains(form["LIFNR"].ToString())) { if (!_tdsAupoRepository.PoCheck(form["BUKRS"].ToString(), form["LIFNR"].ToString() , form["TXZ01"].ToString(), form["EBELN"].ToString() , form["vendortype"].ToString(), form["DECLITEM"].ToString()) && !"03070472,A0070028,A2132386,A0070116,06030239,QSBN,A7100040".Contains(user)) { return(ServerResponse <string> .CreateByErrorMessage("ITEM:" + form["EBELP"].ToString() + "相同Short text已归并过底账序号:" + form["DECLITEM"].ToString() + ",请确认")); } } } #endregion } #region 判断是否做过EC单1 if (_tdsAupoRepository.ECCheck(form["BUKRS"].ToString(), form["EBELN"].ToString(), form["EBELP"].ToString())) { return(ServerResponse <string> .CreateByErrorMessage("该PO已做过EC单!")); } #endregion } tdsAupo tdsAupo = new tdsAupo(); tdsAupo.MANDT = form["MANDT"].ToString(); tdsAupo.BUKRS = form["BUKRS"].ToString(); tdsAupo.EBELN = form["EBELN"].ToString(); //tdsAupo.EBELN = "111111111"; tdsAupo.EBELP = form["EBELP"].ToString(); tdsAupo.DECLITEM = form["DECLITEM"].ToString(); tdsAupo.MATNR = form["MATNR"].ToString(); tdsAupo.E_I = "I"; tdsAupo.TAX_CODE = form["TAX_CODE"].ToString(); tdsAupo.ZGEWEI = form["ZGEWEI"].ToString(); tdsAupo.SMAKTX = form["SMAKTX"].ToString(); tdsAupo.APPQTY = form["APPQTY"].ToObject <decimal>(); tdsAupo.DECLQTY = form["DECLQTY"].ToObject <decimal>(); tdsAupo.APFLAG = form["APFLAG"].ToString(); tdsAupo.STATUS = form["STATUS"].ToString(); tdsAupo.MARK = form["MARK"].ToString(); tdsAupo.REMARK = form["REMARK"].ToString(); tdsAupo.CHDATE = DateTime.Now; tdsAupo.CHNAME = user; tdsAupo.ZHENGSHUI = form["BRGEW"].ToString(); tdsAupo.HOMEORABROAD = string.Empty; tdsAupo.CELFLAG = form["CELFLAG"].ToString(); tdsAupo.ACCNO = form["BOITYP"].ToString(); tdsAupos.Add(tdsAupo); // 管制 string retrc = form["RETRC"].ToString(); // 新旧 string itemno = form["STATUS"].ToString(); _tdsAupoRepository.UpdateOtherDatas(tdsAupo, retrc, itemno); }