From 5f984a9b0e665ba9a9325da738220121a58e8d76 Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期四, 07 八月 2025 11:20:26 +0800
Subject: [PATCH] 业务类
---
DAL/基础资料/其他基础资料/ClsGy_MatePrice_Ctl.cs | 79 +++++++++++++++++++--------------------
1 files changed, 39 insertions(+), 40 deletions(-)
diff --git "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_MatePrice_Ctl.cs" "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_MatePrice_Ctl.cs"
index 931adda..719e510 100644
--- "a/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_MatePrice_Ctl.cs"
+++ "b/DAL/\345\237\272\347\241\200\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_MatePrice_Ctl.cs"
@@ -20,7 +20,7 @@
{
try
{
- oCn.RunProc(" Update Gy_MatePriceSup set HChecker='',HCheckDate=null Where HItemID=" + lngBillKey.ToString());
+ oCn.RunProc(" Update Gy_MatePrice set HCheckEmp='',HCheckTime=null Where HItemID=" + lngBillKey.ToString());
sReturn = "";
return true;
}
@@ -113,45 +113,44 @@
}
//鏄剧ず鍗曟嵁
- //public bool ShowBill(Int64 lngBillKey, ref string sReturn)
- //{
- // try
- // {
- // //鏌ヨ涓昏〃
- // DataSet DsSub = new DataSet();
- // DsSub = oCn.RunProcReturn("Select * from Gy_MatePriceSup Where HitemID=" + lngBillKey.ToString(), "Gy_MatePriceSup");
- // DetailColl.Clear();//娓呯┖
- // for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
- // {
- // Model.ClsGy_MatePriceSup_Model oSub = new Model.ClsGy_MatePriceSup_Model();
- // oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"].ToString());
- // oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"].ToString());
- // oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"].ToString());
- // oSub.HRelationID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HRelationID"].ToString());
- // oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim();
- // oSub.HBeginQty = DBUtility.ClsPub.isSingle(DsSub.Tables[0].Rows[i]["HBeginQty"].ToString());
- // oSub.HEndQty = DBUtility.ClsPub.isSingle(DsSub.Tables[0].Rows[i]["HEndQty"].ToString());
- // oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"].ToString());
- // oSub.HPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HPrice"].ToString());
- // oSub.HCurID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HCurID"].ToString());
- // oSub.HType = DsSub.Tables[0].Rows[i]["HType"].ToString();
- // oSub.HMaker = DsSub.Tables[0].Rows[i]["HMaker"].ToString();
- // oSub.HMakeDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HMakeDate"]);
- // oSub.HBeginDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HBeginDate"]);
- // oSub.HEndDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEndDate"]);
- // oSub.HChecker = DsSub.Tables[0].Rows[i]["HChecker"].ToString().Trim();
- // oSub.HCheckDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HCheckDate"]);
- // DetailColl.Add(oSub);
- // }
- // sReturn = "鏄剧ず鍗曟嵁鎴愬姛锛�";
- // return true;
- // }
- // catch (Exception e)
- // {
- // sReturn = e.Message;
- // return false;
- // }
- //}
+ public bool ShowBill(Int64 lngBillKey, ref string sReturn)
+ {
+ try
+ {
+ //鏌ヨ涓昏〃
+ DataSet DsSub = new DataSet();
+ DsSub = oCn.RunProcReturn("Select * from Gy_MaterPrice Where HitemID=" + lngBillKey.ToString(), "Gy_MaterPrice");
+ DetailColl.Clear();//娓呯┖
+ for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
+ {
+ Model.ClsGy_MatePrice_Model oSub = new Model.ClsGy_MatePrice_Model();
+ oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"].ToString());
+ oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim();
+ oSub.HWHID = DBUtility.ClsPub.isInt(DsSub.Tables[0].Rows[i]["HWHID"].ToString());
+ oSub.HSupID = DBUtility.ClsPub.isInt(DsSub.Tables[0].Rows[i]["HSupID"].ToString());
+ oSub.HPrice = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPrice"].ToString());
+ oSub.HCusID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HCusID"].ToString());
+ oSub.HStopflag = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HStopflag"].ToString());
+ oSub.HUseFlag = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HUseFlag"].ToString());
+ oSub.HMakeEmp = DsSub.Tables[0].Rows[i]["HMakeEmp"].ToString();
+ oSub.HCheckEmp = DsSub.Tables[0].Rows[i]["HCheckEmp"].ToString();
+ oSub.HStopEmp = DsSub.Tables[0].Rows[i]["HStopEmp"].ToString();
+ oSub.HModifyEmp = DsSub.Tables[0].Rows[i]["HModifyEmp"].ToString();
+ oSub.HMakeTime = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMakeTime"].ToString());
+ oSub.HCheckTime = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCheckTime"].ToString());
+ oSub.HModifyTime = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HModifyTime"].ToString());
+ oSub.HStopTime = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HStopTime"].ToString());
+ DetailColl.Add(oSub);
+ }
+ sReturn = "鏄剧ず鍗曟嵁鎴愬姛锛�";
+ return true;
+ }
+ catch (Exception e)
+ {
+ sReturn = e.Message;
+ return false;
+ }
+ }
//鎵规敼鍗曟嵁
public bool BatchModifyBill(Int64 lngBillKey, double sPrice, ref string sReturn)
--
Gitblit v1.9.1