Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | string subSql = "Insert into Xs_SeOrderBillSub" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationQty_SellOutCheck,HRelationMoney_SellOutCheck,HRelationQty_ICMO,HRelationQty_SellBack,HRelationQty_SellBackCheck,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" + |
| | | ",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods,HWHID) " + |
| | | ",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods,HWHID,HRemark_TL,HRemark_SJG) " + |
| | | "values(" + |
| | | "" + omodel.HInterID + |
| | | "," + oSub.HEntryID + |
| | |
| | | "','" + oSub.HCusModel + |
| | | "','" + oSub.HCusMaterName + |
| | | "'," + (oSub.HisStockGoods?1:0) + |
| | | ",'" + oSub.HWhID + |
| | | "')"; |
| | | ",'" + oSub.HWhID + "'" + |
| | | ",'" + oSub.HRemark_TL + "'" + |
| | | ",'" + oSub.HRemark_SJG + "'" + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | |
| | | string subSql = "Insert into Xs_SeOrderBillSub" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationQty_SellOutCheck,HRelationMoney_SellOutCheck,HRelationQty_ICMO,HRelationQty_SellBack,HRelationQty_SellBackCheck,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" + |
| | | ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" + |
| | | ",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods,HWHID) " + |
| | | ",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods,HWHID,HRemark_TL,HRemark_SJG) " + |
| | | "values(" + |
| | | "" + omodel.HInterID + |
| | | "," + oSub.HEntryID + |
| | |
| | | "','" + oSub.HCusModel + |
| | | "','" + oSub.HCusMaterName + |
| | | "'," + (oSub.HisStockGoods?1:0) + |
| | | ",'" + oSub.HWhID + |
| | | "')"; |
| | | ",'" + oSub.HWhID + "'" + |
| | | ",'" + oSub.HRemark_TL + "'" + |
| | | ",'" + oSub.HRemark_SJG + "'" + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | |
| | | oSub.HInvoiceQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HInvoiceQty"]); |
| | | oSub.HisStockGoods = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HisStockGoods"]) == 1 ? true : false; |
| | | |
| | | oSub.HRemark_TL = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[0]["HRemark_TL"]); |
| | | oSub.HRemark_SJG = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[0]["HRemark_SJG"]); |
| | | |
| | | DetailColl.Add(oSub); |
| | | } |
| | | sReturn = "æ¾ç¤ºåæ®æåï¼"; |
| | |
| | | public double HRelationQty_ICMO; |
| | | public double HRelationQty_SellBack; |
| | | public double HRelationQty_SellBackCheck; |
| | | |
| | | public string HRemark_TL; //ææ |
| | | public string HRemark_SJG; //æ·±å å·¥ |
| | | } |
| | | } |
| | |
| | | HBatchNo2 = getBatchNo(); |
| | | } |
| | | |
| | | HBarCode = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterModel2Col].Value) + getHBarCode_MaxNo(); |
| | | |
| | | long HSourceID = 0; |
| | | string sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "' "; |
| | | DataSet ds = oCn.RunProcReturn(sql, "Gy_Source"); |
| | |
| | | string LIU = ""; |
| | | int LEN = 4; |
| | | DataSet ds; |
| | | string sql = "select * from h_v_IF_BarCodeBillList Where æºååå· ='" + grdMain.Rows[0].Cells[HSourceBillNoCol].Value + "' and HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),æ¡ç æ¥æ, 23) = '" + HDate + "' order by æ¹å· desc"; |
| | | string sql = "select * from h_v_IF_BarCodeBillList Where HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),æ¡ç æ¥æ, 23) = '" + HDate + "' order by æ¹å· desc"; |
| | | ds = oCn.RunProcReturn(sql, "h_v_IF_BarCodeBillList"); |
| | | if (ds != null) |
| | | { |
| | |
| | | |
| | | return HBatchNo; |
| | | } |
| | | |
| | | //çæå½å¤©äº§åæ¡ç çæµæ°´å· |
| | | private string getHBarCode_MaxNo() |
| | | { |
| | | string HBarCode_MaxNo = ""; |
| | | |
| | | //æ¥æè·åæ¹å¼ |
| | | string sDate = dtpHDate.Value.ToShortDateString(); // |
| | | string sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | string sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | string sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | |
| | | string HDate = "20" + sYear + "-" + sPeriod + "-" + sDay; |
| | | |
| | | //è·åæµæ°´å·ï¼åä½ï¼è¯¥ç©æå½å¤©çæçæ¡ç æ° |
| | | string LIU = ""; |
| | | int LEN = 4; |
| | | |
| | | //è·åäº§åæ¡ç å¤ä»½è¡¨ä¸å½æ¥æ¬äº§åæ¡ç ç¼å·æå¤§çè®°å½ |
| | | long HMaxNo_Bak = 0; //è®°å½äº§åæ¡ç å¤ä»½è¡¨ä¸å½æ¥æ¬äº§åæ¡ç ç¼å·æå¤§çè®°å½çæ¡ç ç¼å·çæµæ°´å· |
| | | DataSet ds1; |
| | | string sql1 = "select * from Gy_BarCodeBill_SWELL_SubBarCodeBill Where HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),HBarCodeDate, 23) = '" + HDate + "' and HInterID <>0 order by HBarCode desc"; |
| | | ds1 = oCn.RunProcReturn(sql1, "Gy_BarCodeBill_SWELL_SubBarCodeBill"); |
| | | if (ds1 != null && ds1.Tables[0].Rows.Count>0) |
| | | { |
| | | string HBarCodeMaxNo = ds1.Tables[0].Rows[0]["HBarCode"].ToString(); |
| | | HBarCodeMaxNo = HBarCodeMaxNo.Substring(HBarCodeMaxNo.Length - LEN, LEN); |
| | | HMaxNo_Bak = ClsPub.isLong(HBarCodeMaxNo); |
| | | } |
| | | |
| | | ////è·åæ¡ç æ¡£æ¡ä¸å½æ¥æ¬äº§åæ¡ç ç¼å·æå¤§çè®°å½ |
| | | long HMaxNo = 0; //è®°å½æ¡ç æ¡£æ¡ä¸å½æ¥æ¬äº§åæ¡ç ç¼å·æå¤§çè®°å½çæ¡ç ç¼å·çæµæ°´å· |
| | | DataSet ds; |
| | | string sql = "select * from h_v_IF_BarCodeBillList Where HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),æ¡ç æ¥æ, 23) = '" + HDate + "' and HInterID <> 0 order by æ¡ç ç¼å· desc"; |
| | | ds = oCn.RunProcReturn(sql, "h_v_IF_BarCodeBillList"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBarCodeMaxNo = ds.Tables[0].Rows[0]["æ¡ç ç¼å·"].ToString(); |
| | | HBarCodeMaxNo = HBarCodeMaxNo.Substring(HBarCodeMaxNo.Length - LEN, LEN); |
| | | HMaxNo = ClsPub.isLong(HBarCodeMaxNo); |
| | | } |
| | | |
| | | |
| | | //è·å彿¥æ¬äº§å 卿¡ç æ¡£æ¡åäº§åæ¡ç å¤ä»½è¡¨ä¸ æå¤§çæµæ°´å· |
| | | long count = 0; |
| | | count = HMaxNo >= HMaxNo_Bak ? HMaxNo : HMaxNo_Bak; |
| | | |
| | | //ä¸ºæµæ°´å·åé¢è¡¥é¶ |
| | | LIU += count + 1; |
| | | while (LIU.Length < LEN) //å¦ææµæ°´å·å°äº6使°åé¢è¡¥0 |
| | | { |
| | | LIU = "0" + LIU; |
| | | } |
| | | |
| | | //æ¼æ¥æ¹å· |
| | | HBarCode_MaxNo = sYear + sPeriod + sDay + LIU; |
| | | |
| | | return HBarCode_MaxNo; |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region çå¬é讯 |
| | |
| | | { |
| | | return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdList); |
| | | } |
| | | #endregion |
| | | #endregion |
| | | |
| | | |
| | |
| | | this.bc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.bc.ImageTransparentColor = System.Drawing.Color.Magenta; |
| | | this.bc.Name = "bc"; |
| | | this.bc.Size = new System.Drawing.Size(35, 47); |
| | | this.bc.Size = new System.Drawing.Size(60, 60); |
| | | this.bc.Text = "çæ"; |
| | | this.bc.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.bc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | |
| | | this.tc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.tc.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.tc.Margin = new System.Windows.Forms.Padding(100, 2, 0, 3); |
| | | this.tc.Name = "tc"; |
| | | this.tc.Size = new System.Drawing.Size(35, 47); |
| | | this.tc.Size = new System.Drawing.Size(60, 60); |
| | | this.tc.Text = "éåº"; |
| | | this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | |
| | | // cmdSourceBillNo |
| | | // |
| | | this.cmdSourceBillNo.Image = ((System.Drawing.Image)(resources.GetObject("cmdSourceBillNo.Image"))); |
| | | this.cmdSourceBillNo.ImageAlign = System.Drawing.ContentAlignment.TopRight; |
| | | this.cmdSourceBillNo.Location = new System.Drawing.Point(1214, 11); |
| | | this.cmdSourceBillNo.Location = new System.Drawing.Point(1214, -4); |
| | | this.cmdSourceBillNo.Margin = new System.Windows.Forms.Padding(4); |
| | | this.cmdSourceBillNo.Name = "cmdSourceBillNo"; |
| | | this.cmdSourceBillNo.Size = new System.Drawing.Size(33, 33); |
| | | this.cmdSourceBillNo.Size = new System.Drawing.Size(60, 60); |
| | | this.cmdSourceBillNo.TabIndex = 99; |
| | | this.cmdSourceBillNo.UseVisualStyleBackColor = true; |
| | | this.cmdSourceBillNo.Click += new System.EventHandler(this.cmdSourceBillNo_Click_1); |
| | |
| | | // radioButton_HIsUsingBatchNo |
| | | // |
| | | this.radioButton_HIsUsingBatchNo.AutoSize = true; |
| | | this.radioButton_HIsUsingBatchNo.Enabled = false; |
| | | this.radioButton_HIsUsingBatchNo.Location = new System.Drawing.Point(874, 190); |
| | | this.radioButton_HIsUsingBatchNo.Name = "radioButton_HIsUsingBatchNo"; |
| | | this.radioButton_HIsUsingBatchNo.Size = new System.Drawing.Size(141, 22); |
| | |
| | | // |
| | | // button_stopListen |
| | | // |
| | | this.button_stopListen.Location = new System.Drawing.Point(404, 250); |
| | | this.button_stopListen.Location = new System.Drawing.Point(404, 223); |
| | | this.button_stopListen.Name = "button_stopListen"; |
| | | this.button_stopListen.Size = new System.Drawing.Size(151, 35); |
| | | this.button_stopListen.Size = new System.Drawing.Size(192, 62); |
| | | this.button_stopListen.TabIndex = 97; |
| | | this.button_stopListen.Text = "忢çå¬"; |
| | | this.button_stopListen.UseVisualStyleBackColor = true; |
| | |
| | | // |
| | | // button_startListen |
| | | // |
| | | this.button_startListen.Location = new System.Drawing.Point(214, 250); |
| | | this.button_startListen.Location = new System.Drawing.Point(187, 223); |
| | | this.button_startListen.Name = "button_startListen"; |
| | | this.button_startListen.Size = new System.Drawing.Size(133, 35); |
| | | this.button_startListen.Size = new System.Drawing.Size(160, 62); |
| | | this.button_startListen.TabIndex = 96; |
| | | this.button_startListen.Text = "å¼å§çå¬"; |
| | | this.button_startListen.UseVisualStyleBackColor = true; |
| | |
| | | // |
| | | this.button_resetParams.Location = new System.Drawing.Point(590, 173); |
| | | this.button_resetParams.Name = "button_resetParams"; |
| | | this.button_resetParams.Size = new System.Drawing.Size(89, 40); |
| | | this.button_resetParams.Size = new System.Drawing.Size(153, 75); |
| | | this.button_resetParams.TabIndex = 105; |
| | | this.button_resetParams.Text = "é ç½®"; |
| | | this.button_resetParams.UseVisualStyleBackColor = true; |
| | |
| | | // |
| | | // button_saveParams |
| | | // |
| | | this.button_saveParams.Location = new System.Drawing.Point(377, 173); |
| | | this.button_saveParams.Location = new System.Drawing.Point(311, 173); |
| | | this.button_saveParams.Name = "button_saveParams"; |
| | | this.button_saveParams.Size = new System.Drawing.Size(89, 40); |
| | | this.button_saveParams.Size = new System.Drawing.Size(155, 75); |
| | | this.button_saveParams.TabIndex = 104; |
| | | this.button_saveParams.Text = "ä¿ å"; |
| | | this.button_saveParams.UseVisualStyleBackColor = true; |
| | |
| | | this.tabControl_MainInfo = new System.Windows.Forms.TabControl(); |
| | | this.tabPage_BillInfo = new System.Windows.Forms.TabPage(); |
| | | this.gbUp = new System.Windows.Forms.GroupBox(); |
| | | this.button_produceTemp = new System.Windows.Forms.Button(); |
| | | this.label_sBillNo = new System.Windows.Forms.Label(); |
| | | this.textBox_sBillNo = new System.Windows.Forms.TextBox(); |
| | | this.label_sBillID = new System.Windows.Forms.Label(); |
| | |
| | | // gbUp |
| | | // |
| | | this.gbUp.BackColor = System.Drawing.Color.Transparent; |
| | | this.gbUp.Controls.Add(this.button_produceTemp); |
| | | this.gbUp.Controls.Add(this.label_sBillNo); |
| | | this.gbUp.Controls.Add(this.textBox_sBillNo); |
| | | this.gbUp.Controls.Add(this.label_sBillID); |
| | |
| | | this.gbUp.Size = new System.Drawing.Size(1374, 310); |
| | | this.gbUp.TabIndex = 33; |
| | | this.gbUp.TabStop = false; |
| | | // |
| | | // button_produceTemp |
| | | // |
| | | this.button_produceTemp.Location = new System.Drawing.Point(829, 215); |
| | | this.button_produceTemp.Name = "button_produceTemp"; |
| | | this.button_produceTemp.Size = new System.Drawing.Size(158, 70); |
| | | this.button_produceTemp.TabIndex = 123; |
| | | this.button_produceTemp.Text = "临æ¶ç»æ"; |
| | | this.button_produceTemp.UseVisualStyleBackColor = true; |
| | | this.button_produceTemp.Click += new System.EventHandler(this.button_produceTemp_Click); |
| | | // |
| | | // label_sBillNo |
| | | // |
| | |
| | | // |
| | | // button_produceByHand |
| | | // |
| | | this.button_produceByHand.Location = new System.Drawing.Point(591, 250); |
| | | this.button_produceByHand.Location = new System.Drawing.Point(591, 215); |
| | | this.button_produceByHand.Name = "button_produceByHand"; |
| | | this.button_produceByHand.Size = new System.Drawing.Size(151, 35); |
| | | this.button_produceByHand.Size = new System.Drawing.Size(186, 70); |
| | | this.button_produceByHand.TabIndex = 118; |
| | | this.button_produceByHand.Text = "æªæ»¡æçæ"; |
| | | this.button_produceByHand.UseVisualStyleBackColor = true; |
| | |
| | | // |
| | | // button_stopListen |
| | | // |
| | | this.button_stopListen.Location = new System.Drawing.Point(404, 250); |
| | | this.button_stopListen.Location = new System.Drawing.Point(379, 215); |
| | | this.button_stopListen.Name = "button_stopListen"; |
| | | this.button_stopListen.Size = new System.Drawing.Size(151, 35); |
| | | this.button_stopListen.Size = new System.Drawing.Size(176, 70); |
| | | this.button_stopListen.TabIndex = 97; |
| | | this.button_stopListen.Text = "åæ¢ç»æ"; |
| | | this.button_stopListen.UseVisualStyleBackColor = true; |
| | |
| | | // textBox_HPackBarCode |
| | | // |
| | | this.textBox_HPackBarCode.BackColor = System.Drawing.SystemColors.ScrollBar; |
| | | this.textBox_HPackBarCode.Enabled = false; |
| | | this.textBox_HPackBarCode.Location = new System.Drawing.Point(122, 81); |
| | | this.textBox_HPackBarCode.Name = "textBox_HPackBarCode"; |
| | | this.textBox_HPackBarCode.Size = new System.Drawing.Size(280, 28); |
| | | this.textBox_HPackBarCode.TabIndex = 43; |
| | | this.textBox_HPackBarCode.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox_HPackBarCode__KeyPress); |
| | | // |
| | | // dtpHDate |
| | | // |
| | |
| | | // |
| | | // button_startListen |
| | | // |
| | | this.button_startListen.Location = new System.Drawing.Point(214, 250); |
| | | this.button_startListen.Location = new System.Drawing.Point(147, 215); |
| | | this.button_startListen.Name = "button_startListen"; |
| | | this.button_startListen.Size = new System.Drawing.Size(133, 35); |
| | | this.button_startListen.Size = new System.Drawing.Size(200, 70); |
| | | this.button_startListen.TabIndex = 96; |
| | | this.button_startListen.Text = "èªå¨ç»æ"; |
| | | this.button_startListen.UseVisualStyleBackColor = true; |
| | |
| | | // |
| | | this.button_resetParams.Location = new System.Drawing.Point(590, 173); |
| | | this.button_resetParams.Name = "button_resetParams"; |
| | | this.button_resetParams.Size = new System.Drawing.Size(89, 40); |
| | | this.button_resetParams.Size = new System.Drawing.Size(134, 81); |
| | | this.button_resetParams.TabIndex = 105; |
| | | this.button_resetParams.Text = "é ç½®"; |
| | | this.button_resetParams.UseVisualStyleBackColor = true; |
| | | // |
| | | // button_saveParams |
| | | // |
| | | this.button_saveParams.Location = new System.Drawing.Point(377, 173); |
| | | this.button_saveParams.Location = new System.Drawing.Point(311, 173); |
| | | this.button_saveParams.Name = "button_saveParams"; |
| | | this.button_saveParams.Size = new System.Drawing.Size(89, 40); |
| | | this.button_saveParams.Size = new System.Drawing.Size(155, 81); |
| | | this.button_saveParams.TabIndex = 104; |
| | | this.button_saveParams.Text = "ä¿ å"; |
| | | this.button_saveParams.UseVisualStyleBackColor = true; |
| | |
| | | this.toolStripButton_Delete.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.toolStripButton_Delete.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.toolStripButton_Delete.Name = "toolStripButton_Delete"; |
| | | this.toolStripButton_Delete.Size = new System.Drawing.Size(35, 47); |
| | | this.toolStripButton_Delete.Size = new System.Drawing.Size(60, 60); |
| | | this.toolStripButton_Delete.Text = "å é¤"; |
| | | this.toolStripButton_Delete.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.toolStripButton_Delete.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | |
| | | this.tc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.tc.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.tc.Margin = new System.Windows.Forms.Padding(100, 2, 0, 3); |
| | | this.tc.Name = "tc"; |
| | | this.tc.Size = new System.Drawing.Size(35, 47); |
| | | this.tc.Size = new System.Drawing.Size(60, 60); |
| | | this.tc.Text = "éåº"; |
| | | this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | |
| | | private System.Windows.Forms.ToolStripSeparator toolStripSeparator10; |
| | | private System.Windows.Forms.ToolStripButton tc; |
| | | private System.Windows.Forms.ToolStripButton toolStripButton_Delete; |
| | | private System.Windows.Forms.Button button_produceTemp; |
| | | } |
| | | } |
| | |
| | | //æªæ»¡æçæ æé® ç¹å»äºä»¶ |
| | | private void button_produceByHand_Click(object sender, EventArgs e) |
| | | { |
| | | if (HQty == 0) |
| | | try |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | if (HQty == 0) |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | } |
| | | this.Sub_SaveBill(); |
| | | }catch(Exception ex) |
| | | { |
| | | MessageBox.Show(ex.Message); |
| | | } |
| | | this.Sub_SaveBill(); |
| | | } |
| | | |
| | | //èªå¨ç»æ |
| | |
| | | comboBox_SourceNameParams.Enabled = false; |
| | | |
| | | button_saveParams.Enabled = false; |
| | | |
| | | textBox_HBarCode.Focus(); |
| | | } |
| | | |
| | | //åæ¢ç»æ |
| | |
| | | { |
| | | if(isStartListen == 1) |
| | | { |
| | | if(HQty == DBUtility.ClsPub.isDoule(textBox_PackQty.Text)) |
| | | try |
| | | { |
| | | this.Sub_SaveBill(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | if (HQty == DBUtility.ClsPub.isDoule(textBox_PackQty.Text)) |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | this.Sub_SaveBill(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | } |
| | | Report.Print(false); |
| | | } |
| | | Report.Print(false); |
| | | }catch(Exception ex) |
| | | { |
| | | MessageBox.Show(ex.Message); |
| | | } |
| | | } |
| | | } |
| | |
| | | //çææçæ¡ç |
| | | private bool Sub_SaveBill() |
| | | { |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | if (HOrgID == -1) |
| | | try |
| | | { |
| | | MessageBox.Show("éæ©ç»ç»æé误ï¼"); |
| | | return false; |
| | | } |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | if (HOrgID == -1) |
| | | { |
| | | throw new Exception("éæ©ç»ç»æé误ï¼"); |
| | | } |
| | | |
| | | if (!Sub_AllowSave())//忮宿´æ§å¤æ |
| | | if (!Sub_AllowSave())//忮宿´æ§å¤æ |
| | | { |
| | | throw new Exception("忮宿´æ§å¤æå¤±è´¥ï¼"); |
| | | } |
| | | |
| | | SaveBarCode(); |
| | | return true; |
| | | }catch(Exception ex) |
| | | { |
| | | return false; |
| | | throw new Exception(ex.Message); |
| | | } |
| | | |
| | | |
| | | SaveBarCode(); |
| | | return true; |
| | | |
| | | } |
| | | |
| | | //忮宿´æ§å¤æ æªå®æ |
| | |
| | | |
| | | sSQLMul[1] = " exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + HQty.ToString() + " "; |
| | | |
| | | //夿å½åæçæ¡ç æ¯å¦å·²ç»éè¿ä¸´æ¶ç»æå¨æ¡ç æ¡£æ¡ä¸çæäºï¼è¥å·²ç»çæäºåä¸éè¦å¨æå
¥ |
| | | ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HBarCode = '" + textBox_HPackBarCode.Text + "' and HSTOCKORGID = " + HOrgID, "Gy_BarCodeBill"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | sSQLMul[0] = ""; |
| | | } |
| | | |
| | | oCn.BeginTran(); |
| | | |
| | | if (getRunProcByMul_Back(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå®æ¯ï¼"); |
| | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå¤±è´¥ï¼" + DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.RollBack(); |
| | | } |
| | | |
| | | //oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå¤±è´¥ï¼" + e.Message); |
| | | oCn.RollBack(); |
| | | throw new Exception(e.Message); |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | for (int i = 0; i < 1; i++) |
| | | { |
| | | oCn.RunProc(sSQL[i]); |
| | | if (sSQL[i].Length > 0) |
| | | { |
| | | oCn.RunProc(sSQL[i]); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | //ä¸ä¼ ç»æä¿¡æ¯å°æå¡å¨ |
| | | send(); |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "æ²¡ææ°æ®ï¼"; |
| | | oCn.Commit(); |
| | | return false; |
| | | sErrMsg = "æ²¡ææ°æ®ï¼"; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | oCn.Commit(); |
| | | //oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = e.Message; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | private void send() |
| | | { |
| | | string err = ""; |
| | | if (!CheckModRight(ModRightNamePackUnion, DBUtility.ClsPub.CurUserName, ref err)) |
| | | { |
| | | MessageBox.Show(err); |
| | | return; |
| | | } |
| | | //if (!CheckModRight(ModRightNamePackUnion, DBUtility.ClsPub.CurUserName, ref err)) |
| | | //{ |
| | | // MessageBox.Show(err); |
| | | // return; |
| | | //} |
| | | //if (MessageBox.Show("ç¡®å®è¦ä¸ä¼ ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | //{ |
| | | // return; |
| | | //} |
| | | LoadData(); |
| | | try |
| | | { |
| | | LoadData(); |
| | | }catch(Exception ex) |
| | | { |
| | | throw new Exception(ex.Message); |
| | | } |
| | | } |
| | | |
| | | //å¤æç¨æ·æé |
| | |
| | | //夿æ¯å¦æ°æ®å®æ´ |
| | | if (AllowLoadData() == false) |
| | | { |
| | | return; |
| | | throw new Exception("æ°æ®å®æ´æ§å¤æå¤±è´¥ï¼"); |
| | | } |
| | | try |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("çæå¤±è´¥ï¼åå :" + err); |
| | | return; |
| | | string error = "çæå¤±è´¥ï¼åå :" + err; |
| | | throw new Exception(error); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("åæ®å·ï¼" + textBox_sBillID.Text + "ï¼åæ®IDï¼" + textBox_sBillID.Text + "ï¼ä¸ä¼ 失败ï¼" + e.Message); |
| | | return; |
| | | string error = "åæ®å·ï¼" + textBox_sBillID.Text + "ï¼åæ®IDï¼" + textBox_sBillID.Text + "ï¼ä¸ä¼ 失败ï¼" + e.Message; |
| | | throw new Exception(error); |
| | | } |
| | | } |
| | | |
| | |
| | | public bool set_SavePackUnionBill_Add(Int64 HInterID, string HBillType, string HBillNo, string HBarCode_Pack, string HMaker, Int64 HStockOrgID, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | oCn.BeginTran(); |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Sc_PackUnionBill_Insert_New " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + HBarCode_Pack + "','" + HMaker + "'," + HStockOrgID.ToString(), "h_p_Sc_PackUnionBill_Insert_New"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼ä¸ä¼ 失败ï¼"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼ä¸ä¼ 失败ï¼"; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "ä¸ä¼ 失败ï¼åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "ä¸ä¼ 失败ï¼åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | else |
| | | { |
| | | //sErrMsg = "çæçäº§ç»æåæåï¼åæ®å·ä¸ºï¼" + HBillNo; |
| | | oCn.Commit(); |
| | | //sErrMsg = "çæçäº§ç»æåæåï¼åæ®å·ä¸ºï¼" + HBillNo; |
| | | return true; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "çæçäº§ç»æå失败ï¼" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "çæçäº§ç»æå失败ï¼" + e.Message; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | catch (Exception e2) |
| | | { |
| | | //if (DBUtility.ClsPub.bSound) |
| | | //{ |
| | | // DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); |
| | | //} |
| | | MessageBox.Show("åçç½ç»å¼å¸¸ï¼è¯·ç¨ååè¯ï¼"); |
| | | textBox_HBarCode.Text = ""; |
| | | textBox_HBarCode.Focus(); |
| | | MessageBox.Show(e2.Message); |
| | | } |
| | | } |
| | | //å°æ¡ç ä¿¡æ¯åå
¥æ¡ç åºå
¥åºä¸´æ¶è¡¨ |
| | |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show(err); |
| | | return; |
| | | throw new Exception(err); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("æ«æåæ¡ç ï¼åå
¥ä¸´æ¶è¡¨ä¿¡æ¯å¤±è´¥ï¼" + e.Message + err); |
| | | string sError = "æ«æåæ¡ç ï¼åå
¥ä¸´æ¶è¡¨ä¿¡æ¯å¤±è´¥ï¼" + e.Message + err; |
| | | throw new Exception(sError); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region 临æ¶ç»æ |
| | | #region 临æ¶ç»æ æé®ç¹å»äºä»¶ |
| | | private void button_produceTemp_Click(object sender, EventArgs e) |
| | | { |
| | | if (HQty == 0) |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | } |
| | | this.produceTemp(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + "_Temp" + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | } |
| | | Report.Print(false); |
| | | } |
| | | #endregion |
| | | |
| | | #region 临æ¶ç»æ |
| | | private void produceTemp() |
| | | { |
| | | //夿æ¡ç æ¡£æ¡ä¸æ¯å¦å·²ç»åå¨è¯¥ææ¡ç ï¼è¥åå¨ï¼åä¸éè¦åå建ãéæ°å è½½çé¢å³å¯ã |
| | | DataSet ds_getPackBarCode; |
| | | string sql_getPackBarCode = "select * from Gy_BarCodeBill where HBarCode = '" + textBox_HPackBarCode.Text + "'"; |
| | | ds_getPackBarCode = oCn.RunProcReturn(sql_getPackBarCode, "Gy_BarCodeBill"); |
| | | if (ds_getPackBarCode != null && ds_getPackBarCode.Tables[0].Rows.Count > 0) |
| | | { |
| | | //éæ°å è½½çé¢ |
| | | getDisplay_grdSub(); |
| | | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | return; |
| | | } |
| | | |
| | | |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | //éªè¯ç»ç» |
| | | if (HOrgID == -1) |
| | | { |
| | | MessageBox.Show("éæ©ç»ç»æé误ï¼"); |
| | | return; |
| | | } |
| | | |
| | | //忮宿´æ§å¤æ |
| | | if (!Sub_AllowSave()) |
| | | { |
| | | return; |
| | | } |
| | | |
| | | //è·åå½å产线å产线å
ç |
| | | long HSourceID = 0; |
| | | string sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "' "; |
| | | DataSet ds = oCn.RunProcReturn(sql, "Gy_Source"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | |
| | | //æ¼æ¥ä¸´æ¶ç»ææ¶ï¼ææ¡ç ççæè¯å¥ |
| | | sSQLMul = new string[2]; |
| | | sSQLMul[0] = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HJiaYe " + |
| | | ",HPressModel,HCusModel,HMaterialModel,HColor,HBarCodeDate " + |
| | | ",HLogo,HPackageSize,HMaterialJQty,HMaterialMQty,HCustomBatchNo " + |
| | | ",HSTOCKORGID,HOWNERID,HBeginDate,HSeOrderBillNo,HGBBarCode " + |
| | | ",POOrderBillNo,HInterID,HInitSourceEntryID,HBarCode_Pack " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo " + |
| | | ",HCustomQty1,HLayerNumber,HCusBarCode,HBarCodeStatus,HSourceID " + |
| | | ") values (" |
| | | + "'" + textBox_HPackBarCode.Text + "','" + HBarCodeType + "',0,0,1" |
| | | + ",'',0,0,'" + ClsPub.CurUserName + "',getdate(),0,1" |
| | | + ",0,0,'','',''" |
| | | + "," + HQty.ToString() + ",1,0,0,0,''" |
| | | + ",0,'','','',''" |
| | | + ",'','','','','" + sDate + "'" |
| | | + ",'','',0,0,''" |
| | | + "," + HOrgID.ToString() + "," + HOrgID.ToString() + ",'','',''" |
| | | + ",''," + HInterID.ToString() + ",0,'" + textBox_HPackBarCode.Text + "'" |
| | | + ",'','','',0,''" |
| | | + ",0,0,'',''," + HSourceID + |
| | | ")"; |
| | | //æ¼æ¥ æ´æ° ææ¡ç æµæ°´å· çsqlè¯å¥ |
| | | sSQLMul[1] = " exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + HQty.ToString() + " "; |
| | | |
| | | if (sSQLMul.Length > 0) |
| | | { |
| | | //æ§è¡ææ¡ç ççæè¯å¥ä¸ææ¡ç æµæ°´å·çæ´æ°è¯å¥ |
| | | for (int i = 0; i < 1; i++) |
| | | { |
| | | oCn.RunProc(sSQLMul[i]); |
| | | } |
| | | |
| | | //éæ°å è½½çé¢ |
| | | getDisplay_grdSub(); |
| | | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("æ²¡ææ°æ®ï¼"); |
| | | return; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ææ¡ç æ«ç |
| | | private void textBox_HPackBarCode__KeyPress(object sender, KeyPressEventArgs e) |
| | | { |
| | | if (e.KeyChar == (char)Keys.Return) |
| | | { |
| | | //è·åæ«æçææ¡ç |
| | | string HPackBarCode = textBox_HPackBarCode.Text; |
| | | //æ¡ç ç±»å |
| | | HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text); |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | //声æç¨äºæ°æ®åºæ¥è¯¢çåé |
| | | string sql = ""; |
| | | DataSet ds; |
| | | |
| | | //夿 ææ¡ç æ¯å¦å·²ç»çæç»æå |
| | | sql = "select * from Sc_PackUnionBillMain where HBarCode_Pack = '" + HPackBarCode + "'"; |
| | | ds = oCn.RunProcReturn(sql, "Sc_PackUnionBillMain"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | MessageBox.Show("ææ¡ç [" + HPackBarCode + "]å·²ç»ç»æï¼"); |
| | | return; |
| | | } |
| | | |
| | | |
| | | //è·åå½å产线 |
| | | long HSourceID = 0; |
| | | sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "'"; |
| | | ds = oCn.RunProcReturn(sql, "Gy_Source"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | |
| | | |
| | | //è·åç¼ååè¡¨ä¸ ææ¡ç 对åºç ç»æè®°å½ |
| | | sql = "select top(1) a.* from Sc_PackUnionBill_Temp as a inner join Gy_BarCodeBill as b on a.HBarCode = b.HBarCode where a.HBarCode_Pack = '" + HPackBarCode + "' and b.HSourceID = " + HSourceID + " and a.HStockorgID = " + HOrgID; |
| | | ds = oCn.RunProcReturn(sql, "Sc_PackUnionBill_Temp"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | MessageBox.Show("ç¼ååè¡¨ä¸æªæ¥è¯¢å°è¯¥ææ¡ç ä¸åæ¡ç çç»æè®°å½ï¼"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | string HBarCode_Pack = ds.Tables[0].Rows[0]["HBarCode_Pack"].ToString(); |
| | | long HBillID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"].ToString()); |
| | | string HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | |
| | | textBox_HPackBarCode.Text = HBarCode_Pack; |
| | | textBox_sBillID.Text = HBillID.ToString(); |
| | | textBox_sBillNo.Text = HBillNo; |
| | | |
| | | getDisplay_GrdMain(); |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | #endregion |
| | | |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList order by hmainid desc", "h_v_IF_SeOrderBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList order by hmainid desc,hsubid asc", "h_v_IF_SeOrderBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_SeOrderBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc,hsubid asc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList"); |
| | | } |
| | | |
| | |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID, "h_v_IF_SeOrderBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID + " order by hsubid asc", "h_v_IF_SeOrderBillList"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | public string HMainSourceBillNo; |
| | | public string HMainSourceBillType; |
| | | public int HOrderLevID; |
| | | public int HTaskClassID; |
| | | } |
| | | #endregion |
| | | |
| | |
| | | string HMainSourceBillNo = mainList[0].HMainSourceBillNo; |
| | | string HMainSourceBillType = mainList[0].HMainSourceBillType; |
| | | int HOrderLevID = mainList[0].HOrderLevID; |
| | | |
| | | int HTaskClassID = mainList[0].HTaskClassID; |
| | | |
| | | |
| | | if (OperationType == 2) |
| | |
| | | { |
| | | string sql = "insert into PM_WorkTaskBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" + |
| | | ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID)" + |
| | | ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID,HTaskClassID)" + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | |
| | | ",'" + HMainSourceBillNo + |
| | | "','" + HMainSourceBillType + |
| | | "','" + HOrderLevID + |
| | | "','"+ HTaskClassID+ |
| | | "')"; |
| | | |
| | | //主表 |
| | |
| | | ",HMainSourceBillNo = '" + HMainSourceBillNo + |
| | | "',HMainSourceBillType = '" + HMainSourceBillType + |
| | | "',HOrderLevID = '" + HOrderLevID + |
| | | "',HTaskClassID = '" + HTaskClassID + |
| | | "' where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | |
| | | public DAL.ClsPM_ProjectMoneyBillMain BillNew4 = new DAL.ClsPM_ProjectMoneyBillMain(); //项ç®è´¹ç¨å对åºåæ®ç±» |
| | | public DAL.ClsPM_ProjectMoneyBillMain BillOld4 = new DAL.ClsPM_ProjectMoneyBillMain(); |
| | | |
| | | public DAL.ClsPM_ProjectBeginBillMain BillNew5 = new DAL.ClsPM_ProjectBeginBillMain(); //项ç®å¯å¨å对åºåæ®ç±» |
| | | public DAL.ClsPM_ProjectBeginBillMain BillOld5 = new DAL.ClsPM_ProjectBeginBillMain(); |
| | | |
| | | public DAL.ClsPM_ProjectEndBillMain BillNew6 = new DAL.ClsPM_ProjectEndBillMain(); //项ç®éªæ¶å对åºåæ®ç±» |
| | | public DAL.ClsPM_ProjectEndBillMain BillOld6 = new DAL.ClsPM_ProjectEndBillMain(); |
| | | |
| | | #region å·¥ç¨é¡¹ç® æ°å¢/ç¼è¾ |
| | | #region å·¥ç¨é¡¹ç® è¡¨å¤´æ°æ® |
| | | public class PM_ProjectBill_Main |
| | |
| | | if (refSav == "Add") |
| | | { |
| | | //忮巿¯å¦éå¤ |
| | | if (BillNew1.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | if (BillNew5.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | } |
| | | if (refSav == "Update") |
| | | { |
| | | if (BillOld1.ShowBill(oItem.HInterID, ref s) == false) |
| | | if (BillOld5.ShowBill(oItem.HInterID, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | //夿æ¯å¦å¯ç¼è¾ |
| | | if (BillOld1.omodel.HChecker != "" && BillOld1.omodel.HChecker != null) |
| | | if (BillOld5.omodel.HChecker != "" && BillOld5.omodel.HChecker != null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (BillOld1.omodel.HBillStatus > 1) |
| | | if (BillOld5.omodel.HBillStatus > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | if (refSav == "Add") |
| | | { |
| | | //忮巿¯å¦éå¤ |
| | | if (BillNew1.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | if (BillNew6.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | } |
| | | if (refSav == "Update") |
| | | { |
| | | if (BillOld1.ShowBill(oItem.HInterID, ref s) == false) |
| | | if (BillOld6.ShowBill(oItem.HInterID, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | //夿æ¯å¦å¯ç¼è¾ |
| | | if (BillOld1.omodel.HChecker != "" && BillOld1.omodel.HChecker != null) |
| | | if (BillOld6.omodel.HChecker != "" && BillOld6.omodel.HChecker != null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (BillOld1.omodel.HBillStatus > 1) |
| | | if (BillOld6.omodel.HBillStatus > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |