| | |
| | | <Compile Include="ä»åºç®¡ç\æ¡ç 管ç\ClsGy_BarCodeBill_ChaiMa.cs" /> |
| | | <Compile Include="ä»åºç®¡ç\æ¡ç 管ç\ClsKF_BarCodeStatusChangeBill.cs" /> |
| | | <Compile Include="åºç¡èµæ\InterFaceåºç¡èµæ\ClsIF_ORGANIZATIONS_View.cs" /> |
| | | <Compile Include="åºç¡èµæ\å
¬ç¨åºç¡èµæ\ClsGy_BadType_Ctl.cs" /> |
| | | <Compile Include="åºç¡èµæ\å
¬ç¨åºç¡èµæ\ClsGy_CustLocation_Ctl.cs" /> |
| | | <Compile Include="åºç¡èµæ\å
¬ç¨åºç¡èµæ\ClsGy_EquipStatus_Ctl.cs" /> |
| | | <Compile Include="åºç¡èµæ\å
¬ç¨åºç¡èµæ\ClsGy_MouldStatus_Ctl.cs" /> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace DAL |
| | | { |
| | | public class ClsGy_BadType_Ctl : DBUtility.ClsGy_Base_Ctl |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | //å代ç ç¨äº æ¿æ¢åé¡¹ç® |
| | | public string HOldNumber; |
| | | public Model.ClsGy_BadType_Model oModel = new Model.ClsGy_BadType_Model(); |
| | | //æ°å¢ |
| | | public override bool AddNew() |
| | | { |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Insert into " + MvarItemKey + " " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HGroupID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HUseFlag,HMakeEmp,HMakeTime) " + |
| | | " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | "," + oModel.HGroupID.ToString() + |
| | | "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'," + oModel.HOrgID + "," + oModel.HOrgID + ",'" + oModel.HUseFlag + "','" + oModel.HMakeEmp + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //ä¿®æ¹ |
| | | public override bool ModifyByID(Int64 sItemID) |
| | | { |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Update " + MvarItemKey + " set " + |
| | | " HNumber='" + oModel.HNumber + "'" + |
| | | ",HName='" + oModel.HName + "'" + |
| | | ",HShortNumber='" + oModel.HShortNumber + "'" + |
| | | ",HHelpCode='" + oModel.HHelpCode + "'" + |
| | | ",HModifyEmp='" + oModel.HMakeEmp + "'" + |
| | | ",HModifyTime='" + DateTime.Now + "'" + |
| | | ",HLevel=" + oModel.HLevel.ToString() + |
| | | ",HGroupID=" + oModel.HGroupID.ToString() + |
| | | ",HEndflag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) + |
| | | ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) + |
| | | ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | //æ ¹æ®ä»£ç å¤æä¿¡æ¯ |
| | | public override bool HavParentCode(string sCode, Int64 sItemID) |
| | | { |
| | | DataSet DS; |
| | | try |
| | | { |
| | | DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count == 0) |
| | | return false; |
| | | else |
| | | { |
| | | oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]); |
| | | return true; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | //æé 彿° |
| | | public ClsGy_BadType_Ctl() |
| | | { |
| | | MvarItemKey = "Gy_BadType"; |
| | | MvarReportTitle = "ä¸è¯ç±»å设置"; |
| | | oModel = new Model.ClsGy_BadType_Model(); |
| | | } |
| | | } |
| | | } |
| | |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_AreaUser_Model.cs"> |
| | | <SubType>Code</SubType> |
| | | </Compile> |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_BadType_Model.cs" /> |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_BigArea_Model.cs" /> |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_BusinessUnit_Model.cs" /> |
| | | <Compile Include="åºç¡èµæ\åºç¡èµæ\ClsGy_Carbook_Model.cs" /> |
| | |
| | | public Int64 HDeptID; |
| | | public string HDeptNumber; |
| | | public Int64 HProcID; |
| | | public Int64 HBadTypeID; |
| | | public string HBarCode; |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsGy_BadType_Model : DBUtility.ClsGy_Base_Model |
| | | { |
| | | // |
| | | public Int64 HGroupID; |
| | | public string HDeptNumber; |
| | | public Int64 HProcID; |
| | | public string HBarCode; |
| | | public string HMakeEmp; |
| | | public Int64 HOrgID; |
| | | } |
| | | } |
| | |
| | | public string HCusMaterName; //客æ·ç©æåç§° |
| | | public string HCusModel; //客æ·è§æ ¼åå· |
| | | |
| | | public object HOrderPickRemark { get; set; } |
| | | } |
| | | } |
| | |
| | | |
| | | private void sh_Click(object sender, EventArgs e) |
| | | { |
| | | DataSet ds2 = oCn.RunProcReturn("exec h_p_Kf_CheckSellOutBill_CrediControl " + HInterID.ToString(), "h_p_Kf_CheckSellOutBill_CrediControl"); |
| | | if (ds2 == null || ds2.Tables[0].Rows.Count == 0) |
| | | { |
| | | MessageBox.Show("å®¡æ ¸éå®åºåºåï¼ä¿¡ç¨æ§å¶å¤æé误ï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | else if (DBUtility.ClsPub.isLong(ds2.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | MessageBox.Show(DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HRemark"]), "æç¤º"); |
| | | return; |
| | | } |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Kf_SellOutBill_Check " + HInterID.ToString() + ",'" + HBillType + "','" + HMaker + "'", "h_p_Kf_SellOutBill_Check"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | { |
| | | this.components = new System.ComponentModel.Container(); |
| | | System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Kf_SellOutBill_BarCodeNote)); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = 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.txtHSellStyle = new System.Windows.Forms.TextBox(); |
| | | this.gbUp = new System.Windows.Forms.GroupBox(); |
| | | this.pic1 = new System.Windows.Forms.PictureBox(); |
| | | this.txtHCreditDifference = new System.Windows.Forms.TextBox(); |
| | | this.txtHCreditRating = new System.Windows.Forms.TextBox(); |
| | | this.txtHMoney = new System.Windows.Forms.TextBox(); |
| | |
| | | this.ä¸é´ = new System.Windows.Forms.Panel(); |
| | | this.åºé¨ = new System.Windows.Forms.Panel(); |
| | | this.å³ä¾§ = new System.Windows.Forms.Panel(); |
| | | this.pic1 = new System.Windows.Forms.PictureBox(); |
| | | this.Tool.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit(); |
| | | this.gbUp.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.pic1)).BeginInit(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdSub)).BeginInit(); |
| | | this.tabControl1.SuspendLayout(); |
| | | this.tabPage1.SuspendLayout(); |
| | |
| | | this.panel1.SuspendLayout(); |
| | | this.groupBox1.SuspendLayout(); |
| | | this.panel2.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.pic1)).BeginInit(); |
| | | this.SuspendLayout(); |
| | | // |
| | | // Tool |
| | |
| | | this.tp.Text = "ç³è¯·ç¹æ¹"; |
| | | this.tp.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tp.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.tp.Visible = false; |
| | | this.tp.Click += new System.EventHandler(this.tp_Click); |
| | | // |
| | | // toolStripSeparator1 |
| | | // |
| | | this.toolStripSeparator1.Name = "toolStripSeparator1"; |
| | | this.toolStripSeparator1.Size = new System.Drawing.Size(6, 50); |
| | | this.toolStripSeparator1.Visible = false; |
| | | // |
| | | // sh |
| | | // |
| | |
| | | this.grdMain.AllowUserToDeleteRows = false; |
| | | this.grdMain.BackgroundColor = System.Drawing.SystemColors.ControlLightLight; |
| | | this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
| | | dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle9.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle9.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle9.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle9.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle9.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle9.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdMain.DefaultCellStyle = dataGridViewCellStyle9; |
| | | 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); |
| | |
| | | this.gbUp.Size = new System.Drawing.Size(1105, 218); |
| | | this.gbUp.TabIndex = 58; |
| | | this.gbUp.TabStop = false; |
| | | // |
| | | // pic1 |
| | | // |
| | | this.pic1.BackColor = System.Drawing.SystemColors.ActiveCaption; |
| | | this.pic1.Location = new System.Drawing.Point(861, 22); |
| | | this.pic1.Name = "pic1"; |
| | | this.pic1.Size = new System.Drawing.Size(66, 30); |
| | | this.pic1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; |
| | | this.pic1.TabIndex = 338; |
| | | this.pic1.TabStop = false; |
| | | this.pic1.Visible = false; |
| | | // |
| | | // txtHCreditDifference |
| | | // |
| | |
| | | this.grdSub.AllowUserToDeleteRows = false; |
| | | this.grdSub.BackgroundColor = System.Drawing.SystemColors.ControlLightLight; |
| | | this.grdSub.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
| | | dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
| | | dataGridViewCellStyle10.BackColor = System.Drawing.SystemColors.Window; |
| | | dataGridViewCellStyle10.Font = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | dataGridViewCellStyle10.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | dataGridViewCellStyle10.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
| | | dataGridViewCellStyle10.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
| | | dataGridViewCellStyle10.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
| | | this.grdSub.DefaultCellStyle = dataGridViewCellStyle10; |
| | | 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.å³ä¾§.Size = new System.Drawing.Size(12, 627); |
| | | this.å³ä¾§.TabIndex = 64; |
| | | // |
| | | // pic1 |
| | | // |
| | | this.pic1.BackColor = System.Drawing.SystemColors.ActiveCaption; |
| | | this.pic1.Location = new System.Drawing.Point(861, 22); |
| | | this.pic1.Name = "pic1"; |
| | | this.pic1.Size = new System.Drawing.Size(66, 30); |
| | | this.pic1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; |
| | | this.pic1.TabIndex = 338; |
| | | this.pic1.TabStop = false; |
| | | this.pic1.Visible = false; |
| | | // |
| | | // Kf_SellOutBill_BarCodeNote |
| | | // |
| | | this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); |
| | |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit(); |
| | | this.gbUp.ResumeLayout(false); |
| | | this.gbUp.PerformLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.pic1)).EndInit(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdSub)).EndInit(); |
| | | this.tabControl1.ResumeLayout(false); |
| | | this.tabPage1.ResumeLayout(false); |
| | |
| | | this.groupBox1.ResumeLayout(false); |
| | | this.groupBox1.PerformLayout(); |
| | | this.panel2.ResumeLayout(false); |
| | | ((System.ComponentModel.ISupportInitialize)(this.pic1)).EndInit(); |
| | | this.ResumeLayout(false); |
| | | |
| | | } |
| | |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //æ¥çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BadReason", 1, false, user)) |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BadType_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere + " order by ä¸è¯åå 代ç ", "h_v_IF_BadReasonList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; |
| | | string sql = sql1 + sWhere + " order by ä¸è¯åå 代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); |
| | | } |
| | | string sql1 = "select * from h_v_gy_BadTypeList where 1 = 1"; |
| | | string sql = sql1 + sWhere + " order by ä¸è¯ç±»å代ç "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_gy_BadTypeList"); |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["HStatus"].ToString() != "") |
| | | if (ds.Tables[0].Rows[0]["HStatus"].ToString() != "æ£å¸¸") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | sub = JsonConvert.DeserializeObject<List<Model.ClsSc_AssemblyBillSub>>(sSubStr); |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QualifiedRecordsList where äº§åæ¡ç ='" + omodel.HBarCode_P + "'", "h_v_Gy_QualifiedRecordsList"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡ç :" + omodel.HBarCode_P + ",å·²åå¨!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | Int64 HInterID1 = DBUtility.ClsPub.CreateBillID("3727", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo1 = DBUtility.ClsPub.CreateBillCode("3727", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | //ä¿åç产ç»è£
å主表 |
| | |
| | | "," + HmaterOutqty + "," + HProcPriceRate + "," + HTemporaryAreaID + ") "); |
| | | } |
| | | |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_SN where HInterID='" + omodel.HInterID + "' order by HEntryID desc", "Sc_StationOutBillSub_SN"); |
| | | |
| | | oCN.RunProc($@"insert into Sc_StationOutBillSub_SN(HInterID,HBillNo_bak,HEntryID,HBarCode,HBarCodeQty,HMakeTime,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({omodel.HInterID}, '{omodel.HBillNo}', {ds.Tables[0].Rows.Count + 1}, '{omodel.HBarCode_P}', 1, GETDATE(), '', 0, 0, '', '', 0, 0)"); |
| | | values({omodel.HInterID}, '{omodel.HBillNo}', {(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)}, '{omodel.HBarCode_P}', 1, GETDATE(), '', " + HProcExchInterID + ","+ HProcExchEntryID + ", '"+ HProcExchBillNo + "', '', 0, 0)"); |
| | | |
| | | //ååå·¥åºåºç«åçåæ ¼æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID); |
| | | |
| | | oCN.Commit(); |
| | | |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | |
| | | if (ds.Tables[0].Rows[0]["HStatus"].ToString() !="") |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½åæ¡ç çç¶æä¸º:"+ ds.Tables[0].Rows[0]["HStatus"].ToString() + "ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["HStatus"].ToString() != "") { |
| | | if (ds.Tables[0].Rows[0]["HStatus"].ToString() != "æ£å¸¸") { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½åæ¡ç ç¶æä¸º"+ ds.Tables[0].Rows[0]["HStatus"].ToString() + "!"; |
| | |
| | | #region å·¥åºååè¿ç« æ¥è¯¢åæ ¼è®°å½ |
| | | [Route("Cj_SingleStation/HGRecordsList")] |
| | | [HttpGet] |
| | | public object HGRecordsList(string HBarCode, string user) |
| | | public object HGRecordsList(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(@"select * from h_v_Sc_AssemblyBillList where HProcExchBillNo='" + HBarCode + "'", "h_v_Sc_AssemblyBillList"); |
| | | ds = oCN.RunProcReturn(@"select * from h_v_Gy_QualifiedRecordsList where 1=1"+ sWhere, "h_v_Gy_QualifiedRecordsList"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºååè¿ç« å é¤ä¸è¯è®°å½ |
| | | [Route("Cj_SingleStation/DelBadRecords")] |
| | | [HttpGet] |
| | | public object DelBadRecords(int HInterID, int HEntryID, string user,int HProcID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_BadRecordsList where HInterID = " + HInterID, "h_v_Gy_BadRecordsList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥æ æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | } |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | | string sql = ""; |
| | | sql = "delete from Sc_QualityReportBillMain where HInterID = " + HInterID; |
| | | oCN.RunProc(sql); |
| | | sql = "delete from Sc_QualityReportBillSub where HInterID = " + HInterID + " and HEntryID = " + HEntryID; |
| | | oCN.RunProc(sql); |
| | | string HProcExchInterID = ds.Tables[0].Rows[0]["HProcExchInterID"].ToString(); |
| | | string HProcExchEntryID = ds.Tables[0].Rows[0]["HProcExchEntryID"].ToString(); |
| | | //ååå·¥åºåºç«åçä¸è¯æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HBadCount-=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID); |
| | | |
| | | |
| | | oCN.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å·¥åºååè¿ç« å é¤åæ ¼è®°å½ |
| | | [Route("Cj_SingleStation/DelQualifiedRecords")] |
| | | [HttpGet] |
| | | public object DelQualifiedRecords(int HInterID, int HEntryID, string user) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QualifiedRecordsList where hmainid = " + HInterID, "h_v_Gy_QualifiedRecordsList"); |
| | | |
| | | string HProcExchInterID = ds.Tables[0].Rows[0]["HProcExchInterID"].ToString(); |
| | | string HProcExchEntryID = ds.Tables[0].Rows[0]["HProcExchEntryID"].ToString(); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥æ æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | } |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | | string sql = ""; |
| | | if (ds.Tables[0].Rows.Count == 1) { |
| | | sql = "delete from Sc_StationOutBillMain where HInterID = " + HInterID; |
| | | oCN.RunProc(sql); |
| | | } |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_SN where HInterID = " + HInterID + " and HEntryID = " + HEntryID, "Sc_StationOutBillSub_SN"); |
| | | string HBarCode = ds.Tables[0].Rows[0]["HBarCode"].ToString(); |
| | | string HBillNo_bak = ds.Tables[0].Rows[0]["HBillNo_bak"].ToString(); |
| | | |
| | | //å é¤ç»è£
追溯å |
| | | oCN.RunProc("delete from Sc_AssemblyBillSub where HInterID in(select HInterID from Sc_AssemblyBillMain where HMainSourceInterID=" + HProcExchInterID + " and HMainSourceEntryID=" + HProcExchEntryID + " and HBarCode_P='" + HBarCode + "')"); |
| | | oCN.RunProc("delete from Sc_AssemblyBillMain where HMainSourceInterID=" + HProcExchInterID + " and HMainSourceEntryID=" + HProcExchEntryID + " and HBarCode_P='" + HBarCode + "'"); |
| | | |
| | | sql = "delete from Sc_StationOutBillSub_SN where HInterID = " + HInterID + " and HEntryID = " + HEntryID; |
| | | oCN.RunProc(sql); |
| | | //ååå·¥åºåºç«åçåæ ¼æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty-=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID+ " and HBillNo='"+ HBillNo_bak + "'"); |
| | | |
| | | |
| | | oCN.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | string[] sArray = msg.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string sMainStr = sArray[0].ToString(); |
| | | string sSubStr = sArray[1].ToString(); |
| | | string user = sArray[2].ToString(); |
| | | string HResult = sArray[3].ToString(); |
| | | string sSubStr2 = sArray[2].ToString(); |
| | | string user = sArray[3].ToString(); |
| | | string HResult = sArray[4].ToString(); |
| | | |
| | | oCN.BeginTran(); |
| | | if (HResult == "é
ä»¶") |
| | |
| | | ({model.HInterID},{(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)},'{model.HBillNo}','',{temp.HProcExchInterID} |
| | | ,{temp.HProcExchEntryID},'{temp.HProcExchBillNo}','',{temp.HMaterID},0,'{temp.HBarCode}','{temp.HBatchNo}')"); |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_SourceLineRepairBillSub where HInterID=" + model.HInterID, "Sc_SourceLineRepairBillSub"); |
| | | if (ds.Tables[0].Rows[0]["HRepairResult"].ToString() == "OK") { |
| | | //çæ äº§çº¿ç»è£
追溯å |
| | | |
| | | Int64 HInterID1 = DBUtility.ClsPub.CreateBillID("3727", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo1 = DBUtility.ClsPub.CreateBillCode("3727", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_SourceLineRepairBillMain where HInterID=" + model.HInterID, "Sc_SourceLineRepairBillMain"); |
| | | string HMaterID = ds.Tables[0].Rows[0]["HMaterID"].ToString(); |
| | | //ä¿åç产ç»è£
å主表 |
| | | string sql = $@"Insert Into Sc_AssemblyBillMain(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate |
| | | ,HBillNo,HBillStatus,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo |
| | | ,HICMOInterID,HICMOBillNo,HBarCode_P,HMaterID,HUnitID,HAssemblyStatus,HProdOrgID) |
| | | values('{DateTime.Now.Year}','{DateTime.Now.Month}','3727','3727',{HInterID1},getdate() |
| | | ,'{HBillNo1}','1','{user}',getdate(),{temp.HProcExchInterID.ToString()},{temp.HProcExchEntryID.ToString()},'{temp.HProcExchBillNo.ToString()}' |
| | | ,{model.HICMOInterID.ToString()},'{model.HICMOBillNo.ToString()}','{model.HBarCode.ToString()}',{HMaterID},0,'æ±æ¥',{model.HProdOrgID})"; |
| | | oCN.RunProc(sql); |
| | | |
| | | List<Model.Sc_AssemblyBill_BindSourceTemp> sub = new List<Model.Sc_AssemblyBill_BindSourceTemp>(); |
| | | sub = JsonConvert.DeserializeObject<List<Model.Sc_AssemblyBill_BindSourceTemp>>(sSubStr2); |
| | | |
| | | for (int i = 0; i < sub.Count; i++) |
| | | { |
| | | //å表åå¨ |
| | | string sq2 = $@"Insert Into Sc_AssemblyBillSub(HInterID,HBillNo_bak,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo |
| | | ,HSourceBillType,HMaterID,HSourceID,HEquipID,HUnitID,HQty |
| | | ,HGroupID,HWorkerID,HScanDate,HBarCode,HBarCode_P,HSNNumber) |
| | | values({HInterID1},'{HBillNo1}',{(i + 1)},0,0,'' |
| | | ,'',{sub[i].HMaterID},0,0,0,{sub[i].HQty} |
| | | ,0,0,getdate(),'{sub[i].HBarCode}','{model.HBarCode}','') "; |
| | | oCN.RunProc(sq2); |
| | | } |
| | | |
| | | //ç产工åºåºç«SNæ°æ® |
| | | ds = oCN.RunProcReturn("select top 1 HInterID,HBillNo from Sc_StationOutBillMain where HProcExchInterID=" + temp.HProcExchInterID + " and HProcExchEntryID=" + temp.HProcExchEntryID + " and HBadCount<>0 order by HInterID desc", "Sc_StationOutBillMain"); |
| | | |
| | | string HInterIDSN = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | string HBillNoSN = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_SN where HInterID=" + HInterIDSN , "Sc_StationOutBillSub_SN"); |
| | | |
| | | oCN.RunProc($@"insert into Sc_StationOutBillSub_SN(HInterID,HBillNo_bak,HEntryID,HBarCode,HBarCodeQty,HMakeTime,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterIDSN}, '{HBillNoSN}', {ds.Tables[0].Rows.Count + 1}, '{model.HBarCode}', 1, GETDATE(), '', "+ temp.HProcExchInterID + ","+ temp.HProcExchEntryID+ ", '"+ temp.HProcExchBillNo+ "', '', 0, 0)"); |
| | | //ååå·¥åºåºç«å 主表 ä¸è¯æ°é å åæ ¼æ°é |
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1,HBadCount-=1 where HInterID='" + HInterIDSN + "'"); |
| | | |
| | | } |
| | | //ä¿®æ¹é
ä»¶ç»å®æ¸
åç»å®çæ¡ç æ¹å· |
| | | oCN.RunProc("exec h_p_AssemblyBill_Temp '" + temp.HProcExchBillNo + "'," + model.HProcess + "," + temp.HMaterID + ",'" + temp.HBatchNo + "'"); |
| | | //oCN.RunProc("exec h_p_AssemblyBill_Temp '" + temp.HProcExchBillNo + "'," + model.HProcess + "," + temp.HMaterID + ",'" + temp.HBatchNo + "'"); |
| | | } |
| | | else if (HResult == "NG"|| HResult == "OK") { |
| | | Model.ClsSc_SourceLineRepairBillMain model = new Model.ClsSc_SourceLineRepairBillMain(); |
| | |
| | | else if (com.Type == 3772) |
| | | { |
| | | //ç产订å 䏿¥ å·¥åºæµè½¬å¡ |
| | | ds = oCN.RunProcReturn($"select * from h_v_Sc_ProcessExchangeBillQuery where HICMOInterID='{com.HSouceInterID}' and HICMOEntryID={com.HSourceEntryID}", "h_v_Sc_ProcessExchangeBillQuery"); |
| | | ds = oCN.RunProcReturn($"select * from h_v_Sc_ProcessExchangeBillQuery where HICMOInterID='{com.HSouceInterID}' and HICMOEntryID={com.HSourceEntryID} and HBillSubType<>'SUB'", "h_v_Sc_ProcessExchangeBillQuery"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¿åä¸è¯ç±»å |
| | | /// </summary> |
| | | /// <param name="msg"></param> |
| | | /// <returns></returns> |
| | | [Route("SaveGy_BadType")] |
| | | [HttpPost] |
| | | public object SaveGy_BadType([FromBody] JObject msg) |
| | | { |
| | | DataSet ds; |
| | | var _value = msg["msg"].ToString(); |
| | | string msg3 = _value.ToString(); |
| | | string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg1 = sArray[0].ToString(); |
| | | string msg2 = sArray[1].ToString(); |
| | | |
| | | //æ¥çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BadType_Edit", 1, false, msg2)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | Int64 HItemID = 0; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //è·åæå¤§IDå¼èµå¼ |
| | | DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_BadType ", "Gy_BadType"); |
| | | if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) |
| | | { |
| | | //HItemID= Maxds.Tables[0].Rows[0]["HItemID"] |
| | | var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]); |
| | | maxid += 1; |
| | | HItemID = maxid; |
| | | } |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DAL.ClsGy_BadType_Ctl oBill = new DAL.ClsGy_BadType_Ctl(); |
| | | List<Model.ClsGy_BadType_Model> lsmain = new List<Model.ClsGy_BadType_Model>(); |
| | | msg1 = msg1.Replace("\\", ""); |
| | | msg1 = msg1.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Gy_BadType(msg1); |
| | | foreach (Model.ClsGy_BadType_Model oItem in lsmain) |
| | | { |
| | | if (oItem.HNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (oItem.HName.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼åç§°ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim())) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //æ¥è¯¢æ°æ®ä¸æ¯å¦åå¨éå¤ä»£ç |
| | | |
| | | ds = oCN.RunProcReturn("select * from Gy_BadType where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_BadType"); |
| | | if (oItem.HNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä»£ç 为空ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //æ°å¢æ¶å¤æ |
| | | if (oItem.HItemID == 0) |
| | | { |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä»£ç éå¤ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | string sParent; |
| | | sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | oBill.oModel.HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | if (oBill.HavParentCode(sParent.Trim(), HItemID)) |
| | | { |
| | | oBill.oModel.HParentID = oBill.oModel.HItemID; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | else//ç¼è¾æ¶å¤æ |
| | | { |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | string sParent; |
| | | sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim()); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | oBill.oModel.HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID)) |
| | | { |
| | | oBill.oModel.HParentID = oBill.oModel.HItemID; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | //å¾å°ç代ç |
| | | string sShortNumber; |
| | | sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim()); |
| | | if (sShortNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | oItem.HShortNumber = sShortNumber;//ç代ç |
| | | oItem.HEndFlag = true;//æ«çº§æ å¿ |
| | | oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //ç级 |
| | | |
| | | oBill.oModel = oItem; |
| | | } |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | if (oBill.oModel.HItemID == 0) |
| | | { |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = oBill.AddNew(); |
| | | } |
| | | else |
| | | { |
| | | bResult = oBill.ModifyByID(oBill.oModel.HItemID); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// ä¸è¯ç±»åè·åä¿¡æ¯ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("GetGy_BadTypeDetail")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> GetGy_BadTypeDetail(string HID) |
| | | { |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_gy_BadTypeList where HItemID= " + HID + " ", "h_v_gy_BadTypeList"); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ä¸åå¨ä¸è¯ç±»åæ°æ®" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¸è¯ç±»åå é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("DeltetGy_BadType")] |
| | | [HttpGet] |
| | | public object DeltetGy_BadType(string HItemID, string user) |
| | | { |
| | | DataSet ds; |
| | | //string ModRightNameCheck = "Sc_ProcessReport_check"; |
| | | try |
| | | { |
| | | //å 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BadType_Drop", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (string.IsNullOrWhiteSpace(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HItemID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | ds = oCN.RunProcReturn("select * from Gy_BadType where HItemID=" + HItemID, "Gy_BadType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); |
| | | //if (HStopflag) |
| | | //{ |
| | | // oCN.RollBack();//åæ»äºå¡ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ°æ®å·²å 餿 æ³å次å é¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | oCN.RunProc("delete Gy_BadType where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°æ®å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¸è¯åå è·åä¿¡æ¯ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HBomID,HEntryCusID,HSTOCKINORGID |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney |
| | | ,HAuxQty,HAuxUnit,HWidth,HWeight,HColorRemark,HCusMaterName,HCusModel) |
| | | ,HAuxQty,HAuxUnit,HWidth,HWeight,HColorRemark,HCusMaterName,HCusModel,HOrderPickRemark) |
| | | values({HInterID},{HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,'{(oSub.HBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HBeginDate.ToString())}','{(oSub.HEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HEndDate.ToString())}' |
| | | ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} |
| | | ,{oSub.HBomID} ,{oSub.HCusID} ,{oSub.HSTOCKINORGID} |
| | | ,0,0,'','',0,0 |
| | | ,{oSub.HAuxQty},{oSub.HAuxUnit},{oSub.HWidth},{oSub.HWeight},'{oSub.HColorRemark}','{oSub.HCusMaterName}','{oSub.HCusModel}')"); |
| | | ,{oSub.HAuxQty},{oSub.HAuxUnit},{oSub.HWidth},{oSub.HWeight},'{oSub.HColorRemark}','{oSub.HCusMaterName}','{oSub.HCusModel}','{oSub.HOrderPickRemark}')"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region ç产任å¡å订åå
è£
夿³¨ ä¿ååè½ |
| | | [Route("Sc_ICMOBill/ICMOBillSaveRemark")] |
| | | [HttpGet] |
| | | public object ICMOBillSaveRemark(string HInterID,string HEntryID, string HOrderPickRemark) |
| | | { |
| | | try |
| | | { |
| | | if (string.IsNullOrEmpty(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼HInterIDä¸è½ä¸ºç©º"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("update Sc_ICMOBillSub set HOrderPickRemark = '" + HOrderPickRemark + "' where HInterID = " + HInterID + " and HEntryID = " + HEntryID + ""); |
| | | oCN.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | |
| | | oCn.RunProc("Insert into " + MvarItemKey + " " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HDeptID,HProcID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HBadTypeID) " + |
| | | " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | "," + oModel.HDeptID.ToString() + "," + oModel.HProcID.ToString() + |
| | | "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "',"+oModel.HBadTypeID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | |
| | | ",HHelpCode='" + oModel.HHelpCode + "'" + |
| | | ",HLevel=" + oModel.HLevel.ToString() + |
| | | ",HDeptID=" + oModel.HDeptID.ToString() + |
| | | ",HBadTypeID=" + oModel.HBadTypeID.ToString() + |
| | | ",HProcID=" + oModel.HProcID.ToString() + |
| | | ",HEndflag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) + |
| | | ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) + |
| | |
| | | ",HSubjoin,HSubjoin2,HColor,HVersion,HEngName,HEngModel,HPropertyTypeID,HSPGroupID,HSPID,HMinPickQty,HUSEORGID,HERPItemID" + |
| | | ",HSALEUNITID,HSALEPRICEUNITID,HBASEUNITID,HSTOREUNITID,HCHECKINCOMING,HCHECKPRODUCT,HPERUNITSTANDHOUR" + |
| | | ",HSTDLABORPREPARETIME,HSTDMACHINEPREPARETIME,HWidth,HWeight,HColorRemark,HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol" + |
| | | ",HMaterRuleType,HColorNo) " + |
| | | ",HMaterRuleType,HColorNo,HPieceMaxQty) " + |
| | | " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | ", " + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'" + |
| | | ",'" + oModel.HModel + "'," + oModel.HUnitID.ToString() + "," + oModel.HMaterClsID.ToString() + "," + oModel.HMaterTypeID.ToString() + "," + oModel.HUnitGroupID.ToString() + |
| | |
| | | ", " + oModel.HKeepDays.ToString() + "," + oModel.HPlanPrice.ToString() + "," + oModel.HstdPrice.ToString() + "," + oModel.HQtyMin.ToString() + "," + oModel.HQtyMax.ToString() + |
| | | ",'" + oModel.HSubjoin + "','" + oModel.HSubjoin2 + "','" + oModel.HColor + "','" + oModel.HVersion + "','" + oModel.HEngName + "','" + oModel.HEngModel + "'," + oModel.HPropertyTypeID.ToString() + "," + oModel.HSPGroupID.ToString() + "," + oModel.HSPID.ToString() + "," + oModel.HMinPickQty.ToString() + "," + oModel.HUSEORGID + "," + oModel.HERPItemID + "," + oModel.HSALEUNITID + "," + oModel.HSALEPRICEUNITID + "," + oModel.HBASEUNITID + "," + oModel.HSTOREUNITID + "," + oModel.HCHECKINCOMING + "," + oModel.HCHECKPRODUCT + "," + oModel.HPERUNITSTANDHOUR + "," + oModel.HSTDLABORPREPARETIME + "," + oModel.HSTDMACHINEPREPARETIME + ","+ oModel.HWidth + "," + oModel.HWeight + ",'"+ oModel.HColorRemark + "'," + oModel.HQCSchemeID_Fst + "," |
| | | + oModel.HQCSchemeID_Proc + "," + oModel.HQCSchemeID_Patrol + "" + |
| | | ",'"+ oModel.HMaterRuleType + "','"+ oModel.HColorNo + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'"+ oModel.HMaterRuleType + "','"+ oModel.HColorNo + "','" + oModel.HPieceMaxQty.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | |
| | | ",HWhID,HRoutingID,HBomID,HSecUnitID,HSecUnitRate" + |
| | | ",HHighStock,HLowStock,HSafeStock,HOrderPrice,HSalePrice" + |
| | | ",HKeepDays,HPlanPrice,HstdPrice,HQtyMin,HQtyMax" + |
| | | ",HSubjoin,HSubjoin2,HColor,HVersion,HEngName,HEngModel,HPropertyTypeID,HSPGroupID,HSPID,HMinPickQty,HCREATEORGID,HUSEORGID,HERPItemID,HBatchManager,HOldMaterNumber) " + |
| | | ",HSubjoin,HSubjoin2,HColor,HVersion,HEngName,HEngModel,HPropertyTypeID,HSPGroupID,HSPID,HMinPickQty,HCREATEORGID,HUSEORGID,HERPItemID,HBatchManager,HOldMaterNumber,HPieceMaxQty) " + |
| | | " Values('" + oModel.HItemID + "','" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | ", " + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'" + |
| | | ",'" + oModel.HModel + "'," + oModel.HUnitID.ToString() + "," + oModel.HMaterClsID.ToString() + "," + oModel.HMaterTypeID.ToString() + "," + oModel.HUnitGroupID.ToString() + |
| | | ", " + oModel.HWhID.ToString() + "," + oModel.HRoutingID.ToString() + "," + oModel.HBomID.ToString() + "," + oModel.HSecUnitID.ToString() + "," + oModel.HSecUnitRate.ToString() + |
| | | ", " + oModel.HHighStock.ToString() + "," + oModel.HLowStock.ToString() + "," + oModel.HSafeStock.ToString() + "," + oModel.HOrderPrice.ToString() + ",'" + oModel.HSalePrice + "'" + |
| | | ", " + oModel.HKeepDays.ToString() + "," + oModel.HPlanPrice.ToString() + "," + oModel.HstdPrice.ToString() + "," + oModel.HQtyMin.ToString() + "," + oModel.HQtyMax.ToString() + |
| | | ",'" + oModel.HSubjoin + "','" + oModel.HSubjoin2 + "','" + oModel.HColor + "','" + oModel.HVersion + "','" + oModel.HEngName + "','" + oModel.HEngModel + "'," + oModel.HPropertyTypeID.ToString() + "," + oModel.HSPGroupID.ToString() + "," + oModel.HSPID.ToString() + "," + oModel.HMinPickQty.ToString() + "," + oModel.HCREATEORGID + "," + oModel.HUSEORGID + "," + oModel.HERPItemID + "," + oModel.HBatchManager + ",'" + oModel.HOldMaterNumber + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'" + oModel.HSubjoin + "','" + oModel.HSubjoin2 + "','" + oModel.HColor + "','" + oModel.HVersion + "','" + oModel.HEngName + "','" + oModel.HEngModel + "'," + oModel.HPropertyTypeID.ToString() + "," + oModel.HSPGroupID.ToString() + "," + oModel.HSPID.ToString() + "," + oModel.HMinPickQty.ToString() + "," + oModel.HCREATEORGID + "," + oModel.HUSEORGID + "," + oModel.HERPItemID + "," + oModel.HBatchManager + ",'" + oModel.HOldMaterNumber + "','" + oModel.HPieceMaxQty.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | sql = "set identity_insert gy_material off"; |
| | | oCn.RunProc(sql); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | |
| | | ",HQCSchemeID_Fst= " + oModel.HQCSchemeID_Fst + |
| | | ",HQCSchemeID_Proc= " + oModel.HQCSchemeID_Proc + |
| | | ",HQCSchemeID_Patrol= " + oModel.HQCSchemeID_Patrol + |
| | | ",HPieceMaxQty=" + oModel.HPieceMaxQty.ToString() + |
| | | ",HSTDMACHINEPREPARETIME=" + oModel.HSTDMACHINEPREPARETIME.ToString() + "Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢ä¸è¯ç±»å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Model.ClsGy_BadType_Model> getObjectByJson_Gy_BadType(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Model.ClsGy_BadType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_BadType_Model>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢æ
éåå 表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | |
| | | public int HQCSchemeID_Proc; |
| | | public int HQCSchemeID_Patrol; |
| | | public string HColorNo;//é¢è²è²å· |
| | | public double HPieceMaxQty; //åä»¶æå¤§ä¸é |
| | | |
| | | } |
| | | } |
| | |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | |
| | | <publishTime>08/25/2021 10:28:25</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>11/15/2023 08:53:01</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/04/2014 04:33:56</publishTime> |
| | |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | </File> |
| | | <File Include="Config/kdapi.config"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:56</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="grpc_csharp_ext.x64.dll"> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="libgrpc_csharp_ext.x64.dylib"> |
| | | <publishTime>03/19/2022 07:38:44</publishTime> |
| | |
| | | <publishTime>03/19/2022 07:38:42</publishTime> |
| | | </File> |
| | | <File Include="libman.json"> |
| | | <publishTime>07/12/2023 08:14:21</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_Mould.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>09/25/2023 09:42:57</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.cs"> |
| | | <publishTime>12/20/2021 13:19:56</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.map"> |
| | | <publishTime>11/03/2023 22:05:51</publishTime> |
| | | <publishTime>11/01/2023 11:13:09</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/WebService1.disco"> |
| | | <publishTime>12/20/2021 13:19:56</publishTime> |
| | |
| | | <!--<add key="FileIP" value="http://localhost:8082/LuBaoAPI"/>--> |
| | | <!--<add key="FileIP" value="http://localhost:8080/" />--> |
| | | <!--<add key="sUrl" value="http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx"/> --> |
| | | <add key="sUrl" value="http://192.168.63.20/WEBS-WMS/WebService1.asmx"/><!--é¢å°å¼æº--> |
| | | <!--<add key="sUrl" value="http://192.168.63.20/WEBS-WMS/WebService1.asmx"/>--><!--é¢å°å¼æº--> |
| | | <!--<add key="sUrl" value="http://60.190.4.42:9003/WebService/WebService1.asmx" /> å¤å®--> |
| | | <!--<add key="sUrl" value="http://60.190.4.42:9003/WebService/WebService1.asmx" /> --> |
| | | <!--<add key="sUrl" value="http://10.10.130.181/WEBS-WMS/WebService1.asmx"/> åæ¥ç§æ--> |
| | |
| | | <!--<add key="sUrl" value="http://192.168.80.90:9090/WEBS-WMS/WebService1.asmx"/> å®çæå¡å¨--> |
| | | <!--<add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/> --> <!--æµè¯æå¡å¨--> |
| | | <!--<add key="sUrl" value="http://localhost:8082/WEBS/WebService1.asmx"/> æ¬å°--> |
| | | <!--<add key="sUrl" value="http://192.168.56.1:81/web/WebService1.asmx"/> éé¯éæ¬å°é
ç½®--> |
| | | <add key="sUrl" value="http://192.168.56.1:81/web/WebService1.asmx"/> <!--éé¯éæ¬å°é
ç½®--> |
| | | <add key="webpages:Version" value="3.0.0.0" /> |
| | | <add key="webpages:Enabled" value="false" /> |
| | | <add key="ClientValidationEnabled" value="true" /> |