From a1709bcc95fe641126f5c34e0a344e406b467f88 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 16 五月 2023 11:11:15 +0800
Subject: [PATCH] 流转卡和生产订单只能自己删除自己的单据。pda进站单增加白坯发布字段，放在接收数量后面，不允许编辑，每次扫进站单出站单的时候，自动把白坯发布的汇总数量显示。生产订单模块增加一个字段，是否取库存,底部备注，做成下拉框。生产报表这个字段有值的不计算产能。工艺路线批量插入白坯定型和染厂（第一道和第二道）（把以前所有的流水号加20，在把白坯定型（10），和染厂（20）刷进去
---
DAL/基础资料/公用基础资料/ClsGy_Source_View.cs | 90 ++++++++++++++++++++++++++------------------
1 files changed, 53 insertions(+), 37 deletions(-)
diff --git "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs" "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
index 2e63ab9..9171336 100644
--- "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
+++ "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\254\347\224\250\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_Source_View.cs"
@@ -31,30 +31,30 @@
GC.SuppressFinalize(this);
}
//
-
- //杩斿洖椤圭洰淇℃伅
- //public override bool GetInfoByID(Int64 sItemID)
- //{
- // DataSet DS ;
- // try
- // {
- // DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
- // if (DS.Tables[0].Rows.Count == 0)
- // return false;
- // else
- // {
- // return GetInfo(DS);
- // }
- // }
- // catch (Exception e)
- // {
- // throw (e);
- // }
- //}
-
//杩斿洖椤圭洰淇℃伅
public override bool GetInfoByID(Int64 sItemID)
+ {
+ DataSet DS;
+ try
+ {
+ DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
+ if (DS.Tables[0].Rows.Count == 0)
+ return false;
+ else
+ {
+ return GetInfo(DS);
+ }
+ }
+ catch (Exception e)
+ {
+ throw (e);
+ }
+ }
+
+
+ //杩斿洖椤圭洰淇℃伅 濂ラ偊涓撶敤
+ public bool GetInfoByID_AoBang(Int64 sItemID)
{
DataSet DS;
try
@@ -160,22 +160,19 @@
omodel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
omodel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim();
omodel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim();
-
- //20220331淇敼
- //omodel.HHelpCode = DS.Tables[0].Rows[0]["HHelpCode"].ToString().Trim();
- //omodel.HShortNumber = DS.Tables[0].Rows[0]["HShortNumber"].ToString().Trim();
- //omodel.HParentID = Convert.ToInt64(DS.Tables[0].Rows[0]["HParentID"]);
- //omodel.HLevel = Convert.ToInt64(DS.Tables[0].Rows[0]["HLevel"]);
- //omodel.HEndFlag = (bool)DS.Tables[0].Rows[0]["HEndFlag"];
- //omodel.HStopflag = (bool)DS.Tables[0].Rows[0]["HStopflag"];
- //omodel.HRemark = DS.Tables[0].Rows[0]["HRemark"].ToString().Trim();
- //omodel.HProcID = Convert.ToInt64(DS.Tables[0].Rows[0]["HProcID"]);
- //omodel.HRelationID = Convert.ToInt64(DS.Tables[0].Rows[0]["HRelationID"]);
- //omodel.HCenterID = Convert.ToInt64(DS.Tables[0].Rows[0]["HCenterID"]);
- //omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCodeForBase"].ToString().Trim();
- //omodel.HType = DS.Tables[0].Rows[0]["HType"].ToString().Trim();
- //omodel.HEquipFileID_K3 = Convert.ToInt64(DS.Tables[0].Rows[0]["HEquipFileID_K3"]);
- //淇敼鐨勫湴鏂瑰埌杩欓噷
+ omodel.HHelpCode = DS.Tables[0].Rows[0]["HHelpCode"].ToString().Trim();
+ omodel.HShortNumber = DS.Tables[0].Rows[0]["HShortNumber"].ToString().Trim();
+ omodel.HParentID = Convert.ToInt64(DS.Tables[0].Rows[0]["HParentID"]);
+ omodel.HLevel = Convert.ToInt64(DS.Tables[0].Rows[0]["HLevel"]);
+ omodel.HEndFlag = (bool)DS.Tables[0].Rows[0]["HEndFlag"];
+ omodel.HStopflag = (bool)DS.Tables[0].Rows[0]["HStopflag"];
+ omodel.HRemark = DS.Tables[0].Rows[0]["HRemark"].ToString().Trim();
+ omodel.HProcID = Convert.ToInt64(DS.Tables[0].Rows[0]["HProcID"]);
+ omodel.HRelationID = Convert.ToInt64(DS.Tables[0].Rows[0]["HRelationID"]);
+ omodel.HCenterID = Convert.ToInt64(DS.Tables[0].Rows[0]["HCenterID"]);
+ omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCodeForBase"].ToString().Trim();
+ omodel.HType = DS.Tables[0].Rows[0]["HType"].ToString().Trim();
+ omodel.HEquipFileID_K3 = Convert.ToInt64(DS.Tables[0].Rows[0]["HEquipFileID_K3"]);
//omodel.HGroupK3ID = Convert.ToInt64(DS.Tables[0].Rows[0]["HGroupK3ID"]);
//omodel.HGroupID = Convert.ToInt64(DS.Tables[0].Rows[0]["HGroupID"]);
@@ -195,6 +192,25 @@
}
}
+ //杩斿洖椤圭洰淇℃伅 濂ラ偊涓撶敤
+ public bool GetInfo_AoBang(DataSet DS)
+ {
+ try
+ {
+ omodel = new Model.ClsGy_Source_Model();
+
+ omodel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
+ omodel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim();
+ omodel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim();
+ return true;
+
+ }
+ catch (Exception e)
+ {
+ throw (e);
+ }
+ }
+
/// <summary>
/// 寰楀埌榛樿璧勬簮鏍规嵁閮ㄩ棬
--
Gitblit v1.9.1