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,HProcID" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + |
| | | ") values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | | "," + oSub.HEntryID.ToString() + "" + |
| | |
| | | "','" + oSub.HAddr + "'" + |
| | | ",'" + oSub.HMaker + "'" + |
| | | ",'" + oSub.HMakeDate.ToShortDateString() + "'" + |
| | | "," + oSub.HProcID + |
| | | "," + oSub.HProcID.ToString() + |
| | | "," + oSub.HNowProcID.ToString() + |
| | | ") "; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + |
| | | ",HBarCode,HReportType,HBadProcID" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID" + |
| | | ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + |
| | | ") values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | | "," + oSub.HEntryID.ToString() + "" + |
| | |
| | | ",'" + oSub.HAddr + "'" + |
| | | ",'" + oSub.HMaker + "'" + |
| | | ",'" + oSub.HMakeDate.ToShortDateString() + "'" + |
| | | "," + oSub.HProcID + |
| | | "," + oSub.HProcID.ToString() + |
| | | "," + oSub.HNowProcID.ToString() + |
| | | ") "; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | public Int64 HProcID;// å·¥åº |
| | | public Int64 HSourceID;// çäº§èµæº |
| | | public Int64 HOrgID;// ç»ç» |
| | | public Int64 HDivisionID;// äºä¸é¨ |
| | | } |
| | | } |
| | |
| | | public string HResult; //å¤æç»æ |
| | | public int HGroupID;//çç» |
| | | public int HBadProcID;//çç» |
| | | public int HNowProcID;//å½åå·¥åº |
| | | } |
| | | } |
| | |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | //å·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ï¼å¯ç¨å¤çº§å®¡æ¹è¦æ±æ®é审æ¹ä¸å¯ç¨ |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_EnableMultiLevel") |
| | | { |
| | | omodel.Gy_RoutingBill_EnableMultiLevel = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //=======JIT |
| | | |
| | |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | //å·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ï¼å¯ç¨å¤çº§å®¡æ¹è¦æ±æ®é审æ¹ä¸å¯ç¨ |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_EnableMultiLevel") |
| | | { |
| | | omodel.Gy_RoutingBill_EnableMultiLevel = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | |
| | | public string Gy_RoutingBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Gy_RoutingBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | public string Gy_RoutingBill_SaveAutoLastProc; //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | |
| | | public string Gy_RoutingBill_EnableMultiLevel; //å·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ï¼å¯ç¨å¤çº§å®¡æ¹è¦æ±æ®é审æ¹ä¸å¯ç¨ |
| | | |
| | | ////å·¥åºè¿ç«å |
| | | //public string MES_StationBill_ProcNo; //èªå¨å¹é
æµæ°´å· |
| | |
| | | C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache |
| | | C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll |
| | | C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb |
| | | C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache |
| | |
| | | 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; |
| | | } |
| | | } |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | } |
| | | |
| | | /// <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); |
| | |
| | | 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"); |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | string HInterId = dic["HInterId"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_DotCheckDayList '" + Type + "','" + HInterId + "'", "h_p_DotCheckDayList"); |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½ææ²¡ææ°æ®äº§çï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æ·»å åå |
| | | 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ï¼"; |
| | |
| | | if (HStandard) |
| | | { |
| | | //设置é»è®¤å·¥èºè·¯çº¿ |
| | | oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID); //设置é»è®¤å·¥èºè·¯çº¿ |
| | | oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + user + "'"); |
| | | } |
| | | |
| | | //夿æ¯å¦éå¤å·¥åºå· |
| | |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterIDè¿è¡ç±»åçè½¬æ¢ |
| | | DAL.ClsGy_RoutingBill oBill = new DAL.ClsGy_RoutingBill(); //å®ä¾ååæ®æä½ç±»ï¼ç¨äºè¿è¡ç¸å
³æä½ |
| | | //è·åç³»ç»åæ°å¤æå·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ç¦ç¨ |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn) == true) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //ç³»ç»åæ° æªå¯ç¨èªå¨å®¡æ ¸ |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å·¥èºè·¯çº¿æªå¯ç¨å¤çº§å®¡æ¹ç¦ç¨"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //æ ¹æ®HInterIDè·åè¯¥åæ®çæ°æ® |
| | | { |
| | | if (oBill.omodel.HBillStatus != 6) |
| | |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //è·åç³»ç»åæ°å¤æå·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ç¦ç¨ |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn) == true) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //ç³»ç»åæ° æªå¯ç¨èªå¨å®¡æ ¸ |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å·¥èºè·¯çº¿æªå¯ç¨å¤çº§å®¡æ¹ç¦ç¨"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //HInterIDæ°æ®å¤æ |
| | | if (HInterID <= 0) |
| | |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //è·åç³»ç»åæ°å¤æå·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ç¦ç¨ |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn) == true) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "N") //ç³»ç»åæ° æªå¯ç¨èªå¨å®¡æ ¸ |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å·¥èºè·¯çº¿æªå¯ç¨å¤çº§å®¡æ¹ç¦ç¨"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //HInterIDæ°æ®å¤æ |
| | | if (HInterID <= 0) |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥èºè·¯çº¿ å
³éå
¶å®åæ® |
| | | [Route("Gy_Routing/CloseOther")] |
| | | [HttpGet] |
| | | public object CloseOther(int HInterID, string CurUserName) |
| | | { |
| | | DBUtility.ClsPub.CurUserName = CurUserName; |
| | | try |
| | | { |
| | | //夿æ¯å¦æå
³éå
¶å®æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_CloseOther", 1, false, CurUserName)) |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å·¥èºè·¯çº¿æ æéå
³éå
¶å®åæ®!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //夿忮æ¯å¦åå¨ |
| | | DataSet ds; |
| | | string sql = "select * from Gy_RoutingBillMain where HinterID = " + HInterID; |
| | | ds = oCN.RunProcReturn(sql, "Gy_RoutingBillMain"); |
| | | if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | //if (!(ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "åæ®æªå®¡æ ¸!ä¸å¯ä»¥è¢«å¯ç¨ä¸ºè¯¥ç©æçé»è®¤å·¥èºè·¯çº¿!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "åæ®ä¸åå¨ï¼æ£æ¥è¯¥åæ®æ¯å¦å·²ç»è¢«å é¤!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //å·æ°é»è®¤å·¥èºè·¯çº¿ |
| | | oCN.RunProc("exec h_p_Gy_RoutingBillClose " + HInterID + ",'" + CurUserName + "'"); |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = CodeConstant.SUCCEED; |
| | | objJsonResult.count = CountConstant.SUCCEED; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å
³éå
¶å®å¤±è´¥å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å¾
å¤±ææ¥è¡¨ |
| | | /// <summary> |
| | | /// å¾
å¤±ææ¥è¡¨ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_RoutingBill/getInvalidityReport")] |
| | | [HttpGet] |
| | | public object getInvalidityReport(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å¾
å¤±ææ¥è¡¨æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where å®é¢ç±»å = '临æ¶å®é¢' and å¤±ææ¶é´ BETWEEN NOW() - INTERVAL 15 DAY AND NOW() " + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList"); |
| | | 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 = CodeConstant.SUCCEED; |
| | | objJsonResult.count = CountConstant.SUCCEED; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | #region å·¥èºè·¯çº¿å页å表 |
| | | [Route("Gy_RoutingBill/page")] |
| | | [HttpGet] |
| | | public json Gy_RoutingBillPage(string sWhere, string user, int page, int size) |
| | | public object Gy_RoutingBillPage(string sWhere, string user, int page, int size) |
| | | { |
| | | DataSet ds; |
| | | json res = new json(); |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | //è·åç³»ç»åæ°å¤æå·¥èºè·¯çº¿æ¯å¦å¯ç¨å¤çº§å®¡æ¹ç¦ç¨æ®éå®¡æ¹ |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn) == true) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_EnableMultiLevel.ToUpper() == "Y") //ç³»ç»åæ° å¯ç¨èªå¨å®¡æ ¸ |
| | | { |
| | | objJsonResult.code = CodeConstant.FAIL; |
| | | objJsonResult.count = CountConstant.FAIL; |
| | | objJsonResult.Message = "å·¥èºè·¯çº¿å·²å¯ç¨å¤çº§å®¡æ¹æ®éå®¡æ ¸ç¦ç¨"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | |
| | | 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 |
| | | { |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
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 |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | string HProject = dic["HProject"].ToString();//项ç®å· |
| | | string HBatchWork = dic["HBatchWork"].ToString();//æ¯å¦é产 |
| | | string HDivisionName = dic["HDivisionName"].ToString();//äºä¸é¨ |
| | | string HMaterNumber = dic["HMaterNumber"].ToString();//ç©æä»£ç |
| | | string HMaterName = dic["HMaterName"].ToString();//ç©æåç§° |
| | | string HBatchNo = dic["HBatchNo"].ToString();//æ¹æ¬¡å· |
| | | string HProjectNum = dic["HProjectNum"].ToString();//项ç®å· |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_QC_BadProductsReport '" + HBeginDate + "','" + HEndDate + "','" + HProject + "','" + HBatchWork + "','" + HDivisionName + "'", "h_p_QC_BadProductsReport"); |
| | | ds = oCN.RunProcReturn("exec h_p_QC_BadProductsReport '" + HBeginDate + "','" + HEndDate + "','" + HProject + "','" + HBatchWork + "','" + HDivisionName + "','" + HMaterNumber + "','" + HMaterName + "','" + HBatchNo + "','" + HProjectNum + "'", "h_p_QC_BadProductsReport"); |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | |
| | | #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 |
| | | |
| | | } |
| | | } |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //夿æ¯å¦ææ¥çå
¨é¨çç»çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_Group_AllQuery", 3, false, user)) |
| | | { |
| | | //å¦ææ²¡æè¿ä¸ªæé |
| | | //æ ¹æ®ç¨æ·å¯¹åºçç»çå
³ç³»ï¼è¿æ»¤æ¡ä»¶ä¸å¢å åªæ¾ç¤ºå¯¹åºççç» |
| | | DataSet dsHitemID = oCn.RunProcReturn("exec h_p_Gy_GetSQLGroupByUser '" + user + "'", "h_p_Gy_GetSQLGroupByUser"); |
| | | string sqlGroupID = DBUtility.ClsPub.isStrNull(dsHitemID.Tables[0].Rows[0]["HBack"]); |
| | | if (sqlGroupID == "" || sqlGroupID == null)//å¦ææ²¡æç»å®çç»å让ä»çä¸å°ææ |
| | | { |
| | | sqlGroupID = "and 1 = 2"; |
| | | } |
| | | sqlGroupID = sqlGroupID.Replace("HitemID", "HGroupID");//æ¿æ¢sqlè¯å¥ä¸çHitemID |
| | | sWhere = sWhere + sqlGroupID; |
| | | } |
| | | sWhere = sWhere.Replace("'", "''"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥èµç»ç®å(éä½) æ¹éå®¡æ ¸ |
| | | /// <summary> |
| | | /// å®¡æ ¸/åå®¡æ ¸å·¥èµç»ç®å(éä½) |
| | | /// </summary> |
| | | /// <param name="HInterID">忮ID</param> |
| | | /// <param name="Type">å®¡æ ¸(1),åå®¡æ ¸(2)</param> |
| | | /// <param name="HMaker">å®¡æ ¸äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Pay_GroupBalBillController/CheckAll")] |
| | | [HttpGet] |
| | | public object CheckAll(string ids, int Type, string HMaker) |
| | | { |
| | | try |
| | | { |
| | | //å¤çå符串 |
| | | if (!string.IsNullOrEmpty(ids)) |
| | | { |
| | | long[] idArray = Array.ConvertAll(ids.Split(','), long.Parse); |
| | | // å¤çidArray... |
| | | oCn.BeginTran(); |
| | | for (int i = 0; i < idArray.Length; i++) |
| | | { |
| | | objJsonResult = (json)GetPay_GroupBalBill_Check_Json(idArray[i], Type, HMaker);//å®¡æ ¸æ§è¡ |
| | | if (objJsonResult.count == 0) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.Message += "第" + (i + 1) + "è¡åºç°é®é¢æ æ³ç»§ç»å®æ"; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¯·éæ©æ£ç¡®è¡"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | objJsonResult.code = CodeConstant.SUCCEED; |
| | | objJsonResult.count = CountConstant.SUCCEED; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æåå®¡æ ¸å·¥èµç»ç®å(个人)失败ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region å·¥èµç»ç®åï¼éä½ï¼ å
³é/åå
³é |
| | | /// <summary> |
| | | /// å
³é/åå
³éå·¥èµç»ç®åï¼éä½ï¼ |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //夿æ¯å¦ææ¥çå
¨é¨çç»çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_Group_AllQuery", 3, false, user)) |
| | | { |
| | | //å¦ææ²¡æè¿ä¸ªæé |
| | | //æ ¹æ®ç¨æ·å¯¹åºçç»çå
³ç³»ï¼è¿æ»¤æ¡ä»¶ä¸å¢å åªæ¾ç¤ºå¯¹åºççç» |
| | | DataSet dsHitemID = oCn.RunProcReturn("exec h_p_Gy_GetSQLGroupByUser '" + user + "'", "h_p_Gy_GetSQLGroupByUser"); |
| | | string sqlGroupID = DBUtility.ClsPub.isStrNull(dsHitemID.Tables[0].Rows[0]["HBack"]); |
| | | if(sqlGroupID == ""||sqlGroupID==null)//å¦ææ²¡æç»å®çç»å让ä»çä¸å°ææ |
| | | { |
| | | sqlGroupID = "and 1 = 2"; |
| | | } |
| | | sqlGroupID = sqlGroupID.Replace("HitemID", "HGroupID");//æ¿æ¢sqlè¯å¥ä¸çHitemID |
| | | sWhere = sWhere + sqlGroupID; |
| | | } |
| | | |
| | | |
| | | sWhere = sWhere.Replace("'", "''"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥èµç»ç®å(个人) æ¹éå®¡æ ¸ |
| | | /// <summary> |
| | | /// å®¡æ ¸/åå®¡æ ¸å·¥èµç»ç®å(个人) |
| | | /// </summary> |
| | | /// <param name="HInterID">忮ID</param> |
| | | /// <param name="Type">å®¡æ ¸(1),åå®¡æ ¸(2)</param> |
| | | /// <param name="HMaker">å®¡æ ¸äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Pay_SingleBalBillController/CheckAll")] |
| | | [HttpGet] |
| | | public object CheckAll(string ids, int Type, string HMaker) |
| | | { |
| | | try |
| | | { |
| | | //å¤çå符串 |
| | | if (!string.IsNullOrEmpty(ids)) |
| | | { |
| | | long[] idArray = Array.ConvertAll(ids.Split(','), long.Parse); |
| | | // å¤çidArray... |
| | | oCn.BeginTran(); |
| | | for (int i = 0; i < idArray.Length; i++) |
| | | { |
| | | objJsonResult = (json)GetPay_SingleBalBill_Check_Json(idArray[i], Type, HMaker);//å®¡æ ¸æ§è¡ |
| | | if (objJsonResult.count == 0) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.Message += "第" + (i + 1) + "è¡åºç°é®é¢æ æ³ç»§ç»å®æ"; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¯·éæ©æ£ç¡®è¡"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | objJsonResult.code = CodeConstant.SUCCEED; |
| | | objJsonResult.count = CountConstant.SUCCEED; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸æåå®¡æ ¸å·¥èµç»ç®å(个人)失败ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥èµç»ç®å(个人) å
³é/åå
³é |
| | | /// <summary> |
| | | /// å
³é/åå
³éå·¥èµç»ç®å(个人) |
| | |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "Exceptionï¼" + e.ToString(); |
| | | res.data = null; |
| | | return objJsonResult; |
| | | return res; |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | { |
| | | ds = oCN.RunProcReturn |
| | | ("select a.HInterID,a.HBillType,a.HICMOBillNo,a.HICMOInterID,a.HMaterID" + |
| | | ",m.HNumber HMaterNumber,m.HName HMaterName,m.HModel HMaterModel,a.HICMOEntryID" + |
| | | ",m.HNumber HMaterNumber,m.HName HMaterName,m.HModel HMaterModel,a.HICMOEntryID,a.HSourceID,s.HName HSourceName" + |
| | | ",a.HSourceBillNo,a.HSourceInterID,a.HSourceEntryID,a.HDatePlanQty,a.HDeptID,d.HName HDeptName,m.HUnitID,u.HName HUnitName" + |
| | | " from Sc_ICMOBillStatus_Tmp a " + |
| | | " left join Gy_Material m on a.HMaterID=m.HItemID " + |
| | | " left join Gy_Department d on a.HDeptID=d.HItemID " + |
| | | " left join Gy_Unit u on m.HUnitID=u.HItemID " + |
| | | " left join Gy_Source s on a.HSourceID=s.HItemID " + |
| | | " Where a.HInterID=" + HInterID + " and a.HBillType=" + HBillType, "Sc_ICMOBillStatus_Tmp"); |
| | | } |
| | | else { |
| | | ds = oCN.RunProcReturn |
| | | ("select a.HInterID,a.HBillType,a.HICMOBillNo,a.HICMOInterID,a.HMaterID" + |
| | | ("select a.HInterID,a.HBillType,a.HICMOBillNo,a.HICMOInterID,a.HMaterID,a.HSourceID,s.HName HSourceName" + |
| | | ",m.HNumber HMaterNumber,m.HName HMaterName,m.HModel HMaterModel,a.HICMOEntryID,a.HDeptID,d.HName HDeptName,m.HUnitID,u.HName HUnitName " + |
| | | " from Sc_ICMOBillStatus_Tmp a " + |
| | | " left join Gy_Material m on a.HMaterID=m.HItemID " + |
| | | " left join Gy_Department d on a.HDeptID=d.HItemID " + |
| | | " left join Gy_Unit u on m.HUnitID=u.HItemID " + |
| | | " left join Gy_Source s on a.HSourceID=s.HItemID " + |
| | | " Where a.HInterID=" + HInterID + " and a.HBillType=" + HBillType, "Sc_ICMOBillStatus_Tmp"); |
| | | } |
| | | |
| | |
| | | --> |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <History>True|2024-10-15T08:44:32.6189434Z;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> |
| | | <History>True|2024-10-22T02:33:10.1961964Z;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> |
| | | <_PublishTargetUrl>G:\issWeb\ç½ç«åå¸\API</_PublishTargetUrl> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>10/15/2024 16:43:59</publishTime> |
| | | <publishTime>10/23/2024 11:34:21</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>10/15/2024 16:43:59</publishTime> |
| | | <publishTime>10/23/2024 11:34:21</publishTime> |
| | | </File> |
| | | <File Include="bin/BouncyCastle.Crypto.dll"> |
| | | <publishTime>12/18/2020 05:32:28</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>10/15/2024 16:43:56</publishTime> |
| | | <publishTime>10/23/2024 11:34:19</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>10/15/2024 16:43:56</publishTime> |
| | | <publishTime>10/23/2024 11:34:19</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>10/15/2024 16:43:52</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>10/15/2024 16:43:52</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.Api.dll"> |
| | | <publishTime>03/22/2022 13:17:26</publishTime> |
| | |
| | | <publishTime>07/25/2012 19:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>10/15/2024 16:43:52</publishTime> |
| | | <publishTime>10/23/2024 11:34:14</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>10/15/2024 16:43:52</publishTime> |
| | | <publishTime>10/23/2024 11:34:14</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>04/15/2024 12:55:45</publishTime> |
| | |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:11</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:11</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/RestSharp.dll"> |
| | | <publishTime>08/31/2012 06:22:50</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>10/15/2024 16:43:50</publishTime> |
| | | <publishTime>10/23/2024 11:34:12</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | </File> |
| | | <File Include="bin/SyntacticSugar.dll"> |
| | | <publishTime>10/15/2024 16:41:50</publishTime> |
| | | <publishTime>10/23/2024 11:32:01</publishTime> |
| | | </File> |
| | | <File Include="bin/SyntacticSugar.pdb"> |
| | | <publishTime>10/15/2024 16:41:50</publishTime> |
| | | <publishTime>10/23/2024 11:32:01</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Buffers.dll"> |
| | | <publishTime>07/19/2017 18:01:28</publishTime> |
| | |
| | | <publishTime>05/09/2023 10:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/TopSdk.dll"> |
| | | <publishTime>10/15/2024 16:41:55</publishTime> |
| | | <publishTime>10/23/2024 11:32:07</publishTime> |
| | | </File> |
| | | <File Include="bin/TopSdk.pdb"> |
| | | <publishTime>10/15/2024 16:41:55</publishTime> |
| | | <publishTime>10/23/2024 11:32:07</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>10/15/2024 16:44:29</publishTime> |
| | | <publishTime>10/23/2024 11:34:53</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>10/15/2024 16:44:29</publishTime> |
| | | <publishTime>10/23/2024 11:34:53</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.XmlSerializers.dll"> |
| | | <publishTime>08/16/2024 16:55:28</publishTime> |
| | |
| | | <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-22T08:25:12.9514711Z;False|2024-10-22T16:24:42.9025167+08:00;True|2024-10-22T10:22:33.9932601+08:00;False|2024-10-22T10:22:05.3030308+08:00;True|2024-10-21T17:53:29.9552741+08:00;True|2024-10-21T16:37:31.4159544+08:00;True|2024-10-21T16:35:43.6207036+08:00;True|2024-10-21T16:00:05.5040651+08:00;False|2024-10-21T15:59:35.9279259+08:00;True|2024-10-21T12:06:42.5768961+08:00;False|2024-10-21T12:06:16.6344662+08:00;True|2024-10-18T10:44:02.6495536+08:00;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/22/2024 16:24:57</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>08/26/2024 14:16:33</publishTime> |
| | | <publishTime>10/22/2024 16:24:57</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/22/2024 16:24:56</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>08/26/2024 14:16:32</publishTime> |
| | | <publishTime>10/22/2024 16:24:56</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/22/2024 16:24:53</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/22/2024 16:24:53</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/22/2024 16:24:54</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>08/26/2024 14:16:30</publishTime> |
| | | <publishTime>10/22/2024 16:24:54</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/22/2024 16:24:52</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>08/26/2024 14:16:28</publishTime> |
| | | <publishTime>10/22/2024 16:24:52</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/22/2024 16:24:52</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/22/2024 16:24:52</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/22/2024 16:24:52</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>08/26/2024 14:16:29</publishTime> |
| | | <publishTime>10/22/2024 16:24:52</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/22/2024 10:30:55</publishTime> |
| | | </File> |
| | | <File Include="bin/SyntacticSugar.pdb"> |
| | | <publishTime>10/22/2024 10:30:55</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/22/2024 16:24:03</publishTime> |
| | | </File> |
| | | <File Include="bin/TopSdk.pdb"> |
| | | <publishTime>08/26/2024 14:16:31</publishTime> |
| | | <publishTime>10/22/2024 16:24:03</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/22/2024 16:24:30</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>08/26/2024 14:16:37</publishTime> |
| | | <publishTime>10/22/2024 16:24:30</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" /> |
| | |
| | | <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> |
| | |
| | | D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll |
| | | D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb |
| | | D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache |
| | | C:\Users\86130\Desktop\æºäºè¿æ\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache |