From 852cd93a3e65988a2354a0b96b79d5e2d05bf646 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 14 四月 2023 09:23:25 +0800
Subject: [PATCH] 工序流转卡 工艺参数 应该 可编辑； 1.生产资源 有异常； 删除有问题，删除后出来 异常数据( )； 其他信息 里的 几个字段 输入 字符时 报错，应提示； 2.工序 ： 9999的 转工序 ， 有个 转工序 字段，是否没显示出来； 其他信息 里的 几个字段 输入 字符时 报错，应提示； 3.工作中心： 其他信息 里的 几个字段 输入 字符时 报错，应提示； 4.生产班组： 刷新出来 异常数据； 其他信息 里的 几个字段 输入 字符时 报错，应提示； 5.基础资料的 一些 复选框 标题不对； 6. ADMIN 的账号 工艺路线 的模块 无法进行 新增 编辑； 7.工艺路线查询；工序号，工序代码，工序，工艺参数，表体备注， 其他的放后面 子表 的 委外标记 放到最后面去； 并且 把 供应商代码和供应商 放出来（也放在最后几个）； 8.部门有 很多异常数据； 选择的时候 出来了； 9.流转卡维护， 表头 很多没有用的列，单据号 日期 都没有显示； 转工序 是否要打印（跟客户确认）； 10. 流转卡拆分时，一些 列的 排序；
---
WebAPI/DLL/ClsSc_ProcessReport.cs | 59 +++++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 49 insertions(+), 10 deletions(-)
diff --git a/WebAPI/DLL/ClsSc_ProcessReport.cs b/WebAPI/DLL/ClsSc_ProcessReport.cs
index b27244c..f1c9bb5 100644
--- a/WebAPI/DLL/ClsSc_ProcessReport.cs
+++ b/WebAPI/DLL/ClsSc_ProcessReport.cs
@@ -7,8 +7,8 @@
{
public class ClsSc_ProcessReport:DBUtility.ClsXt_BaseBill
{
- public Model.ClsSc_ProcessReportMain omodel = new Model.ClsSc_ProcessReportMain();
- public List<Model.ClsSc_ProcessReportSub> DetailColl = new List<Model.ClsSc_ProcessReportSub>();
+ public Models.ClsSc_ProcessReportMain omodel = new Models.ClsSc_ProcessReportMain();
+ public List<Models.ClsSc_ProcessReportSub> DetailColl = new List<Models.ClsSc_ProcessReportSub>();
public ClsSc_ProcessReport()
{
@@ -71,7 +71,7 @@
DeleteBillSub(lngBillKey);
//鎻掑叆瀛愯〃
omodel.HInterID = lngBillKey;
- foreach (Model.ClsSc_ProcessReportSub oSub in DetailColl)
+ foreach (Models.ClsSc_ProcessReportSub oSub in DetailColl)
{
oCn.RunProc("Insert into Sc_ProcessReportSub " +
" (HInterID,HEntryID,HProcID,HProcNumber,HEmpID" +
@@ -143,8 +143,10 @@
",'" + omodel.HInnerBillNo + "','" + omodel.HMaker.ToString() + "',getdate()," + omodel.HSupID.ToString() + ",'" + omodel.HMarker + "'" +
") ");
//鎻掑叆瀛愯〃
- foreach (Model.ClsSc_ProcessReportSub oSub in DetailColl)
+ foreach (Models.ClsSc_ProcessReportSub oSub in DetailColl)
{
+
+
oCn.RunProc("Insert into Sc_ProcessReportSub " +
" (HInterID,HEntryID,HProcID,HProcNumber,HEmpID" +
",HMaterID,HMaterNumber,HOutPrice,HOutMoney" +
@@ -158,7 +160,7 @@
"HSecUnitQty1,HSecUnitRate1,HSecUnitQty2,HSecUnitRate2,HUsingQty,"+
"HSelfBadCount,HPreBadCount,HPayMentQty,HOtherDeduct,HRelPay,"+
"HOtherItem1,HOtherItem2,HOtherItem3,HOtherItem4,HOtherItem5,"+
- "HPackType,HCheckEmpID,HWeight,HBatchNo" +
+ "HPackType,HCheckEmpID,HWeight,HBatchNo,HRelationInterID" +
") values("
+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNumber + "'," + oSub.HEmpID.ToString() +
"," + oSub.HMaterID.ToString() + ",'" + oSub.HMaterNumber + "'," + oSub.HOutPrice.ToString() + "," + oSub.HOutMoney.ToString() +
@@ -173,17 +175,19 @@
"," + oSub.HSecUnitQty1.ToString() + "," + oSub.HSecUnitRate1.ToString() + "," + oSub.HSecUnitQty2.ToString() + "," + oSub.HSecUnitRate2.ToString() + "," + oSub.HUsingQty.ToString() +
"," + oSub.HSelfBadCount.ToString() + "," + oSub.HPreBadCount.ToString() + "," + oSub.HPayMentQty.ToString() + "," + oSub.HOtherDeduct.ToString() + "," + oSub.HRelPay.ToString() +
",'" + oSub.HOtherItem1.ToString() + "','" + oSub.HOtherItem2.ToString() + "','" + oSub.HOtherItem3.ToString() + "','" + oSub.HOtherItem4.ToString() + "','" + oSub.HOtherItem5.ToString() +
- "','" + oSub.HPackType.ToString() + "'," + oSub.HCheckEmpID.ToString() + "," + oSub.HWeight.ToString() + ",'" + oSub.HBatchNo + "'" +
+ "','" + oSub.HPackType.ToString() + "'," + oSub.HCheckEmpID.ToString() + "," + oSub.HWeight.ToString() + ",'" + oSub.HBatchNo + "','0'" +
") ");
}
//鏇存柊鍏宠仈鏁伴噺
- AddNewRelation(ref sReturn, omodel.HInterID);
+ //AddNewRelation(ref sReturn, omodel.HInterID);
+ //鏇存柊鍏宠仈鏁伴噺
+ oCn.RunProc("exec h_p_Sc_UpDateICMOBillStepStatusRelation_Add " + omodel.HInterID);
//鍥炲～ 鐢熶骇鐘舵�佽〃 鏃ヨ鍒� 涓� 宸插畬宸� 鐘舵��
- oCn.RunProc("exec h_p_Sc_UpDateICMOBillQualityStatus " + omodel.HICMOStatusInterID.ToString() + ",3");
+ //oCn.RunProc("exec h_p_Sc_UpDateICMOBillQualityStatus " + omodel.HICMOStatusInterID.ToString() + ",3");
//榛樿鍙樹负 鐢宠妫�楠岀姸鎬�
oCn.RunProc("exec h_p_Sc_UpDateProcessReportStatus " + omodel.HInterID.ToString() + ",15");
//
- sReturn = "鏂板鍗曟嵁鎴愬姛锛�";
+ sReturn = omodel.HInterID.ToString();
oCn.Commit();
return true;
}
@@ -257,7 +261,7 @@
DetailColl.Clear();//娓呯┖
for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
{
- Model.ClsSc_ProcessReportSub oSub = new Model.ClsSc_ProcessReportSub();
+ Models.ClsSc_ProcessReportSub oSub = new Models.ClsSc_ProcessReportSub();
oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
//
@@ -374,6 +378,41 @@
}
}
+ //鍙嶅鏍�
+ public bool AbandonCheck(Int64 lngBillKey, ref string sReturn)
+ {
+ DataSet oDs = new DataSet();
+ string sBillName = "";
+ sReturn = "";
+ try
+ {
+ string HChecker = DBUtility.ClsPub.CurUserName;
+ string HCheckDate = DBUtility.ClsPub.GetServerDate(-1);
+ //
+ oDs = oCn.RunProcReturn("select * from Sc_ProcessReportSub where HInterID=" + lngBillKey.ToString(), "Sc_ProcessReportSub");
+ if (oDs == null || oDs.Tables[0].Rows.Count == 0)
+ {
+ return false;
+ }
+ for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++)
+ {
+ long ProdMoveInterID = DBUtility.ClsPub.CreateBillID("3771", ref DBUtility.ClsPub.sExeReturnInfo);
+ string ProdMoveBillNo = DBUtility.ClsPub.CreateBillCode("3771", ref DBUtility.ClsPub.sExeReturnInfo, true);
+ //oCn.RunProc("exec h_p_Sc_ProcProdMoveBill_Add " + lngBillKey.ToString() + "," + DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[i]["HEntryID"]).ToString() + "," + ProdMoveInterID.ToString() + ",'" + ProdMoveBillNo + "','" + HChecker + "'");
+ sBillName = sBillName + ProdMoveBillNo + ",";
+ }
+ oCn.RunProc(" Update " + MvarItemKey + " set HBillStatus='1',HChecker='',HCheckDate='' Where HInterID=" + lngBillKey.ToString());
+
+ sReturn = sBillName;
+ return true;
+ }
+ catch (Exception e)
+ {
+ sReturn = e.Message;
+ throw (e);
+ }
+ }
+
//鍒犻櫎鍏宠仈
public override void DeleteRelation(ref string sReturn, Int64 lngBillKey)
--
Gitblit v1.9.1