From 0fd7f552d345c2988ad704dbfeace766428ab47b Mon Sep 17 00:00:00 2001
From: 杨乐 <yang.le.192@qq.com>
Date: 星期二, 28 十二月 2021 14:38:41 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
WebAPI/Controllers/工资管理/Gy_ClassTimePrjSubController.cs | 37 ++++++-
WarM/条码打印/Sc_ICMOToBarCode.cs | 157 +++++++++++++++++++++---------
WarM/条码打印/Sc_ICMOToBarCode.designer.cs | 85 +++++++++++-----
WebAPI/Controllers/SellOutController.cs | 1
WebAPI/Controllers/MoveStockBillController.cs | 9 +
WebAPI/WebServer.cs | 5 +
6 files changed, 211 insertions(+), 83 deletions(-)
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
index 657158f..29ed5b8 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
@@ -57,6 +57,9 @@
//}
string HICMOBillNo = "";
HICMOBillNo = txtHICMOBillNo.Text.Trim().ToString();
+ //閿�鍞鍗曞彿
+ string HSeOrderBillNo = "";
+ HICMOBillNo = txtHSeOrderBillNo.Text.Trim().ToString();
//鐗╂枡
//if (txtHMaterID.Text.Trim() != "")
//{
@@ -98,7 +101,7 @@
//杩囨护鏉′欢
//
- DSet = SubCn.RunProcReturn("exec h_p_KSTMSC '" + HICMOBillNo + "' , '" + HMaterName + "' , '" + HSourceName + "' ,'" + HEmpName + "' ,'" + HBeginDate + "', '" + HEndDate + "'", "h_p_KSTMSC", ref DBUtility.ClsPub.sExeReturnInfo);
+ DSet = SubCn.RunProcReturn("exec h_p_KSTMSC '" + HSeOrderBillNo + "' ,'" + HICMOBillNo + "' , '" + HMaterName + "' , '" + HSourceName + "' ,'" + HEmpName + "' ,'" + HBeginDate + "', '" + HEndDate + "'", "h_p_KSTMSC", ref DBUtility.ClsPub.sExeReturnInfo);
//鐢熸垚棣栬鏍囬
if (DSet == null)
{
@@ -757,6 +760,97 @@
private void button4_Click(object sender, EventArgs e)
{
+ //1.鑾峰彇鐣岄潰涓婇潰鏁寸鏁伴噺妗嗚緭鍏ョ殑鏁伴噺 璧嬪�肩粰鍙橀噺 骞跺埛鏂扮綉鏍�
+ double HBarCodeQty = 0;
+ double HZXQty = 0;
+ HZXQty = ClsPub.isDoule(txtHZXQty.Text);
+ if (HZXQty ==0)
+ {
+ MessageBox.Show("璇疯緭鍏ユ暣绠辨暟閲忥紒");
+ return;
+ }
+ Display();
+ //2.鑾峰彇缃戞牸閫変腑琛岀墿鏂橧D
+ int a = grdMain.CurrentRow.Index;
+ long HMaterID = 0;
+ HMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[a].Cells[Fun_GetCol("HMaterID")].Value);
+ if (HMaterID == 0)
+ {
+ MessageBox.Show("娌℃湁閫変腑浠讳綍璁板綍锛�");
+ return;
+ }
+ //3.瀹氫箟鏄惁缁勬墭鐨勫彉閲�
+ int Mul = 0;
+ //4.鏍规嵁鍗曟嵁绫诲瀷鑾峰彇鏈鏉$爜涓诲唴鐮丠InterID
+ HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
+ //5.浠庣綉鏍肩涓�琛屽惊鐜嚦鏈�鍚庝竴琛� 鍒ゆ柇I琛岀殑鐗╂枡鍐呯爜涓嶮鏄惁涓�鑷达紱濡傛灉涓嶄竴鑷村垯寰幆涓嬩竴琛岋紱
+ for (int i = 0; i < grdMain.Rows.Count; i++)
+ {
+ long HGrdMaterID = 0;
+ HGrdMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("HMaterID")].Value);
+ if (HMaterID == HGrdMaterID)
+ {
+ double HDDQty = 0;
+ HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
+ if (HDDQty >= HZXQty)
+ {
+ HBarCodeQty = HZXQty;
+ this.Sub_SaveBill();
+ Display();
+ Mul = Mul + 1;
+ break;
+ }
+ else if(HDDQty < HZXQty)
+ {
+ HBarCodeQty = HDDQty;
+ HZXQty = HZXQty - HDDQty;
+ this.Sub_SaveBill();
+ Mul = Mul + 1;
+ }
+ }
+ }
+
+
+ //3.鍏堝垽鏂墿鏂欐槸鍚︿竴鑷� 濡傛灉涓�鑷村紑濮嬪惊鐜綉鏍�
+ for (int i = 0; i < grdMain.Rows.Count; i++)
+ {
+ //long HGrdMaterID = 0;
+ //HGrdMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("HMaterID")].Value);
+ //if (HGrdMaterID == HMaterID)
+ //{
+ // double HDDQty = 0;
+ // HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
+ // //濡傛灉寰幆鐨勮琛岃褰曠殑璁㈠崟鏁伴噺宸茬粡澶т簬绛変簬鏈瑁呯鏁伴噺 鍒欑洿鎺ョ敓鎴愬敮涓�鐮� 骞朵笖鍒锋柊缃戞牸 鍒锋柊鏉$爜淇℃伅椤�
+ // if (HDDQty >= HZXQty)
+ // {
+ // double HBarCodeQty = 0;
+ // HBarCodeQty = HZXQty;
+ // this.Sub_SaveBill();
+ // Display();
+ // }
+ // //濡傛灉鏀硅璁板綍璁㈠崟鏁伴噺灏忎簬鏈瑁呯鏁伴噺 鍒欑户缁惊鐜� 璧扮敓鎴愭墭鏉$爜鏂规硶
+ // else
+ // {
+ // //鏌ュ嚭绗﹀悎鏉′欢鐨勯�変腑杩欐潯鏁伴噺璺熻绠辨暟閲忕殑宸紓鍊�
+ // double HCYQty = 0;
+ // HCYQty = HZXQty - DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
+
+ // }
+
+ //}
+ //else
+ //{
+
+ //}
+ }
+
+
+
+
+ }
+
+ private void Sub_SaveBill()
+ {
HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
string HMaterNumber = "";
string HBatchNo = "";
@@ -769,8 +863,8 @@
DataSet Ds;
int LSH = 0; //娴佹按鍙�
string LSH2 = ""; //娴佹按鍙疯浆鎹㈡垚瀛楃
- double HSumQty = 0; //浜у搧鏁伴噺
- double HMinQty = 0; //鏈�灏忓寘瑁呮暟
+ double HZXQty = 0; //瑁呯鏁伴噺
+ double HDDQty = 0; //璁㈠崟鏁伴噺
double HBQty = 0; //绠辨暟
int k = 0;
int n = 0; //鍚屼竴鎵圭敓鎴愭潯鐮佷腑鐨勭鍑犳潯
@@ -788,23 +882,11 @@
HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
HDay = HDay.Substring(HDay.Length - 2, 2);
HOrgNumber = ClsPub.HOrgNumber;
- //绠辨暟鍒�=鏁伴噺/鏈�灏忓寘瑁呮暟
- //double sMoney = 0;
- //if ((DBUtility.ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value) == 0))
- //{
- // sMoney = 0;
- //}
- //else
- //{
- // sMoney = ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HQty")].Value) / ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value);
- //}
- //sMoney = Math.Ceiling(sMoney);
- //grdMain.SelectedRows[j].Cells[Fun_GetCol("HBQty")].Value = sMoney;
- HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
- HMinQty = ClsPub.isDoule(txtHMiniQty.Text);
- HSumQty = ClsPub.isDoule(txtHICMOQty.Text);
+ //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
+ HZXQty = ClsPub.isDoule(txtHZXQty.Text);
+ HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.SelectedRows[j].Index].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
if (cmbHBarCodeType.Text == "鍞竴鏉$爜")
@@ -818,27 +900,7 @@
TM = HOrgNumber + HMaterNumber + HBatchNo;
}
n = 0;
- for (int i = k; i < HBQty; i++)
- {
- if (HSumQty - HMinQty > 0)
- {
- WeiShu = "";
- HSumQty = HSumQty - HMinQty;
- }
- else
- {
- if (HSumQty == HMinQty)
- {
- WeiShu = "";
- }
- else
- {
- WeiShu = "灏炬暟";
- }
- HMinQty = HSumQty;
- }
- //
- LSH = LSH + 1;
+
LSH2 = LSH.ToString();
while (LSH2.Length < LSHlen) //濡傛灉娴佹按鍙峰皬浜�6浣嶆暟鍓嶉潰琛�0
{
@@ -857,7 +919,7 @@
string HWei = ""; //灏炬暟
string HBarCode = "";
string HBarCodeType = "";
- Int64 HMaterID = 0;
+ Int64 HMaterID1 = 0;
Int64 HAuxPropID = 0;
Int64 HUnitID = 0;
double HQty2 = 0;
@@ -891,10 +953,10 @@
HWei = WeiShu;
HBarCode = TM;
HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
- HMaterID = ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMaterID")].Value);
+ HMaterID1 = ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMaterID")].Value);
HAuxPropID = 0;
HUnitID = 0;
- HQty2 = HMinQty;
+ HQty2 = HZXQty;
HBatchNo2 = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("鎵规")].Value);
HSourceInterID = 0;
HSourceEntryID = 0;
@@ -925,7 +987,7 @@
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID " +
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +
") values ("
- + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
+ + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID1.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
+ ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
+ ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'"
+ ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'"
@@ -943,10 +1005,9 @@
oCn.RollBack();
MessageBox.Show("鏉$爜鐢熸垚澶辫触锛�" + e1.Message);
}
-
- }
}
}
+
private void DisplayTM()
@@ -1197,9 +1258,9 @@
for (int i = 0; i < grdMain.SelectedRows.Count; i++)
{
- txtHICMOQty.Text = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
+ txtHZXQty.Text = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
}
- HICMOQty = DBUtility.ClsPub.isDoule(txtHICMOQty.Text.Trim());
+ HICMOQty = DBUtility.ClsPub.isDoule(txtHZXQty.Text.Trim());
HMiniQty = DBUtility.ClsPub.isDoule(txtHMiniQty.Text.Trim());
if (HMiniQty == 0)
{
@@ -1293,7 +1354,7 @@
txtHEmpID.Text = "";
txtHICMOBillNo.Text = "";
txtHICMOBillNo1.Text = "";
- txtHICMOQty.Text = "";
+ txtHZXQty.Text = "";
txtHMaterID.Text = "";
txtHMaterID1.Text = "";
txtHMiniQty.Text = "";
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.designer.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.designer.cs"
index 2d48dc9..8001f74 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.designer.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.designer.cs"
@@ -81,12 +81,14 @@
this.cmdHMaterID1 = new System.Windows.Forms.Button();
this.grdSub = new System.Windows.Forms.DataGridView();
this.button1 = new System.Windows.Forms.Button();
- this.璁㈠崟鏁伴噺 = new System.Windows.Forms.Label();
- this.txtHICMOQty = new System.Windows.Forms.TextBox();
+ this.鏁寸鏁伴噺 = new System.Windows.Forms.Label();
+ this.txtHZXQty = new System.Windows.Forms.TextBox();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.grdList = new System.Windows.Forms.DataGridView();
+ this.txtHSeOrderBillNo = new System.Windows.Forms.TextBox();
+ this.label9 = new System.Windows.Forms.Label();
this.Tool.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
this.gbUp.SuspendLayout();
@@ -342,6 +344,8 @@
// gbUp
//
this.gbUp.BackColor = System.Drawing.Color.Transparent;
+ this.gbUp.Controls.Add(this.txtHSeOrderBillNo);
+ this.gbUp.Controls.Add(this.label9);
this.gbUp.Controls.Add(this.cmbHBarCodeType);
this.gbUp.Controls.Add(this.label8);
this.gbUp.Controls.Add(this.cmdHSaveBill);
@@ -373,7 +377,7 @@
this.cmbHBarCodeType.Items.AddRange(new object[] {
"鍞竴鏉$爜",
"鎵规鏉$爜"});
- this.cmbHBarCodeType.Location = new System.Drawing.Point(826, 75);
+ this.cmbHBarCodeType.Location = new System.Drawing.Point(871, 77);
this.cmbHBarCodeType.Margin = new System.Windows.Forms.Padding(2);
this.cmbHBarCodeType.Name = "cmbHBarCodeType";
this.cmbHBarCodeType.Size = new System.Drawing.Size(140, 28);
@@ -384,7 +388,7 @@
this.label8.AutoSize = true;
this.label8.Font = new System.Drawing.Font("瀹嬩綋", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label8.ForeColor = System.Drawing.Color.Black;
- this.label8.Location = new System.Drawing.Point(748, 82);
+ this.label8.Location = new System.Drawing.Point(793, 84);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 16);
this.label8.TabIndex = 138;
@@ -394,7 +398,7 @@
//
this.cmdHSaveBill.BackColor = System.Drawing.Color.White;
this.cmdHSaveBill.Font = new System.Drawing.Font("瀹嬩綋", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
- this.cmdHSaveBill.Location = new System.Drawing.Point(1010, 66);
+ this.cmdHSaveBill.Location = new System.Drawing.Point(1026, 66);
this.cmdHSaveBill.Margin = new System.Windows.Forms.Padding(2);
this.cmdHSaveBill.Name = "cmdHSaveBill";
this.cmdHSaveBill.Size = new System.Drawing.Size(112, 50);
@@ -407,10 +411,10 @@
//
this.dtpHEndDate.Font = new System.Drawing.Font("瀹嬩綋", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.dtpHEndDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
- this.dtpHEndDate.Location = new System.Drawing.Point(478, 75);
+ this.dtpHEndDate.Location = new System.Drawing.Point(602, 76);
this.dtpHEndDate.Margin = new System.Windows.Forms.Padding(2);
this.dtpHEndDate.Name = "dtpHEndDate";
- this.dtpHEndDate.Size = new System.Drawing.Size(213, 30);
+ this.dtpHEndDate.Size = new System.Drawing.Size(154, 30);
this.dtpHEndDate.TabIndex = 102;
//
// label5
@@ -418,7 +422,7 @@
this.label5.AutoSize = true;
this.label5.Font = new System.Drawing.Font("瀹嬩綋", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label5.ForeColor = System.Drawing.Color.Black;
- this.label5.Location = new System.Drawing.Point(399, 83);
+ this.label5.Location = new System.Drawing.Point(523, 84);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 16);
this.label5.TabIndex = 101;
@@ -428,10 +432,10 @@
//
this.dtpHBeginDate.Font = new System.Drawing.Font("瀹嬩綋", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.dtpHBeginDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
- this.dtpHBeginDate.Location = new System.Drawing.Point(112, 77);
+ this.dtpHBeginDate.Location = new System.Drawing.Point(336, 77);
this.dtpHBeginDate.Margin = new System.Windows.Forms.Padding(2);
this.dtpHBeginDate.Name = "dtpHBeginDate";
- this.dtpHBeginDate.Size = new System.Drawing.Size(213, 30);
+ this.dtpHBeginDate.Size = new System.Drawing.Size(154, 30);
this.dtpHBeginDate.TabIndex = 100;
//
// label6
@@ -439,7 +443,7 @@
this.label6.AutoSize = true;
this.label6.Font = new System.Drawing.Font("瀹嬩綋", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label6.ForeColor = System.Drawing.Color.Black;
- this.label6.Location = new System.Drawing.Point(33, 85);
+ this.label6.Location = new System.Drawing.Point(257, 85);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(72, 16);
this.label6.TabIndex = 99;
@@ -674,23 +678,23 @@
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
- // 璁㈠崟鏁伴噺
+ // 鏁寸鏁伴噺
//
- this.璁㈠崟鏁伴噺.AutoSize = true;
- this.璁㈠崟鏁伴噺.Font = new System.Drawing.Font("瀹嬩綋", 20F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
- this.璁㈠崟鏁伴噺.Location = new System.Drawing.Point(900, 190);
- this.璁㈠崟鏁伴噺.Name = "璁㈠崟鏁伴噺";
- this.璁㈠崟鏁伴噺.Size = new System.Drawing.Size(120, 27);
- this.璁㈠崟鏁伴噺.TabIndex = 148;
- this.璁㈠崟鏁伴噺.Text = "璁㈠崟鏁伴噺";
+ this.鏁寸鏁伴噺.AutoSize = true;
+ this.鏁寸鏁伴噺.Font = new System.Drawing.Font("瀹嬩綋", 20F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
+ this.鏁寸鏁伴噺.Location = new System.Drawing.Point(900, 190);
+ this.鏁寸鏁伴噺.Name = "鏁寸鏁伴噺";
+ this.鏁寸鏁伴噺.Size = new System.Drawing.Size(120, 27);
+ this.鏁寸鏁伴噺.TabIndex = 148;
+ this.鏁寸鏁伴噺.Text = "鏁寸鏁伴噺";
//
- // txtHICMOQty
+ // txtHZXQty
//
- this.txtHICMOQty.Location = new System.Drawing.Point(900, 221);
- this.txtHICMOQty.Multiline = true;
- this.txtHICMOQty.Name = "txtHICMOQty";
- this.txtHICMOQty.Size = new System.Drawing.Size(112, 42);
- this.txtHICMOQty.TabIndex = 147;
+ this.txtHZXQty.Location = new System.Drawing.Point(900, 221);
+ this.txtHZXQty.Multiline = true;
+ this.txtHZXQty.Name = "txtHZXQty";
+ this.txtHZXQty.Size = new System.Drawing.Size(112, 42);
+ this.txtHZXQty.TabIndex = 147;
//
// tabControl1
//
@@ -738,6 +742,27 @@
this.grdList.Size = new System.Drawing.Size(866, 269);
this.grdList.TabIndex = 20;
//
+ // txtHSeOrderBillNo
+ //
+ this.txtHSeOrderBillNo.Font = new System.Drawing.Font("瀹嬩綋", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
+ this.txtHSeOrderBillNo.ImeMode = System.Windows.Forms.ImeMode.NoControl;
+ this.txtHSeOrderBillNo.Location = new System.Drawing.Point(112, 79);
+ this.txtHSeOrderBillNo.Name = "txtHSeOrderBillNo";
+ this.txtHSeOrderBillNo.ReadOnly = true;
+ this.txtHSeOrderBillNo.Size = new System.Drawing.Size(123, 30);
+ this.txtHSeOrderBillNo.TabIndex = 141;
+ //
+ // label9
+ //
+ this.label9.AutoSize = true;
+ this.label9.Font = new System.Drawing.Font("瀹嬩綋", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
+ this.label9.ForeColor = System.Drawing.Color.Black;
+ this.label9.Location = new System.Drawing.Point(19, 85);
+ this.label9.Name = "label9";
+ this.label9.Size = new System.Drawing.Size(88, 16);
+ this.label9.TabIndex = 140;
+ this.label9.Text = "閿�鍞鍗曞彿";
+ //
// Sc_ICMOToBarCode
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
@@ -745,8 +770,8 @@
this.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.ClientSize = new System.Drawing.Size(1172, 869);
this.Controls.Add(this.tabControl1);
- this.Controls.Add(this.璁㈠崟鏁伴噺);
- this.Controls.Add(this.txtHICMOQty);
+ this.Controls.Add(this.鏁寸鏁伴噺);
+ this.Controls.Add(this.txtHZXQty);
this.Controls.Add(this.button1);
this.Controls.Add(this.grdSub);
this.Controls.Add(this.groupBox1);
@@ -831,12 +856,14 @@
private System.Windows.Forms.Button cmdHMaterID1;
private System.Windows.Forms.DataGridView grdSub;
private System.Windows.Forms.Button button1;
- private System.Windows.Forms.Label 璁㈠崟鏁伴噺;
- private System.Windows.Forms.TextBox txtHICMOQty;
+ private System.Windows.Forms.Label 鏁寸鏁伴噺;
+ private System.Windows.Forms.TextBox txtHZXQty;
private System.Windows.Forms.TabControl tabControl1;
private System.Windows.Forms.TabPage tabPage1;
private System.Windows.Forms.TabPage tabPage2;
private System.Windows.Forms.DataGridView grdList;
private System.Windows.Forms.ToolStripButton cz;
+ private System.Windows.Forms.TextBox txtHSeOrderBillNo;
+ private System.Windows.Forms.Label label9;
}
}
\ No newline at end of file
diff --git a/WebAPI/Controllers/MoveStockBillController.cs b/WebAPI/Controllers/MoveStockBillController.cs
index dae3db8..dea99db 100644
--- a/WebAPI/Controllers/MoveStockBillController.cs
+++ b/WebAPI/Controllers/MoveStockBillController.cs
@@ -605,7 +605,14 @@
// DataSet ds = new DataSet();
// WebServer webserver = new WebServer();
string sWhere = " Where 鍗曟嵁鍙� like '%" + HSourceBillNo.Trim() + "%'";
- ds = webserver.GetSc_PPBomBillList(sWhere);
+ if (HSourceBillType == "3720")
+ {
+ ds = webserver.GetSc_PPBomBillList(sWhere);
+ }
+ else if (HSourceBillType == "1243")
+ {
+ ds = webserver.GetKf_MoveStockRequestBillList(sWhere);
+ }
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
diff --git a/WebAPI/Controllers/SellOutController.cs b/WebAPI/Controllers/SellOutController.cs
index 3e0e9a6..93914fa 100644
--- a/WebAPI/Controllers/SellOutController.cs
+++ b/WebAPI/Controllers/SellOutController.cs
@@ -535,6 +535,7 @@
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = lsmain[0].HRemark;
websLsmain.HMaker = lsmain[0].HMaker;
+ websLsmain.HKeeperID= lsmain[0].HKeeperID;
if (webserver.set_SaveSellOutBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
{
diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs"
index c3d376f..f7ec5a2 100644
--- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs"
+++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs"
@@ -142,7 +142,7 @@
string HNumber = list[0].HNumber;
string HName = list[0].HName;
string HMaker = list[0].HMaker;
-
+
//淇濆瓨
//淇濆瓨瀹屾瘯鍚庡鐞�
if (HInterID == 0)
@@ -158,7 +158,8 @@
//淇敼涓婄骇涓洪潪鏈骇浠g爜
oCN.Commit();
}
- else {
+ else
+ {
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
//涓昏〃
@@ -205,7 +206,7 @@
DataSet ds1;
try
{
-
+
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (string.IsNullOrWhiteSpace(HItemID))
{
@@ -236,8 +237,34 @@
}
+ /// <summary>
+ /// 淇濆瓨鎸夐挳
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_ClassTimePrjSub/ModifyByID")]
+ [HttpPost]
+ public object Calc(string HEntryID, string HYear, string HPeriod)
+ {
+ try
+ {
+ oCN.RunProcReturn("exec h_p_Pay_GetAvgMoney " + HYear.ToString() + "," + HPeriod.ToString() + "," + HEntryID.ToString(), "pjgz");
-
-
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "淇濆瓨鎴愬姛锛�";
+ objJsonResult.data = 1;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.Message;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
}
}
\ No newline at end of file
diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs
index 3785002..196ef0d 100644
--- a/WebAPI/WebServer.cs
+++ b/WebAPI/WebServer.cs
@@ -1994,6 +1994,11 @@
DAL.Cls_S_IF_ProductInBill_Lite dal = new DAL.Cls_S_IF_ProductInBill_Lite();
return dal.DisSourceBillList(sWhere);
}
+ public DataSet GetKf_MoveStockRequestBillList(string sWhere)
+ {
+ DAL.Cls_S_IF_MoveStockRequestBill_Lite dal = new DAL.Cls_S_IF_MoveStockRequestBill_Lite();
+ return dal.DisSourceBillList(sWhere);
+ }
#endregion
#region 鍏朵粬鍏ュ簱锛堢孩瀛楋級 *
--
Gitblit v1.9.1