Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | "',HMaterID='" + omodel.HMaterID.ToString() + |
| | | "',HProcID='" + omodel.HProcID.ToString() + |
| | | "',HSourceID='" + omodel.HSourceID.ToString() + |
| | | "',HDivisionID='" + omodel.HDivisionID.ToString() + |
| | | "',HOrgID='" + omodel.HOrgID.ToString() + "'" + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | |
| | | oCn.RunProc("Insert Into HR_EmployeeSkillExamBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HDeptID,HGroupID,HCheckEmpID,HMaterID,HProcID,HSourceID,HOrgID" + |
| | | ",HDeptID,HGroupID,HCheckEmpID,HMaterID,HProcID,HSourceID,HOrgID,HDivisionID" + |
| | | ",HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ",'" + omodel.HDeptID.ToString() + "'," + omodel.HGroupID.ToString() + "," + omodel.HCheckEmpID + "," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HSourceID.ToString() + "," + omodel.HOrgID.ToString() + ",'" + omodel.HMainSourceBillType + |
| | | "'," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "'" + |
| | | ",'" + omodel.HDeptID.ToString() + "'," + omodel.HGroupID.ToString() + "," + omodel.HCheckEmpID + "," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HSourceID.ToString() + "," + omodel.HOrgID.ToString() + "," + omodel.HDivisionID.ToString() + "" + |
| | | ",'" + omodel.HMainSourceBillType + "'," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsHR_EmployeeSkillExamBillSub oSub in DetailColl) |
| | |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + |
| | | ",HBarCode,HReportType,HBadProcID" + |
| | | ",HAddr,HMaker,HMakeDate" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID" + |
| | | ") values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | | "," + oSub.HEntryID.ToString() + "" + |
| | |
| | | "','" + oSub.HAddr + "'" + |
| | | ",'" + oSub.HMaker + "'" + |
| | | ",'" + oSub.HMakeDate.ToShortDateString() + "'" + |
| | | "," + oSub.HProcID + |
| | | ") "; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + |
| | | ",HBarCode,HReportType,HBadProcID" + |
| | | ",HAddr,HMaker,HMakeDate" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID" + |
| | | ") values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | | "," + oSub.HEntryID.ToString() + "" + |
| | |
| | | ",'" + oSub.HAddr + "'" + |
| | | ",'" + oSub.HMaker + "'" + |
| | | ",'" + oSub.HMakeDate.ToShortDateString() + "'" + |
| | | "," + oSub.HProcID + |
| | | ") "; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | public Int64 HProcID;// å·¥åº |
| | | public Int64 HSourceID;// çäº§èµæº |
| | | public Int64 HOrgID;// ç»ç» |
| | | public Int64 HDivisionID;// äºä¸é¨ |
| | | } |
| | | } |
| | |
| | | public Int64 HInterID = 0; |
| | | public string HBillNo = ""; |
| | | public string HBillType = "1202"; |
| | | public Int64 HMaterID = 0; |
| | | public string HBatchNo = ""; |
| | | public Int64 HAuxPropID = 0; |
| | | public Int64 HUnitID = 0; |
| | | public Int64 HWhID = 0; |
| | |
| | | public string PrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ§å¶ |
| | | public string UpdatePrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ´æ° |
| | | public string sBarCodeItemID = ""; //æ¡ç èªå¢å |
| | | public string HBarCode_Pack = ""; //ææ¡ç |
| | | public long HSNo = 0; //ç»æè®¡æ°ç¨ |
| | | public DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl(); |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | |
| | | { |
| | | HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); //å¾å°æ°åæ®ID |
| | | HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); //å¾å°æ°åæ®å· |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBack"]) == 1) |
| | | { |
| | | HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); //å¾å°æ°åæ®ID |
| | | HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); //å¾å°æ°åæ®å· |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else |
| | | { |
| | |
| | | if (grdSub.Rows.Count > 0) |
| | | { |
| | | grdSub.Rows[0].Selected = true; |
| | | SourceBill(); |
| | | SourceBill(1); |
| | | txtHQty.Focus(); |
| | | } |
| | | else |
| | |
| | | return false; |
| | | } |
| | | |
| | | if (DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text) != "") |
| | | { |
| | | MessageBox.Show("å½åç»ææªç»æï¼è¯·ç»æç»æååç¹å»æ¢çï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | |
| | | } |
| | | Source_Display(); |
| | | grdSub.Rows[0].Selected = true; |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | SourceBill(); |
| | | SourceBill(2); |
| | | txtHBarCode.Text = ""; |
| | | txtHQty.Focus(); |
| | | } |
| | |
| | | } |
| | | Source_Display(); |
| | | grdSub.Rows[0].Selected = true; |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | SourceBill(); |
| | | SourceBill(2); |
| | | txtHBarCode.Text = ""; |
| | | txtHQty.Focus(); |
| | | } |
| | |
| | | |
| | | private void cmdSourceBillNo_Click(object sender, EventArgs e) |
| | | { |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | cmbHBarCodeType.Items.Clear(); |
| | | cmbHBarCodeType.Items.Add("å¯ä¸æ¡ç "); |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | |
| | | if (grdSub.CurrentRow == null) |
| | | { |
| | | MessageBox.Show("请å¨å·¦è¾¹åæ®å表ä¸éæ©ä¸è¡åæ®ï¼", "æç¤º"); |
| | |
| | | } |
| | | else |
| | | { |
| | | SourceBill(); |
| | | SourceBill(3); |
| | | txtHQty.Focus(); |
| | | } |
| | | } |
| | |
| | | } |
| | | SaveBarCode(); |
| | | BarCode_Display(); |
| | | if (DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text) != "") |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | grdMain.Rows[0].Selected = true; |
| | | |
| | | sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); |
| | |
| | | Int64 HBadReasonID = 0; //ä¸è¯åå ID |
| | | string HCusMaterName = ""; //客æ·ç©æåç§° |
| | | string HCusModel = ""; //客æ·è§æ ¼åå· |
| | | string HBarCode_Pack = ""; //æçæ¡ç |
| | | |
| | | HBarCode = TM; |
| | | HBarCodeType = DBUtility.ClsPub.isStrNull(cmbHBarCodeType.Text); |
| | |
| | | HBadReasonID = DBUtility.ClsPub.isLong(txtHRemark.Tag); |
| | | HCusMaterName = DBUtility.ClsPub.isStrNull(txtHCusMaterName.Text); |
| | | HCusModel = DBUtility.ClsPub.isStrNull(txtHCusModel.Text); |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | HSNo = HSNo + 1; |
| | | } |
| | | |
| | | try |
| | | { |
| | |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate,HMaterialJQty,HMaterialMQty,HNowQty " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag,HBarCode_Pack " + |
| | | ",HOrderInterID,HOrderEntryID,HOrderBillNo,HCustomQty1,HMaterialModel,HCusModel " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo,HPackflag " + |
| | | ") Values (" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString() |
| | | + ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + HMaker + "',getdate(),0," + HQty.ToString() |
| | |
| | | + ", 0,'',getdate(),'','" + sDate + "'," + HMaterialJQty.ToString() + "," + HMaterialMQty.ToString() + "," + HNowQty.ToString() |
| | | + ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0,'" + HBarCode_Pack + "'" |
| | | + ", " + HProcessExchangeInterID.ToString() + ",0,'" + HProcessExchangeBillNo + "'," + HBadReasonID.ToString() + ",'" + HCusMaterName + "','" + HCusModel + "'" |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1')"); |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1',0)"); |
| | | |
| | | //åå¡«æå¤§æµæ°´å· |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 "); |
| | |
| | | |
| | | #region //è¿åä¿¡æ¯ |
| | | |
| | | //è¿åæºååè¡¨ä¿¡æ¯ |
| | | private void SourceBill() |
| | | //è¿åæºåå表信æ¯(num=1ï¼æå¼æ¨¡åæ¶å è½½æ¾ç¤ºï¼num=2ï¼æ«æµè½¬å¡æ¾ç¤ºï¼num=3ï¼éåæé®æ¾ç¤º) |
| | | private void SourceBill(int num) |
| | | { |
| | | //æå¼æ¨¡åæ¶å è½½æ¾ç¤º |
| | | if (num == 1) |
| | | { |
| | | txtHBarCode_Pack.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HBarCode_Pack")].Value); |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HBarCode_Pack")].Value); |
| | | HSNo = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HSNo")].Value); |
| | | if (HBarCode_Pack == "") |
| | | { |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | cmdHBPack.Enabled = false; |
| | | } |
| | | } |
| | | //æ«æµè½¬å¡æ¾ç¤º |
| | | if (num == 2) |
| | | { |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | } |
| | | //éåæé®æ¾ç¤º |
| | | if (num == 3) |
| | | { |
| | | if (HBarCode_Pack != "" && (HMaterID != DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HMaterID")].Value) |
| | | || HBatchNo != DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value))) |
| | | { |
| | | MessageBox.Show("ææ«ææµè½¬å¡å¯¹åºç©æãæ¹å·ä¸å½åæ£å¨ç»æç©æãæ¹å·ä¸ä¸è´ï¼ä¸åç©æãæ¹å·ä¸å
è®¸ç»æå¨å䏿ä¸ï¼å¦éæ¢ç©æçææ¡ç 请å
ç»æå½åç»æï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | } |
| | | txtHBillNo.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("åæ®å·")].Value); |
| | | txtHDeptName.Tag = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HDeptID")].Value); |
| | | txtHDeptName.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("车é´")].Value); |
| | |
| | | txtHBatchNo.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value); |
| | | txtHCusMaterName.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HCusMaterName")].Value); |
| | | txtHCusModel.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HCusModel")].Value); |
| | | HMaterID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HMaterID")].Value); |
| | | HBatchNo = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value); |
| | | HAuxPropID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HAuxPropID")].Value); |
| | | HUnitID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HUnitID")].Value); |
| | | HWhID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HWhID")].Value); |
| | |
| | | string HItemID = ""; |
| | | string HBarCode = ""; |
| | | string HBarCode2 = ""; |
| | | long HSNo_Temp = HSNo; |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | HItemID = HItemID + "," + DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value.ToString()); |
| | |
| | | { |
| | | HRemark = HRemark + "ã" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | } |
| | | //æ´æ°å½åå·²ç»æä»¶æ° |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != "" |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) != "æçæ¡ç ") |
| | | { |
| | | HSNo = HSNo - 1; |
| | | } |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "æçæ¡ç ") |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å
许ä½åºï¼", "æç¤º"); |
| | | return; |
| | | if (DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value)) |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å·²ç»æçæå¯¹åºç»æåï¼ä¸å
许ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | else if (HSNo > 0) |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å½åæçæ¡ç ä¸å·²çæå¯¹åºæ¡ç ï¼ä¸å
许ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | } |
| | | } |
| | | if (HRemark != "") |
| | | { |
| | | HSNo = HSNo_Temp; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼"+ HRemark.Remove(0, 1)+" å·²ä½åºï¼ä¸å
许éå¤ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | |
| | | catch (Exception e2) |
| | | { |
| | | oCn.RollBack(); |
| | | HSNo = HSNo_Temp; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | MessageBox.Show("ä½åºæ¡ç 失败ï¼" + e2.Message, "æç¤º"); |
| | | return; |
| | | } |
| | | //å·æ°ç§°éè®°å½åè¡¨ä¿¡æ¯ |
| | | BarCode_Display(); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | else |
| | | { |
| | | txtHBarCode_Pack.Text = ""; |
| | | this.lblSNo.Text = ""; |
| | | cmdHBPack.Enabled = true; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HBarCode.Remove(0, 1) + " ä½åºæåï¼", "æç¤º"); |
| | | } |
| | | } |
| | |
| | | string HItemID = ""; |
| | | string HBarCode = ""; |
| | | string HBarCode2 = ""; |
| | | string HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | long HSNo_Temp = HSNo; |
| | | bool HFlag = false; |
| | | |
| | | //çé¢ä¸ä¸ºæªå¯ç¨ç»æç¶æ |
| | | if (HBarCode_Pack == "") |
| | | { |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | //夿æ¡ç æ¯å¦ä¸ºæçæ¡ç ï¼æªçæç»æåï¼å·²ä½åºç¶æï¼çé¢ä¸ä¸ºæªç»æç¶æ |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "æçæ¡ç " |
| | | && DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value) == false |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("ä½åºæ è®°")].Value) != "" |
| | | ) |
| | | { |
| | | HFlag = true; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | HItemID = HItemID + "," + DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value.ToString()); |
| | |
| | | { |
| | | HRemark = HRemark + "ã" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | } |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "æçæ¡ç ") |
| | | |
| | | //æ¡ç ä¸ºç»ææ¡ç |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != "") |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != "" |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != HBarCode_Pack) |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " å·²çæå¯¹åºç»æåï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | //å·²ä¸ä¼ çæç»æå |
| | | if (DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value)) |
| | | { |
| | | |
| | | } |
| | | //æªä¸ä¼ çæç»æå |
| | | else |
| | | { |
| | | //æ¡ç å¯¹åºææ¡ç åçé¢ä¸çææ¡ç ä¸è´ |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack) |
| | | { |
| | | //æ´æ°å½åå·²ç»æä»¶æ° |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) != "æçæ¡ç ") |
| | | { |
| | | HSNo = HSNo + 1; |
| | | } |
| | | |
| | | } |
| | | //æ¡ç å¯¹åºææ¡ç åçé¢ä¸çææ¡ç ä¸ä¸è´ |
| | | else |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " å¯¹åºææ¡ç ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) + " å·²çæç»æåï¼æå·²ä½åºï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (HRemark != "") |
| | | { |
| | | HSNo = HSNo_Temp; |
| | | if(HFlag) |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HRemark.Remove(0, 1) + " æªä½åºï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | |
| | | ",0,0,'',0,'',0" + |
| | | ",HSTOCKORGID,HSTOCKORGID,HSTOCKORGID,'','ç§°éå
¥åºçæ-åä½åº','2'" + |
| | | ",0,0,'',0" + |
| | | "from Gy_BarCodeBill with(nolock) where HItemID in (" + HItemID + ")" |
| | | "from Gy_BarCodeBill with(nolock) where HItemID in (" + HItemID + ") and HBarCodeType='å¯ä¸æ¡ç ' " |
| | | ); |
| | | |
| | | //åå
¥ç³»ç»æ¥å¿ |
| | |
| | | catch (Exception e2) |
| | | { |
| | | oCn.RollBack(); |
| | | HSNo = HSNo_Temp; |
| | | if (HFlag) |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | MessageBox.Show("åä½åºæ¡ç 失败ï¼" + e2.Message, "æç¤º"); |
| | | return; |
| | | } |
| | | //å·æ°ç§°éè®°å½åè¡¨ä¿¡æ¯ |
| | | BarCode_Display(); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | cmdHBPack.Enabled = false; |
| | | } |
| | | else |
| | | { |
| | | txtHBarCode_Pack.Text = ""; |
| | | this.lblSNo.Text = ""; |
| | | cmdHBPack.Enabled = true; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HBarCode.Remove(0, 1) + " åä½åºæåï¼", "æç¤º"); |
| | | } |
| | | } |
| | |
| | | { |
| | | return; |
| | | } |
| | | HSNo = 0; |
| | | SavePackBarCode(); |
| | | BarCode_Display(); |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | grdMain.Rows[0].Selected = true; |
| | | |
| | | txtHBarCode_Pack.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | cmdHBPack.Enabled = false; |
| | | |
| | | sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); |
| | | //èªå¨æå° |
| | | if (chkHDYFlag.Checked == true) |
| | | { |
| | | //æå°æ¡ç |
| | | Sub_SetReport("æçæ¡ç "); |
| | | Report.Print(false); |
| | | Thread.Sleep(1000); |
| | | } |
| | | else |
| | | //if (chkHDYFlag.Checked == true) |
| | | //{ |
| | | // //æå°æ¡ç |
| | | // Sub_SetReport("æçæ¡ç "); |
| | | // Report.Print(false); |
| | | // Thread.Sleep(1000); |
| | | //} |
| | | //else |
| | | { |
| | | //éæ©æå°æ¨¡æ¿ |
| | | BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); |
| | |
| | | if (HInterID == 0 || HBillNo == "") |
| | | { |
| | | MessageBox.Show("è·åæ¡ç 对åºåæ®IDæåæ®å·å¤±è´¥ï¼è¯·éæ°å·æ°çé¢ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | if (HProcessExchangeInterID == 0) |
| | | { |
| | | MessageBox.Show("请å
æ«ææµè½¬å¡å·ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | return true; |
| | |
| | | TM = sTMNumber + LSH2; |
| | | |
| | | string HBarCode = ""; |
| | | string HBarCodeType = "æçæ¡ç "; |
| | | string HBarCodeType = ""; |
| | | string HMaterID = ""; //ç©æå
ç |
| | | string HBatchNo = ""; //æ¹æ¬¡ |
| | | string HMaterName = ""; |
| | | string HMaterModel = ""; |
| | | string HProcessExchangeBillNo = ""; |
| | | string HCusMaterName = ""; //客æ·ç©æåç§° |
| | | string HCusModel = ""; //客æ·è§æ ¼åå· |
| | | |
| | | HBarCode = TM; |
| | | HBarCodeType = ""; |
| | | HBarCodeType = "æçæ¡ç "; |
| | | HMaterID = DBUtility.ClsPub.isStrNull(txtHMaterNumber.Tag); |
| | | HBatchNo = DBUtility.ClsPub.isStrNull(txtHBatchNo.Text); |
| | | HMaterName = DBUtility.ClsPub.isStrNull(txtHMaterName.Text); |
| | | HMaterModel = DBUtility.ClsPub.isStrNull(txtHMaterModel.Text); |
| | | HProcessExchangeBillNo = DBUtility.ClsPub.isStrNull(txtHBillNo.Text); |
| | | HCusMaterName = DBUtility.ClsPub.isStrNull(txtHCusMaterName.Text); |
| | | HCusModel = DBUtility.ClsPub.isStrNull(txtHCusModel.Text); |
| | | |
| | | try |
| | | { |
| | |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate,HMaterialJQty,HMaterialMQty,HNowQty " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag " + |
| | | ",HOrderInterID,HOrderEntryID,HOrderBillNo,HCustomQty1,HMaterialModel,HCusModel " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo,HPackflag " + |
| | | ") Values (" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "',0,0,1,'" + HBarCode + "'" |
| | | + ",'',0,0,'" + HMaker + "',getdate(),0,1" |
| | | + ",0,0,'','',''" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + ",1,'" + HBarCode + "'" |
| | | + ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + HMaker + "',getdate(),0,1" |
| | | + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "',''" |
| | | + ",1,0,0,0,0,''" |
| | | + ", 0,'',getdate(),'','" + sDate + "',0,0,0" |
| | | + ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0" |
| | | + ", " + HProcessExchangeInterID.ToString() + ",0,'',0,'',''" |
| | | + ",'','','',0,'','','1')"); |
| | | + ", " + HProcessExchangeInterID.ToString() + ",0,'" + HProcessExchangeBillNo + "',0,'" + HCusMaterName + "','" + HCusModel + "'" |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1',0)"); |
| | | |
| | | //åå¡«æå¤§æµæ°´å· |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 "); |
| | |
| | | #region //ç»æç»æ |
| | | private void cmdHEPack_Click(object sender, EventArgs e) |
| | | { |
| | | string HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | |
| | | //çæç»æåå夿 |
| | | if(HBarCode_Pack=="") |
| | | { |
| | |
| | | for (int i = 0; i < grdMain.RowCount; i++) |
| | | { |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "å¯ä¸æ¡ç " |
| | | && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack) |
| | | && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack |
| | | && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("ä½åºæ è®°")].Value) == "") |
| | | { |
| | | b = true; |
| | | break; |
| | |
| | | ",HAuxPropID,HBatchNo,HMTONo" + |
| | | ",HSourceID,HEquipID,HGroupID,HWorkerID,HStatus" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType) " + |
| | | " select " + HPUInterID.ToString() + ",HItemID,'0,0,''" + |
| | | " select " + HPUInterID.ToString() + ",HItemID,0,0,''" + |
| | | ",HMaterID,HUnitID,HQty,HBarCode,HBarCode_Pack,getdate()" + |
| | | ",HAuxPropID,HBatchNo,HMTONo" + |
| | | ",0,0,0,0,0" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" + |
| | | "from Gy_BarCodeBill with(nolock) where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0" |
| | | " from Gy_BarCodeBill with(nolock) where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0 and HBarCodeType='å¯ä¸æ¡ç ' " |
| | | ); |
| | | |
| | | //åå¡«æ¡ç æ¡£æ¡ç»ææ è®° |
| | | oCn.RunProc("update Gy_BarCodeBill set HPackflag=1 where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | MessageBox.Show("çæçäº§ç»æåï¼" + HPUBillNo + " æåï¼", "æç¤º"); |
| | | |
| | | txtHBarCode_Pack.Text = ""; |
| | | HBarCode_Pack = ""; |
| | | cmdHBPack.Enabled = true; |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | BarCode_Display(); |
| | | oCn.Commit(); |
| | | return; |
| | | } |
| | |
| | | { |
| | | this.components = new System.ComponentModel.Container(); |
| | | System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Kf_WeighToBarCode)); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | this.Tool = new System.Windows.Forms.ToolStrip(); |
| | | this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator(); |
| | | this.mrlk = new System.Windows.Forms.ToolStripButton(); |
| | |
| | | this.label4 = new System.Windows.Forms.Label(); |
| | | this.txtHMaterNumber = new System.Windows.Forms.TextBox(); |
| | | this.gbUp = new System.Windows.Forms.GroupBox(); |
| | | this.lblSNo = new System.Windows.Forms.Label(); |
| | | this.label18 = new System.Windows.Forms.Label(); |
| | | this.txtHBarCode_Pack = new System.Windows.Forms.TextBox(); |
| | | this.cmdHEPack = new System.Windows.Forms.Button(); |
| | | this.cmdHBPack = new System.Windows.Forms.Button(); |
| | | this.textBox_COM = new System.Windows.Forms.TextBox(); |
| | | this.label_COM = new System.Windows.Forms.Label(); |
| | | this.button_OpenCom = new System.Windows.Forms.Button(); |
| | |
| | | this.å³ä¾§ = new System.Windows.Forms.Panel(); |
| | | this.timer2 = new System.Windows.Forms.Timer(this.components); |
| | | this.backgroundWorker1 = new System.ComponentModel.BackgroundWorker(); |
| | | this.cmdHBPack = new System.Windows.Forms.Button(); |
| | | this.cmdHEPack = new System.Windows.Forms.Button(); |
| | | this.label18 = new System.Windows.Forms.Label(); |
| | | this.txtHBarCode_Pack = new System.Windows.Forms.TextBox(); |
| | | this.Tool.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit(); |
| | | this.gbUp.SuspendLayout(); |
| | |
| | | this.grdMain.AllowUserToDeleteRows = false; |
| | | this.grdMain.BackgroundColor = System.Drawing.SystemColors.ControlLightLight; |
| | | this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
| | | dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle3.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdMain.DefaultCellStyle = dataGridViewCellStyle3; |
| | | dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle1.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdMain.DefaultCellStyle = dataGridViewCellStyle1; |
| | | this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill; |
| | | this.grdMain.Location = new System.Drawing.Point(3, 3); |
| | | this.grdMain.Margin = new System.Windows.Forms.Padding(0); |
| | |
| | | // gbUp |
| | | // |
| | | this.gbUp.BackColor = System.Drawing.Color.Transparent; |
| | | this.gbUp.Controls.Add(this.lblSNo); |
| | | this.gbUp.Controls.Add(this.label18); |
| | | this.gbUp.Controls.Add(this.txtHBarCode_Pack); |
| | | this.gbUp.Controls.Add(this.cmdHEPack); |
| | |
| | | this.gbUp.TabIndex = 58; |
| | | this.gbUp.TabStop = false; |
| | | // |
| | | // lblSNo |
| | | // |
| | | this.lblSNo.AutoSize = true; |
| | | this.lblSNo.Font = new System.Drawing.Font("å®ä½", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.lblSNo.ForeColor = System.Drawing.Color.Red; |
| | | this.lblSNo.Location = new System.Drawing.Point(843, 158); |
| | | this.lblSNo.Name = "lblSNo"; |
| | | this.lblSNo.Size = new System.Drawing.Size(20, 19); |
| | | this.lblSNo.TabIndex = 334; |
| | | this.lblSNo.Text = "."; |
| | | // |
| | | // label18 |
| | | // |
| | | this.label18.AutoSize = true; |
| | | this.label18.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.label18.ForeColor = System.Drawing.Color.Black; |
| | | this.label18.Location = new System.Drawing.Point(638, 116); |
| | | this.label18.Name = "label18"; |
| | | this.label18.Size = new System.Drawing.Size(53, 12); |
| | | this.label18.TabIndex = 332; |
| | | this.label18.Text = "æçæ¡ç "; |
| | | // |
| | | // txtHBarCode_Pack |
| | | // |
| | | this.txtHBarCode_Pack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.txtHBarCode_Pack.ImeMode = System.Windows.Forms.ImeMode.NoControl; |
| | | this.txtHBarCode_Pack.Location = new System.Drawing.Point(693, 112); |
| | | this.txtHBarCode_Pack.Name = "txtHBarCode_Pack"; |
| | | this.txtHBarCode_Pack.ReadOnly = true; |
| | | this.txtHBarCode_Pack.Size = new System.Drawing.Size(128, 21); |
| | | this.txtHBarCode_Pack.TabIndex = 333; |
| | | // |
| | | // cmdHEPack |
| | | // |
| | | this.cmdHEPack.BackColor = System.Drawing.Color.White; |
| | | this.cmdHEPack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdHEPack.Location = new System.Drawing.Point(847, 89); |
| | | this.cmdHEPack.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdHEPack.Name = "cmdHEPack"; |
| | | this.cmdHEPack.Size = new System.Drawing.Size(86, 44); |
| | | this.cmdHEPack.TabIndex = 331; |
| | | this.cmdHEPack.Text = "ç»æç»æ"; |
| | | this.cmdHEPack.UseVisualStyleBackColor = false; |
| | | this.cmdHEPack.Click += new System.EventHandler(this.cmdHEPack_Click); |
| | | // |
| | | // cmdHBPack |
| | | // |
| | | this.cmdHBPack.BackColor = System.Drawing.Color.White; |
| | | this.cmdHBPack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdHBPack.Location = new System.Drawing.Point(847, 28); |
| | | this.cmdHBPack.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdHBPack.Name = "cmdHBPack"; |
| | | this.cmdHBPack.Size = new System.Drawing.Size(86, 44); |
| | | this.cmdHBPack.TabIndex = 330; |
| | | this.cmdHBPack.Text = "å¼å§ç»æ"; |
| | | this.cmdHBPack.UseVisualStyleBackColor = false; |
| | | this.cmdHBPack.Click += new System.EventHandler(this.cmdHBPack_Click); |
| | | // |
| | | // textBox_COM |
| | | // |
| | | this.textBox_COM.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | |
| | | this.button_OpenCom.BackColor = System.Drawing.Color.White; |
| | | this.button_OpenCom.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.button_OpenCom.Location = new System.Drawing.Point(429, 222); |
| | | this.button_OpenCom.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.button_OpenCom.Margin = new System.Windows.Forms.Padding(2); |
| | | this.button_OpenCom.Name = "button_OpenCom"; |
| | | this.button_OpenCom.Size = new System.Drawing.Size(86, 32); |
| | | this.button_OpenCom.TabIndex = 327; |
| | |
| | | this.button_getHWeight.BackColor = System.Drawing.Color.White; |
| | | this.button_getHWeight.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.button_getHWeight.Location = new System.Drawing.Point(322, 222); |
| | | this.button_getHWeight.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.button_getHWeight.Margin = new System.Windows.Forms.Padding(2); |
| | | this.button_getHWeight.Name = "button_getHWeight"; |
| | | this.button_getHWeight.Size = new System.Drawing.Size(86, 32); |
| | | this.button_getHWeight.TabIndex = 326; |
| | |
| | | // |
| | | this.chkHDYFlag.AutoSize = true; |
| | | this.chkHDYFlag.Location = new System.Drawing.Point(558, 236); |
| | | this.chkHDYFlag.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.chkHDYFlag.Margin = new System.Windows.Forms.Padding(2); |
| | | this.chkHDYFlag.Name = "chkHDYFlag"; |
| | | this.chkHDYFlag.Size = new System.Drawing.Size(72, 16); |
| | | this.chkHDYFlag.TabIndex = 316; |
| | |
| | | this.cmdFZF.BackColor = System.Drawing.Color.White; |
| | | this.cmdFZF.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdFZF.Location = new System.Drawing.Point(729, 222); |
| | | this.cmdFZF.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmdFZF.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdFZF.Name = "cmdFZF"; |
| | | this.cmdFZF.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdFZF.TabIndex = 157; |
| | |
| | | this.cmdZF.BackColor = System.Drawing.Color.White; |
| | | this.cmdZF.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdZF.Location = new System.Drawing.Point(635, 222); |
| | | this.cmdZF.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmdZF.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdZF.Name = "cmdZF"; |
| | | this.cmdZF.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdZF.TabIndex = 156; |
| | |
| | | this.cmdSave.BackColor = System.Drawing.Color.White; |
| | | this.cmdSave.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdSave.Location = new System.Drawing.Point(209, 222); |
| | | this.cmdSave.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmdSave.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdSave.Name = "cmdSave"; |
| | | this.cmdSave.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdSave.TabIndex = 139; |
| | |
| | | this.cmdSourceBillNo.BackColor = System.Drawing.Color.White; |
| | | this.cmdSourceBillNo.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdSourceBillNo.Location = new System.Drawing.Point(102, 222); |
| | | this.cmdSourceBillNo.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmdSourceBillNo.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdSourceBillNo.Name = "cmdSourceBillNo"; |
| | | this.cmdSourceBillNo.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdSourceBillNo.TabIndex = 138; |
| | |
| | | this.cmbHBarCodeType.Items.AddRange(new object[] { |
| | | "å¯ä¸æ¡ç "}); |
| | | this.cmbHBarCodeType.Location = new System.Drawing.Point(693, 28); |
| | | this.cmbHBarCodeType.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmbHBarCodeType.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmbHBarCodeType.Name = "cmbHBarCodeType"; |
| | | this.cmbHBarCodeType.Size = new System.Drawing.Size(128, 20); |
| | | this.cmbHBarCodeType.TabIndex = 139; |
| | |
| | | this.dtpHDate.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.dtpHDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; |
| | | this.dtpHDate.Location = new System.Drawing.Point(303, 28); |
| | | this.dtpHDate.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.dtpHDate.Margin = new System.Windows.Forms.Padding(2); |
| | | this.dtpHDate.Name = "dtpHDate"; |
| | | this.dtpHDate.Size = new System.Drawing.Size(128, 21); |
| | | this.dtpHDate.TabIndex = 100; |
| | |
| | | this.grdSub.AllowUserToDeleteRows = false; |
| | | this.grdSub.BackgroundColor = System.Drawing.SystemColors.ControlLightLight; |
| | | this.grdSub.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
| | | dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle4.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle4.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle4.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdSub.DefaultCellStyle = dataGridViewCellStyle4; |
| | | dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle2.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdSub.DefaultCellStyle = dataGridViewCellStyle2; |
| | | this.grdSub.Dock = System.Windows.Forms.DockStyle.Fill; |
| | | this.grdSub.Location = new System.Drawing.Point(0, 73); |
| | | this.grdSub.Margin = new System.Windows.Forms.Padding(0); |
| | |
| | | this.tabPage1.Controls.Add(this.grdMain); |
| | | this.tabPage1.Location = new System.Drawing.Point(4, 22); |
| | | this.tabPage1.Name = "tabPage1"; |
| | | this.tabPage1.Padding = new System.Windows.Forms.Padding(3, 3, 3, 3); |
| | | this.tabPage1.Padding = new System.Windows.Forms.Padding(3); |
| | | this.tabPage1.Size = new System.Drawing.Size(984, 340); |
| | | this.tabPage1.TabIndex = 0; |
| | | this.tabPage1.Text = "ç§°éè®°å½"; |
| | |
| | | this.cmdOK.Cursor = System.Windows.Forms.Cursors.Default; |
| | | this.cmdOK.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdOK.Location = new System.Drawing.Point(189, 33); |
| | | this.cmdOK.Margin = new System.Windows.Forms.Padding(2, 2, 2, 2); |
| | | this.cmdOK.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdOK.Name = "cmdOK"; |
| | | this.cmdOK.Size = new System.Drawing.Size(55, 27); |
| | | this.cmdOK.TabIndex = 150; |
| | |
| | | // timer2 |
| | | // |
| | | this.timer2.Tick += new System.EventHandler(this.timer2_Tick); |
| | | // |
| | | // cmdHBPack |
| | | // |
| | | this.cmdHBPack.BackColor = System.Drawing.Color.White; |
| | | this.cmdHBPack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdHBPack.Location = new System.Drawing.Point(847, 40); |
| | | this.cmdHBPack.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdHBPack.Name = "cmdHBPack"; |
| | | this.cmdHBPack.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdHBPack.TabIndex = 330; |
| | | this.cmdHBPack.Text = "å¼å§ç»æ"; |
| | | this.cmdHBPack.UseVisualStyleBackColor = false; |
| | | this.cmdHBPack.Click += new System.EventHandler(this.cmdHBPack_Click); |
| | | // |
| | | // cmdHEPack |
| | | // |
| | | this.cmdHEPack.BackColor = System.Drawing.Color.White; |
| | | this.cmdHEPack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.cmdHEPack.Location = new System.Drawing.Point(847, 94); |
| | | this.cmdHEPack.Margin = new System.Windows.Forms.Padding(2); |
| | | this.cmdHEPack.Name = "cmdHEPack"; |
| | | this.cmdHEPack.Size = new System.Drawing.Size(86, 32); |
| | | this.cmdHEPack.TabIndex = 331; |
| | | this.cmdHEPack.Text = "ç»æç»æ"; |
| | | this.cmdHEPack.UseVisualStyleBackColor = false; |
| | | this.cmdHEPack.Click += new System.EventHandler(this.cmdHEPack_Click); |
| | | // |
| | | // label18 |
| | | // |
| | | this.label18.AutoSize = true; |
| | | this.label18.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.label18.ForeColor = System.Drawing.Color.Black; |
| | | this.label18.Location = new System.Drawing.Point(638, 116); |
| | | this.label18.Name = "label18"; |
| | | this.label18.Size = new System.Drawing.Size(53, 12); |
| | | this.label18.TabIndex = 332; |
| | | this.label18.Text = "æçæ¡ç "; |
| | | // |
| | | // txtHBarCode_Pack |
| | | // |
| | | this.txtHBarCode_Pack.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | this.txtHBarCode_Pack.ImeMode = System.Windows.Forms.ImeMode.NoControl; |
| | | this.txtHBarCode_Pack.Location = new System.Drawing.Point(693, 112); |
| | | this.txtHBarCode_Pack.Name = "txtHBarCode_Pack"; |
| | | this.txtHBarCode_Pack.ReadOnly = true; |
| | | this.txtHBarCode_Pack.Size = new System.Drawing.Size(128, 21); |
| | | this.txtHBarCode_Pack.TabIndex = 333; |
| | | // |
| | | // Kf_WeighToBarCode |
| | | // |
| | |
| | | private System.Windows.Forms.Button cmdHBPack; |
| | | private System.Windows.Forms.Label label18; |
| | | private System.Windows.Forms.TextBox txtHBarCode_Pack; |
| | | private System.Windows.Forms.Label lblSNo; |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// è¿åå·¥èºå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_TechnologyParameter/list1")] |
| | | [HttpGet] |
| | | public object list1(string sWhere, string user, string Organization) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Gy_TechnologyParameter", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
| | | |
| | | string HEquipNumber = dic["HEquipNumber"].ToString();//è®¾å¤ |
| | | string HProcName = dic["HProcName"].ToString(); |
| | | string HMaterName = dic["HMaterName"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Gy_TechnologyParameterList '" + HEquipNumber + "','" + HProcName + "','" + HMaterName + "','" + 2 + "'", "h_p_Gy_TechnologyParameterList"); |
| | | |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | |
| | | ",HShiftsID=" + HShiftsID + |
| | | ",HBackWorkByMaterQty=" + HBackWorkByMaterQty + |
| | | ",HMouldID=" + HMouldID + |
| | | ",HGroupID=" + HGroupID + |
| | | " where HInterID=" + HInterID); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥åºåºç«åæ®:" + HBillNo); |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region 䏿¨è´¨éæ±æ¥åæ¶è¿åå·¥åºåºç«æ±æ¥åä¿¡æ¯ |
| | | [Route("Cj_StationOutBill/PushDownBackInfo")] |
| | | [HttpGet] |
| | | public object PushDownBackInfo(string linterid, string user) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_StationOutBill_PushDownBackInfo where hmainid in (" + linterid + ")", "h_v_Sc_StationOutBill_PushDownBackInfo"); |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0 && ds != null) |
| | | { |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.list = columnNameList; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ°æ®"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | string sql = string.Format(@"select æµæ°´å· HProcNo,HProcID,å·¥åºä»£ç HProcNumber,å·¥åºåç§° HProcName,å 工说æ HWorkRemark,HCenterID,å·¥ä½ä¸å¿ä»£ç HCenterNumber, |
| | | å·¥ä½ä¸å¿ HCenterName,HSupID,ä¾åºå代ç HSupNumber,ä¾åºå HSupName,isEntrust HSupFlag,è®¡åæ°é HQty,å å·¥åä»· HOutPrice, 表ä½å¤æ³¨ HRemark, |
| | | è¿ç«å
³èæ°é HRelationQty_In,åºç«å
³èæ°é HRelationQty_Out,å§å¤å·¥åæ°é HRelationQty_WWOrder,ä¸åæ ¼æ°é HRelationQty_Bad,è¶
颿¯ä¾ HOverRate, |
| | | è¯ç HPassRate,累计è¯ç HSumPassRate,å¾çº¸ç¼å· HPicNum,æ¬å·¥åºç¡®è®¤è®°å½ HProcCheckNote,å·¥èºåæ° HTechnologyParameter,HDeptID, |
| | | è¯ç HPassRate,累计è¯ç HSumPassRate,å¾çº¸ç¼å· HPicNum,æ¬å·¥åºç¡®è®¤è®°å½ HProcCheckNote,å·¥èºåæ° HTechnologyParameter,HDeptID,HSourceID, |
| | | å 工车é´ä»£ç HDeptNumber,å å·¥è½¦é´ HDeptName,åºç«æ¥åºå
³èæ°é HRelationQty_OutBad,SNè¿ç«æ§å¶ HSNCtrl,HRoutingInterID HRoutingBillMainID,HRoutingEntryID HRoutingBillEntryID |
| | | from h_v_Sc_ProcessExchangeBillQuerySub"); |
| | | ds = oCN.RunProcReturn(sql+ " where hmainid="+ HInterID + " order by cast(æµæ°´å· as int) ", "h_v_Sc_ProcessExchangeBillQuerySub"); |
| | |
| | | if (oSystemParameter.ShowBill(ref Ret)) |
| | | { |
| | | //夿客æ·ä¸ºé¾å±±æ±½é
|
| | | if (oSystemParameter.omodel.WMS_CampanyName == "é¾å±±æ±½é
") |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "é¾å±±æ±½é
" || oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢å·¥ä»·æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_CheckProcPrice", 1, false, UserName)) |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(" select * from h_v_Sc_ProcessExchangeBillList where 1=1 and æ¥æ>=DATEADD(MONTH,-2,GETDATE()) order by åæ®å· desc,hsubid", "h_v_Sc_ProcessExchangeBillList"); |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessExchangeBillList where 1=1 order by åæ®å· desc,hsubid", "h_v_Sc_ProcessExchangeBillList"); |
| | | } |
| | | else |
| | | { |
New file |
| | |
| | | using DBUtility; |
| | | using Model; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Web; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | using System.Threading.Tasks; |
| | | using DLL; |
| | | |
| | | namespace WebAPI.Controllers.人äºç®¡ç.人åå±¥å |
| | | { |
| | | public class HR_PersonnelResumeController : ApiController |
| | | { |
| | | |
| | | private json objJsonResult = new json(); |
| | | public DataSet ds = new DataSet(); |
| | | public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | |
| | | #region 人åå±¥åæ¥è¡¨ |
| | | |
| | | /// <summary> |
| | | /// 人åå±¥åæ¥è¡¨ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("HR_PersonnelResumeController/GetHR_PersonnelResumeList")] |
| | | [HttpGet] |
| | | public object GetHR_PersonnelResumeList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | |
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
| | | |
| | | string HNumber = dic["HNumber"].ToString();//èå代ç |
| | | string HName = dic["HName"].ToString();//èå |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_HR_PersonnelResumeReport '" + HNumber.ToString() + "','" + HName + "'", "h_p_HR_PersonnelResumeReport"); |
| | | List<object> columnNameList = new List<object>(); |
| | | // éåææè¡¨ |
| | | foreach (DataTable table in ds.Tables) |
| | | { |
| | | List<object> tableColumnList = new List<object>(); |
| | | |
| | | // æ·»å åå |
| | | foreach (DataColumn col in table.Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | tableColumnList.Add(JsonConvert.DeserializeObject(ColmString)); |
| | | } |
| | | |
| | | // å°æ¯ä¸ªè¡¨çååå表添å å°æ»ååå表 |
| | | columnNameList.Add(new { TableName = table.TableName, Columns = tableColumnList }); |
| | | } |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æåï¼"; |
| | | objJsonResult.data = ds; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | //} |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¿åæ¥è¡¨ä¿¡æ¯å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region è´¨éæ¨¡å å
¨ç¨è´¨é追溯 æ ¹æ®å
¨ç¨è¿½æº¯æ¥è¡¨ æ³ è·åç©æ+æµè½¬å¡+设å¤+å·¥åº |
| | | |
| | | [Route("QC_CustomerAppealReport/Get_EquipICMOTechParamList")] |
| | | [HttpGet] |
| | | public object Get_EquipICMOTechParamList(string linterid, string user) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | ds = oCN.RunProcReturn(@"select a.HProcExchBillNo,g.HEquipFileNumber,g.HName 设å¤åç§°,b.HName ç©æåç§°,h.HName å·¥åºåç§° from SB_EquipICMOTechParamBillMain a left join Gy_Material b on a.HMaterID = b.HItemID |
| | | left join Gy_Source e on a.HSourceID = e.HItemID left join Gy_EquipFileBillMain g on a.HEquipID = g.HInterID left join Gy_Process h on a.HProcID = h.HItemID", "SB_EquipICMOTechParamBillMain"); |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> |
| | | <History>True|2024-08-26T06:17:37.8502046Z;False|2024-08-26T14:16:09.8501361+08:00;True|2024-08-22T11:12:48.4249984+08:00;</History> |
| | | <History>True|2024-10-18T02:44:02.6495536Z;True|2024-10-18T09:55:47.9769914+08:00;True|2024-10-18T09:47:46.6365831+08:00;True|2024-10-18T09:46:40.4036657+08:00;True|2024-10-18T09:44:25.4598960+08:00;True|2024-10-18T09:30:07.6972377+08:00;False|2024-10-18T09:28:18.9251743+08:00;True|2024-10-17T12:13:34.8639685+08:00;True|2024-10-17T12:02:26.5251711+08:00;False|2024-10-17T12:01:31.3822430+08:00;True|2024-10-17T11:49:09.2395208+08:00;False|2024-10-17T11:48:38.0189241+08:00;True|2024-10-16T19:35:29.2047484+08:00;False|2024-10-16T19:32:43.0637947+08:00;True|2024-10-16T11:27:13.1263407+08:00;False|2024-10-16T11:25:49.8688677+08:00;True|2024-10-15T18:26:50.9948482+08:00;False|2024-10-15T18:26:23.6998750+08:00;True|2024-08-26T14:17:37.8502046+08:00;False|2024-08-26T14:16:09.8501361+08:00;True|2024-08-22T11:12:48.4249984+08:00;</History> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.EndpointUtil.dll"> |
| | | <publishTime>04/07/2020 08:33:48</publishTime> |
| | | <publishTime>04/07/2020 16:33:48</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.GatewayDingTalk.dll"> |
| | | <publishTime>04/25/2023 09:49:04</publishTime> |
| | | <publishTime>04/25/2023 17:49:04</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.GatewaySpi.dll"> |
| | | <publishTime>07/31/2024 12:50:30</publishTime> |
| | | <publishTime>07/31/2024 20:50:30</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.OpenApiClient.dll"> |
| | | <publishTime>08/06/2024 10:07:52</publishTime> |
| | | <publishTime>08/06/2024 18:07:52</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.OpenApiUtil.dll"> |
| | | <publishTime>11/22/2022 03:24:18</publishTime> |
| | | <publishTime>11/22/2022 11:24:18</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.SDK.Dingtalk.dll"> |
| | | <publishTime>08/08/2024 11:43:22</publishTime> |
| | | <publishTime>08/08/2024 19:43:22</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.TeaUtil.dll"> |
| | | <publishTime>07/15/2024 12:25:56</publishTime> |
| | | <publishTime>07/15/2024 20:25:56</publishTime> |
| | | </File> |
| | | <File Include="bin/AlibabaCloud.TeaXML.dll"> |
| | | <publishTime>08/03/2022 13:46:08</publishTime> |
| | | <publishTime>08/03/2022 21:46:08</publishTime> |
| | | </File> |
| | | <File Include="bin/Aliyun.Credentials.dll"> |
| | | <publishTime>07/24/2024 02:36:58</publishTime> |
| | | <publishTime>07/24/2024 10:36:58</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.pdb"> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>08/26/2024 14:16:33</publishTime> |
| | | <publishTime>10/18/2024 10:43:43</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>08/26/2024 14:16:33</publishTime> |
| | | <publishTime>10/18/2024 10:43:43</publishTime> |
| | | </File> |
| | | <File Include="bin/BouncyCastle.Crypto.dll"> |
| | | <publishTime>12/17/2020 21:32:28</publishTime> |
| | | <publishTime>12/18/2020 05:32:28</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>08/26/2024 14:16:32</publishTime> |
| | | <publishTime>10/18/2024 10:43:41</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>08/26/2024 14:16:32</publishTime> |
| | | <publishTime>10/18/2024 10:43:41</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/18/2024 10:43:39</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/18/2024 10:43:39</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.Api.dll"> |
| | | <publishTime>03/22/2022 05:17:26</publishTime> |
| | | <publishTime>03/22/2022 13:17:26</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.Api.pdb"> |
| | | <publishTime>03/18/2022 23:39:42</publishTime> |
| | | <publishTime>03/19/2022 07:39:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.dll"> |
| | | <publishTime>03/22/2022 05:17:20</publishTime> |
| | | <publishTime>03/22/2022 13:17:20</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.pdb"> |
| | | <publishTime>03/18/2022 23:39:48</publishTime> |
| | | <publishTime>03/19/2022 07:39:48</publishTime> |
| | | </File> |
| | | <File Include="bin/grpc_csharp_ext.x64.dll"> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | </File> |
| | | <File Include="bin/grpc_csharp_ext.x86.dll"> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | </File> |
| | | <File Include="bin/ICSharpCode.SharpZipLib.dll"> |
| | | <publishTime>05/08/2021 17:08:30</publishTime> |
| | | <publishTime>05/09/2021 01:08:30</publishTime> |
| | | </File> |
| | | <File Include="bin/ICSharpCode.SharpZipLib.pdb"> |
| | | <publishTime>05/08/2021 17:08:30</publishTime> |
| | | <publishTime>05/09/2021 01:08:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>02/08/2023 09:18:13</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="bin/libgrpc_csharp_ext.x64.dylib"> |
| | | <publishTime>03/18/2022 23:38:44</publishTime> |
| | | <publishTime>03/19/2022 07:38:44</publishTime> |
| | | </File> |
| | | <File Include="bin/libgrpc_csharp_ext.x64.so"> |
| | | <publishTime>03/18/2022 23:38:42</publishTime> |
| | | <publishTime>03/19/2022 07:38:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> |
| | | <publishTime>03/18/2015 17:02:50</publishTime> |
| | | <publishTime>03/19/2015 01:02:50</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.CSharp.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Web.Infrastructure.dll"> |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | <publishTime>07/25/2012 19:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/18/2024 10:43:39</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/18/2024 10:43:39</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>09/05/2022 17:03:10</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>03/08/2023 07:09:56</publishTime> |
| | | <publishTime>03/08/2023 15:09:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.dll"> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OOXML.dll"> |
| | | <publishTime>10/23/2021 01:07:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OOXML.pdb"> |
| | | <publishTime>10/23/2021 09:07:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OOXML.pdb"> |
| | | <publishTime>10/23/2021 17:07:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXml4Net.dll"> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXml4Net.pdb"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXmlFormats.dll"> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXmlFormats.pdb"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.pdb"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>08/26/2024 14:16:28</publishTime> |
| | | <publishTime>10/18/2024 10:43:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>08/26/2024 14:16:28</publishTime> |
| | | <publishTime>10/18/2024 10:43:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/18/2024 10:43:38</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/18/2024 10:43:38</publishTime> |
| | | </File> |
| | | <File Include="bin/RestSharp.dll"> |
| | | <publishTime>08/30/2012 22:22:50</publishTime> |
| | | <publishTime>08/31/2012 06:22:50</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/18/2024 10:43:38</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/18/2024 10:43:38</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/15/2015 17:57:08</publishTime> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | </File> |
| | | <File Include="bin/SyntacticSugar.dll"> |
| | | <publishTime>10/18/2024 10:43:06</publishTime> |
| | | </File> |
| | | <File Include="bin/SyntacticSugar.pdb"> |
| | | <publishTime>10/18/2024 10:43:06</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Buffers.dll"> |
| | | <publishTime>07/19/2017 10:01:28</publishTime> |
| | | <publishTime>07/19/2017 18:01:28</publishTime> |
| | | </File> |
| | | <File Include="bin/System.ComponentModel.DataAnnotations.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> |
| | | <publishTime>08/19/2014 10:03:34</publishTime> |
| | | <publishTime>08/19/2014 18:03:34</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Memory.dll"> |
| | | <publishTime>04/17/2019 16:24:34</publishTime> |
| | | <publishTime>04/18/2019 00:24:34</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.Extensions.dll"> |
| | | <publishTime>02/19/2015 20:10:46</publishTime> |
| | | <publishTime>02/20/2015 04:10:46</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.Formatting.dll"> |
| | | <publishTime>11/28/2018 13:00:36</publishTime> |
| | | <publishTime>11/28/2018 21:00:36</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.Primitives.dll"> |
| | | <publishTime>02/19/2015 20:10:46</publishTime> |
| | | <publishTime>02/20/2015 04:10:46</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Runtime.CompilerServices.Unsafe.dll"> |
| | | <publishTime>09/18/2018 19:38:10</publishTime> |
| | | <publishTime>09/19/2018 03:38:10</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Runtime.Serialization.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Cors.dll"> |
| | | <publishTime>11/28/2018 12:58:44</publishTime> |
| | | <publishTime>11/28/2018 20:58:44</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Helpers.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.Cors.dll"> |
| | | <publishTime>11/28/2018 13:01:26</publishTime> |
| | | <publishTime>11/28/2018 21:01:26</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.dll"> |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>09/05/2022 17:03:08</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Optimization.dll"> |
| | | <publishTime>02/11/2014 15:26:04</publishTime> |
| | | <publishTime>02/11/2014 23:26:04</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Razor.dll"> |
| | | <publishTime>01/28/2015 04:02:32</publishTime> |
| | | <publishTime>01/28/2015 12:02:32</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Services.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Deployment.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Razor.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Xml.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/Tea.dll"> |
| | | <publishTime>05/09/2023 02:43:40</publishTime> |
| | | <publishTime>05/09/2023 10:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/TopSdk.dll"> |
| | | <publishTime>08/26/2024 14:16:31</publishTime> |
| | | <publishTime>10/18/2024 10:43:08</publishTime> |
| | | </File> |
| | | <File Include="bin/TopSdk.pdb"> |
| | | <publishTime>08/26/2024 14:16:31</publishTime> |
| | | <publishTime>10/18/2024 10:43:08</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>08/26/2024 14:16:37</publishTime> |
| | | <publishTime>10/18/2024 10:43:31</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>08/26/2024 14:16:37</publishTime> |
| | | <publishTime>10/18/2024 10:43:31</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/17/2013 17:03:52</publishTime> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> |
| | | <publishTime>11/29/2018 13:26:02</publishTime> |
| | | <publishTime>11/29/2018 21:26:02</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> |
| | | <publishTime>11/29/2018 13:26:30</publishTime> |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | </File> |
| | | <File Include="Config/kdapi.config"> |
| | | <publishTime>11/27/2023 09:14:13</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>09/05/2022 17:02:53</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>09/05/2022 17:02:53</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>09/05/2022 17:02:53</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>09/05/2022 17:03:02</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>09/05/2022 17:03:06</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>09/05/2022 17:03:07</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>02/08/2023 09:18:13</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>09/05/2022 17:03:07</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>09/05/2022 17:03:07</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>09/05/2022 17:03:07</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>09/05/2022 17:03:08</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>09/05/2022 17:03:08</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>01/10/2023 17:20:14</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="grpc_csharp_ext.x64.dll"> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | </File> |
| | | <File Include="grpc_csharp_ext.x86.dll"> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>09/05/2022 17:03:09</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="libgrpc_csharp_ext.x64.dylib"> |
| | | <publishTime>03/18/2022 23:38:44</publishTime> |
| | | <publishTime>03/19/2022 07:38:44</publishTime> |
| | | </File> |
| | | <File Include="libgrpc_csharp_ext.x64.so"> |
| | | <publishTime>03/18/2022 23:38:42</publishTime> |
| | | <publishTime>03/19/2022 07:38:42</publishTime> |
| | | </File> |
| | | <File Include="libman.json"> |
| | | <publishTime>07/24/2023 08:56:46</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>09/05/2022 17:03:09</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>08/15/2024 22:03:48</publishTime> |
| | | <publishTime>09/19/2024 09:05:04</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>09/05/2022 17:03:10</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>09/05/2022 17:03:10</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>09/05/2022 17:03:11</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_Mould.datasource"> |
| | | <publishTime>01/24/2024 11:35:26</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>01/24/2024 11:35:25</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.map"> |
| | | <publishTime>05/06/2024 08:56:50</publishTime> |
| | | <publishTime>05/25/2024 09:46:41</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>08/26/2024 14:17:36</publishTime> |
| | | <publishTime>10/15/2024 10:32:48</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectBasisController.cs" /> |
| | | <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectMethodController.cs" /> |
| | | <Compile Include="Controllers\ZLGL\BaseSet\Gy_QualityController.cs" /> |
| | | <Compile Include="Controllers\人äºç®¡ç\人åå±¥å\HR_PersonnelResumeController.cs" /> |
| | | <Compile Include="Controllers\ä»å管ç\Kf_MoveStockBillController.cs" /> |
| | | <Compile Include="Controllers\å质管ç\è´¨éæåº¦ç®æ å\QC_MonthTarGetBillController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Qc_PreventErrMouldCheckBillController.cs" /> |
| | |
| | | <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> |
| | | <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfilewtt.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-API\WebAPI\Properties\PublishProfiles\JFAPI.pubxml</NameOfLastUsedPublishProfile> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>true</UseIISExpress> |
| | | <Use64BitIISExpress /> |
| | |
| | | <IISExpressWindowsAuthentication>disabled</IISExpressWindowsAuthentication> |
| | | <IISExpressUseClassicPipelineMode>false</IISExpressUseClassicPipelineMode> |
| | | <UseGlobalApplicationHostFile /> |
| | | <ProjectView>ShowAllFiles</ProjectView> |
| | | <Controller_SelectedScaffolderID>ApiControllerEmptyScaffolder</Controller_SelectedScaffolderID> |
| | | <Controller_SelectedScaffolderCategoryPath>root/Common/Web API</Controller_SelectedScaffolderCategoryPath> |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <Controller_SelectedScaffolderID>MvcControllerEmptyScaffolder</Controller_SelectedScaffolderID> |
| | | <Controller_SelectedScaffolderCategoryPath>root/Common/MVC/Controller</Controller_SelectedScaffolderCategoryPath> |
| | | </PropertyGroup> |
| | | <ProjectExtensions> |
| | | <VisualStudio> |