From 3bd5db2a574a1280355de503813ba4d5cdca20b5 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 21 四月 2022 16:36:32 +0800
Subject: [PATCH] 齐套分析列表
---
BaseSet/公用资料/其他基础资料/Gy_StdWorkTimes.cs | 187 ++++++++++++++++++++++++++++++----------------
1 files changed, 121 insertions(+), 66 deletions(-)
diff --git "a/BaseSet/\345\205\254\347\224\250\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StdWorkTimes.cs" "b/BaseSet/\345\205\254\347\224\250\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StdWorkTimes.cs"
index e3a5aae..1df1c1a 100644
--- "a/BaseSet/\345\205\254\347\224\250\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StdWorkTimes.cs"
+++ "b/BaseSet/\345\205\254\347\224\250\350\265\204\346\226\231/\345\205\266\344\273\226\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StdWorkTimes.cs"
@@ -46,8 +46,9 @@
public DAL.ClsGy_StdWorkTimes_Ctl BillNew = new DAL.ClsGy_StdWorkTimes_Ctl();
public Model.ClsGy_StdWorkTimes_Model BillOld = new Model.ClsGy_StdWorkTimes_Model();
ClsGridViewSum oSumGrid = new ClsGridViewSum();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
-
+
#region 鍥哄畾浠ｇ爜
//鍚堣
private void Total()
@@ -187,7 +188,10 @@
oSumGrid.ogrdMain = grdMain1;
oSumGrid.oGridsum = grdSum;
lblCaption.Text = ModName;
+ textBox1.Hide();
+ textBox2.Hide();
this.Text = ModName;
+
}
@@ -236,7 +240,44 @@
//淇敼鎸夌航
private void xg_Click(object sender, EventArgs e)
{
- this.Sub_EditBill();
+ try
+ {
+ if (int.Parse(txtHStdWorkTimes.Text)<=0)
+ {
+ MessageBox.Show("鏍囧噯宸ユ椂蹇呴』澶т簬0", "鎻愮ず");
+ }
+ if (int.Parse(txtHUpperlimit.Text) <= 0)
+ {
+ MessageBox.Show("涓婇檺姣斾緥蹇呴』澶т簬0", "鎻愮ず");
+ }
+ if (int.Parse(txtHLowerlimit.Text) <= 0)
+ {
+ MessageBox.Show("涓嬬嚎姣斾緥蹇呴』澶т簬0", "鎻愮ず");
+ }
+ oCn.BeginTran();
+ string sql = string.Format(@"Update Gy_StdWorkTimes set" +
+ " HMaterID=" + textBox1.Text +
+ ",HProcID=" + textBox2.Text +
+ ",HStdWorkTimes=" + txtHStdWorkTimes.Text +
+ ",HUpperlimit=" + txtHUpperlimit.Text +
+ ",HLowerlimit=" + txtHLowerlimit.Text +
+ ",HMaker='" + DBUtility.ClsPub.CurUserName + "'" +
+ ",HMakeDate='" + DateTime.Now + "'" +
+ ",HUSEORGID=" + DBUtility.ClsPub.HOrgID +
+ " where HItemID=" + BillOld.HItemID);
+ oCn.RunProc(sql);
+ oCn.Commit();
+ MessageBox.Show("淇敼鎴愬姛,璇烽��鍑哄苟鍒锋柊", "鎻愮ず");
+ }
+ catch (Exception)
+ {
+ oCn.RollBack();
+ MessageBox.Show("淇敼澶辫触", "鎻愮ず");
+ throw;
+ }
+
+
+
}
//鍒犻櫎鎸夐挳
private void sc_Click(object sender, EventArgs e)
@@ -293,7 +334,7 @@
{
timer1.Enabled = false;
Sub_ControlLocation();
- if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)//|| BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Viewonly
+ if (BillOld.HItemID.ToString()!=null)//|| BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Viewonly
{
this.Sub_ShowBill();
}
@@ -387,60 +428,65 @@
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
//鍒ゆ柇鏄惁瀛樺湪鍗曟嵁
- if (BillNew.ShowBill(BillOld.HItemID, ref ClsPub.sExeReturnInfo) == false)
- {
- MessageBox.Show(ClsPub.sExeReturnInfo, "鎻愮ず");
- return;
- }
+ DataSet DsSub = oCn.RunProcReturn("Select * from h_v_Gy_StdWorkTimesListNew Where HitemID=" + BillOld.HItemID.ToString(), "Gy_StdWorkTimes");
+ DataRow dr = DsSub.Tables[0].Rows[0];
+
//娓呯┖
Sub_ClearBill();
-
+
//
- this.txtHMaker.Text = BillOld.HMaker;
- this.txtHMakeDate.Text = BillOld.HMakeDate;
- this.txtHChecker.Text = BillOld.HChecker;
+ this.textBox1.Text = dr["HMaterID"].ToString();
+ this.txtHMaterID.Text = dr["鐗╂枡浠ｇ爜"].ToString();
+ this.txtHMaterName.Text = dr["鐗╂枡鍚嶇О"].ToString();
+ this.txtHMaterModel.Text = dr["瑙勬牸鍨嬪彿"].ToString();
+ this.textBox2.Text = dr["HProcID"].ToString();
+ this.txtHProcID.Text = dr["宸ュ簭浠ｇ爜"].ToString();
+ this.txtHProcName.Text = dr["宸ュ簭鍚嶇О"].ToString();
+ this.txtHStdWorkTimes.Text = dr["鏍囧噯宸ユ椂"].ToString();
+ this.txtHUpperlimit.Text = dr["涓婄嚎姣斾緥"].ToString();
+ this.txtHLowerlimit.Text = dr["涓嬬嚎姣斾緥"].ToString();
//鍔犺浇琛ㄤ綋
- initGrid();
- int i = 0;
- foreach (Model.ClsGy_StdWorkTimes_Model oSub in BillNew.DetailColl)
- {
- //
- if (i >= grdMain1.RowCount - 1)
- grdMain1.Rows.Add();
- grdMain1.Rows[i].Cells[HTagCol].Value = "*";
- grdMain1.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString();
- if (oMater.GetInfoByID(oSub.HMaterID))
- {
- grdMain1.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
- grdMain1.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
- grdMain1.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
- }
- else
- {
- grdMain1.Rows[i].Cells[HMaterNumberCol].Value = "";
- grdMain1.Rows[i].Cells[HMaterNameCol].Value = "";
- grdMain1.Rows[i].Cells[HMaterModelCol].Value = "";
- }
- grdMain1.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
- if (oProc.GetInfoByID(oSub.HProcID))
- {
- grdMain1.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
- grdMain1.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
- }
- else
- {
- grdMain1.Rows[i].Cells[HProcNumberCol].Value = "";
- grdMain1.Rows[i].Cells[HProcNameCol].Value = "";
- }
-
- grdMain1.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString();
- grdMain1.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString();
- grdMain1.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString();
- grdMain1.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString();
- grdMain1.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark;
- i = i + 1;
- }
+ //initGrid();
+ //int i = 0;
+ //foreach (Model.ClsGy_StdWorkTimes_Model oSub in BillNew.DetailColl)
+ //{
+ // //
+ // if (i >= grdMain1.RowCount - 1)
+ // grdMain1.Rows.Add();
+ // grdMain1.Rows[i].Cells[HTagCol].Value = "*";
+ // grdMain1.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString();
+ // if (oMater.GetInfoByID(oSub.HMaterID))
+ // {
+ // grdMain1.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
+ // grdMain1.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
+ // grdMain1.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
+ // }
+ // else
+ // {
+ // grdMain1.Rows[i].Cells[HMaterNumberCol].Value = "";
+ // grdMain1.Rows[i].Cells[HMaterNameCol].Value = "";
+ // grdMain1.Rows[i].Cells[HMaterModelCol].Value = "";
+ // }
+ // grdMain1.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
+ // if (oProc.GetInfoByID(oSub.HProcID))
+ // {
+ // grdMain1.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
+ // grdMain1.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
+ // }
+ // else
+ // {
+ // grdMain1.Rows[i].Cells[HProcNumberCol].Value = "";
+ // grdMain1.Rows[i].Cells[HProcNameCol].Value = "";
+ // }
+
+ // grdMain1.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString();
+ // grdMain1.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString();
+ // grdMain1.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString();
+ // grdMain1.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString();
+ // grdMain1.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark;
+ // i = i + 1;
+ //}
//GRID鍏佽鍒锋柊
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
//鍚堣
@@ -462,7 +508,7 @@
//}
//鏄庣粏琛ㄦ槸鍚︿负闆惰
- bool b = false;
+
if (!IsNullRow(0))
{
MessageBox.Show("琛ㄤ綋鏄庣粏琛屼笉瀛樺湪锛佽褰曞叆锛�", "鎻愮ず");
@@ -489,7 +535,8 @@
lblCaption.Focus();
//
if (!Sub_AllowSave())//鍗曟嵁瀹屾暣鎬у垽鏂�
- return false;
+ { return false; }
+
//
//鏄庣粏绫昏祴鍊�
BillNew.DetailColl = new List<Model.ClsGy_StdWorkTimes_Model>();
@@ -497,18 +544,26 @@
{
if (DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value) != 0 && DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value) != 0)
{
- Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
- oSub.HMaterID = ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value);
- oSub.HProcID = ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value);
- oSub.HStdWorkTimes = ClsPub.isDoule(grdMain1.Rows[i].Cells[HStdWorkTimes].Value);
- oSub.HUpperlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HUpperlimit].Value);
- oSub.HLowerlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HLowerlimit].Value);
- oSub.HUSEORGID = ClsPub.HOrgID;
- oSub.HStopflag = false;
- oSub.HMaker = ClsPub.CurUserName;
- oSub.HMakeDate = DateTime.Today.ToString();
- oSub.HRemark = ClsPub.isStrNull(grdMain1.Rows[i].Cells[HRemarkCol].Value);
- BillNew.DetailColl.Add(oSub);
+ if (DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HStdWorkTimes].Value)>0&& DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HUpperlimit].Value) > 0&& DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HLowerlimit].Value) > 0)
+ {
+ Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
+ oSub.HMaterID = ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value);
+ oSub.HProcID = ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value);
+ oSub.HStdWorkTimes = ClsPub.isDoule(grdMain1.Rows[i].Cells[HStdWorkTimes].Value);
+ oSub.HUpperlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HUpperlimit].Value);
+ oSub.HLowerlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HLowerlimit].Value);
+ oSub.HUSEORGID = ClsPub.HOrgID;
+ oSub.HStopflag = false;
+ oSub.HMaker = ClsPub.CurUserName;
+ oSub.HMakeDate = DateTime.Today.ToString();
+ oSub.HRemark = ClsPub.isStrNull(grdMain1.Rows[i].Cells[HRemarkCol].Value);
+ BillNew.DetailColl.Add(oSub);
+ }
+ else
+ {
+ MessageBox.Show("绗�" + (i+1) + "琛�,鏍囧噯宸ユ椂,涓婇檺姣斾緥鍜屼笅闄愭瘮渚嬮兘搴斿ぇ浜�0", "鎻愮ず");
+ return false;
+ }
}
}
//淇濆瓨瀹屾瘯鍚庡鐞�
--
Gitblit v1.9.1