| | |
| | | " (HInterID,HEntryID," + |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HQty,HMaterID,HMaterNumber,HUnitID,HUnitNumber,HQtyMust" + |
| | | "HManagerID,HManagerNumber" + |
| | | "HQty,HMaterID,HMaterNumber,HUnitID,HUnitNumber,HQtyMust," + |
| | | "HManagerID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HMaterID.ToString() + ",'" + oSub.HMaterNumber + "'," + oSub.HUnitID.ToString() + ",'" + oSub.HUnitNumber + "'," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "'" + |
| | | "," + oSub.HManagerID.ToString() + |
| | | ") "); |
| | | } |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID, HOtherOrgID,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldMoveStockStepInBillListDetail"), "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepInBillListDetail"), "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID, HOtherOrgID,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldMoveStockStepInBillListDetail where 1 = 1 "); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepInBillListDetail where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepInBillListDetail"); |
| | | |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID,è°å
¥ç»ç»ä»£ç HStockOrgCode,è°å
¥ç»ç» HStockOrgName, HOtherOrgID ,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID,è°å
¥ç»ç»ä»£ç HStockOrgCode,è°å
¥ç»ç» HStockOrgName, HOtherOrgID,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 "); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill"); |
| | | |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldOtherOutBillList"), "h_v_Sc_MouldOtherOutBillList"); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldOtherOutBillList"), "h_v_Sc_MouldOtherOutBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldOtherOutBillList where 1 = 1 "); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldOtherOutBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList"); |
| | | |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, åä»· HPrice, éé¢ HMoney,hwhid1 HWHID, æ¶æä»åºä»£ç HWHCode,æ¶æä»åº HWHName, |
| | | HSPID, æ¶æä»ä½ä»£ç HSPCode,æ¶æä»ä½ HSPName,表ä½å¤æ³¨ HRemark |
| | | HSPID, æ¶æä»ä½ä»£ç HSPCode,æ¶æä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldProdInHouseBillList"), "h_v_Sc_MouldProdInHouseBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, åä»· HPrice, éé¢ HMoney,hwhid1 HWHID, æ¶æä»åºä»£ç HWHCode,æ¶æä»åº HWHName, |
| | | HSPID, æ¶æä»ä½ä»£ç HSPCode,æ¶æä»ä½ HSPName,表ä½å¤æ³¨ HRemark |
| | | HSPID, æ¶æä»ä½ä»£ç HSPCode,æ¶æä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldProdInHouseBillList where 1=1"); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList"); |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID,è°å
¥ç»ç»ä»£ç HStockOrgCode,è°å
¥ç»ç» HStockOrgName, HOtherOrgID ,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdMoveBillList"), "h_v_Sc_MouldProdMoveBillList"); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdMoveBillList"), "h_v_Sc_MouldProdMoveBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HStockOrgID,è°å
¥ç»ç»ä»£ç HStockOrgCode,è°å
¥ç»ç» HStockOrgName, HOtherOrgID ,è°åºç»ç»ä»£ç HOtherOrgCode,è°åºç»ç» HOtherOrgName, HWHID, è°å
¥ä»åºä»£ç HWHCode, è°å
¥ä»åº HWHName,HSPID, |
| | | è°å
¥ä»ä½ä»£ç HSPCode, è°å
¥ä»ä½ HSPName,HSCWHID, è°åºä»åºä»£ç HSCWHCode, è°åºä»åº HSCWHName,HSCSPID, |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdMoveBillList where 1 = 1 "); |
| | | è°åºä»ä½ä»£ç HSCSPCode, è°åºä»ä½ HSCSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdMoveBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdMoveBillList"); |
| | | |
| | |
| | | { |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairOutBillList"), "h_v_Sc_MouldRepairOutBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | |
| | | //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 "; |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairOutBillList where 1=1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = Sc_GetEquipTypeList(sWhere); |
| | | ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_EquipFileType where 1=1 " + sWhere, "Gy_EquipFileType"); |
| | | if (ds == null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | public static DataSet Sc_GetEquipTypeList(string sWhere) |
| | | { |
| | | string sql1 = string.Format(@"select * from h_v_Gy_EquipTypeList"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by HItemID desc", "h_v_Gy_EquipTypeList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by HItemID desc"; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_EquipTypeList"); |
| | | } |
| | | |
| | | } |
| | | |
| | | #endregion |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region 设å¤åç±»ä¿å/ç¼è¾ |
| | | [Route("Gy_EquipType/SaveEquipTypeList")] |
| | | #region 模治å
·åç±»æ°å¢ä¿å |
| | | /// <summary> |
| | | /// 模治å
·åç±»-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_EquipType/AddBill")] |
| | | [HttpPost] |
| | | public object SaveEquipTypeList([FromBody] JObject msg) |
| | | public object AddBill([FromBody] JObject oMain) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string refSav = sArray[1].ToString(); |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DLL.ClsGy_EquipTypeBill oBill = new DLL.ClsGy_EquipTypeBill(); |
| | | List<Models.ClsGy_EquipFileType> lsmain = new List<Models.ClsGy_EquipFileType>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Gy_EquipFileType(msg2); |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | |
| | | long HItemID = lsmain[0].HItemID; |
| | | string HNumber = lsmain[0].HNumber; |
| | | string HName = lsmain[0].HName; |
| | | string HShortNumber = lsmain[0].HNumber; |
| | | long HParentID = lsmain[0].HParentID; |
| | | long HLevel = lsmain[0].HLevel; |
| | | string HHelpCode = lsmain[0].HHelpCode; |
| | | string HRemark = lsmain[0].HRemark; |
| | | bool HStopflag = lsmain[0].HStopflag; |
| | | string HUseFlag = lsmain[0].HUseFlag; |
| | | bool HEndFlag = lsmain[0].HEndFlag; |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | |
| | | if (refSav == "Add") |
| | | List<Models.ClsGy_EquipFileType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileType>>(msg2); |
| | | |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HNumber; |
| | | long HParentID = list[0].HParentID; |
| | | long HLevel = list[0].HLevel; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | bool HEndFlag = list[0].HEndFlag; |
| | | |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | { |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert into Gy_EquipFileType " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID + |
| | | "," + HLevel + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_EquipFileType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°å¢æåï¼"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (refSav == "Update") |
| | | { |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Gy_EquipFileType set " + |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HShortNumber='" +HShortNumber + "'" + |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HParentID=" + HParentID + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Gy_EquipFileType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿®æ¹æåï¼"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert into Gy_EquipFileType " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID + |
| | | "," + HLevel + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_EquipFileType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°å¢æåï¼"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return false; |
| | | } |
| | | #endregion |
| | | |
| | | #region 模治å
·å类修æ¹ä¿å |
| | | /// <summary> |
| | | /// ä¿®æ¹åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_EquipType/EditBill")] |
| | | [HttpPost] |
| | | public object EditBill([FromBody] JObject oMain) |
| | | { |
| | | |
| | | try |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Models.ClsGy_EquipFileType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileType>>(msg2); |
| | | |
| | | long HItemID = int.Parse(msg3); |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HNumber; |
| | | long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DataSet DS = oCN.RunProcReturn("Select * from Gy_EquipFileType Where HStopflag=0 and HNumber='" + HItemID + "' and HItemID<>" + HNumber, "Gy_EquipFileType", ref Pub_Class.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count != 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç éå¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Gy_EquipFileType set " + |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HShortNumber='" + HShortNumber + "'" + |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HParentID=" + HParentID + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Gy_EquipFileType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿®æ¹æåï¼"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | |
| | | { |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairInBillList"), "h_v_Sc_MouldRepairInBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | |
| | | //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 "; |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec, |
| | | æ¹æ¬¡ HBatchNo,è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife,åºæ¶æ°é HQtyMust, |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark |
| | | 宿¶æ°é HQty, HWHID, ä»åºä»£ç HWHCode,ä»åº HWHName,å夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairInBillList where 1=1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList"); |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldOtherInBillList"), "h_v_Sc_MouldOtherInBillList"); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList"), "h_v_Sc_MouldOtherInBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldOtherInBillList where 1 = 1 "); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldOtherInBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherInBillList"); |
| | | |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,HPropertyID,è¾
å©å±æ§ä»£ç HPropertyCode,è¾
å©å±æ§åç§° HPropertyName, |
| | | HSecUnitID, è¾
å©è®¡éåä½ä»£ç HSecUnitCode, è¾
å©è®¡éåä½åç§° HSecUnitName, HUnitID, 计éåä½ä»£ç HUnitCode, 计éåä½åç§° HUnitName, æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife, 宿¶æ°é HQty, åä»· HPrice, éé¢ HMoney, HWHID, æ¶æä»åºä»£ç HWHCode, æ¶æä»åºåç§° HWHName, |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldScrapInHouseBillList"), "h_v_Sc_MouldScrapInHouseBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,HPropertyID,è¾
å©å±æ§ä»£ç HPropertyCode,è¾
å©å±æ§åç§° HPropertyName, |
| | | HSecUnitID, è¾
å©è®¡éåä½ä»£ç HSecUnitCode, è¾
å©è®¡éåä½åç§° HSecUnitName, HUnitID, 计éåä½ä»£ç HUnitCode, 计éåä½åç§° HUnitName, æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife, 宿¶æ°é HQty, åä»· HPrice, éé¢ HMoney, HWHID, æ¶æä»åºä»£ç HWHCode, æ¶æä»åºåç§° HWHName, |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldScrapInHouseBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapInHouseBillList"); |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,HPropertyID,è¾
å©å±æ§ä»£ç HPropertyCode,è¾
å©å±æ§åç§° HPropertyName, |
| | | HSecUnitID, è¾
å©è®¡éåä½ä»£ç HSecUnitCode, è¾
å©è®¡éåä½åç§° HSecUnitName, æ¢ç®ç HSecUnitRate, HUnitID, 计éåä½ä»£ç HUnitCode, 计éåä½åç§° HUnitName, æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife, å®åæ°é HQty, åä»· HPrice, éé¢ HMoney, HWHID, åè´§ä»åºä»£ç HWHCode, åè´§ä»åºåç§° HWHName, |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark FROM h_v_Sc_MouldScrapOutHouseBillList"), "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldScrapOutHouseBillList"), "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,HPropertyID,è¾
å©å±æ§ä»£ç HPropertyCode,è¾
å©å±æ§åç§° HPropertyName, |
| | | HSecUnitID, è¾
å©è®¡éåä½ä»£ç HSecUnitCode, è¾
å©è®¡éåä½åç§° HSecUnitName, æ¢ç®ç HSecUnitRate, HUnitID, 计éåä½ä»£ç HUnitCode, 计éåä½åç§° HUnitName, æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 使ç¨å¯¿å½ HUseLife, å®åæ°é HQty, åä»· HPrice, éé¢ HMoney, HWHID, åè´§ä»åºä»£ç HWHCode, åè´§ä»åºåç§° HWHName, |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark FROM h_v_Sc_MouldScrapOutHouseBillList where 1 = 1 "); |
| | | HSPID, ä»ä½ä»£ç HSPCode, ä»ä½åç§° HSPName, 夿³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldScrapOutHouseBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList"); |
| | | |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdBackBillList"), "h_v_Sc_MouldProdBackBillList"); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdBackBillList"), "h_v_Sc_MouldProdBackBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdBackBillList where 1 = 1 "); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdBackBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdBackBillList"); |
| | | |
| | |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdOutHouseBillList"), "h_v_Sc_MouldProdOutHouseBillList"); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdOutHouseBillList"), "h_v_Sc_MouldProdOutHouseBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string sql1 = string.Format(@"SELECT HMaterID,模å
·ä»£ç HMaterCode,模å
·åç§° HMaterName,è§æ ¼åå· HMaterSpec,æ¹æ¬¡ HBatchNo, |
| | | è®¾è®¡å¯¿å½ HDesignLife, å©ä½å¯¿å½ HLeaveLife, 累积使ç¨å¯¿å½ HUseLife, åºåæ°é HQtyMust, å®åæ°é HQty, |
| | | åä»· HPrice, éé¢ HMoney,HWHSonID HWHID, åæä»åºä»£ç HWHCode, åæä»åº HWHName,HSPID, |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark FROM h_v_Sc_MouldProdOutHouseBillList where 1 = 1 "); |
| | | ä»ä½ä»£ç HSPCode, ä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID FROM h_v_Sc_MouldProdOutHouseBillList where 1 = 1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList"); |
| | | |
| | |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HStockOrgID,HOtherOrgID" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HStockOrgID,HOtherOrgID"+ |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | |
| | | //",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | //",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | ",HNewModel,HWallThickness,HHardness,HLastProdModel,HDiameter,HBackFlag" + |
| | | ",HQtyRel" + |
| | | ",HQtyRel,HStockOrgID" + |
| | | |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | |
| | | //"," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + |
| | | //"," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | ",'" + oSub.HNewModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HLastProdModel + "','" + oSub.HDiameter + "','" + oSub.HBackFlag + "'" + |
| | | "," + 0 + |
| | | "," + 0 + "," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | DataSet Ds; |
| | |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | DataSet Ds; |
| | |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HStockOrgID.ToString() + |
| | | ") "); |
| | | } |
| | | DataSet Ds; |
| | |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HStockOrgID" + |
| | | //",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + |
| | | //",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | //",HNewModel,HWallThickness,HHardness,HLastProdModel,HDiameter,HBackFlag" + |
| | |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HStockOrgID.ToString() + |
| | | //"," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + |
| | | //"," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" + |
| | | //",'" + oSub.HNewModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HLastProdModel + "','" + oSub.HDiameter + "','" + oSub.HBackFlag + "'" + |
| | |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HUseLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HUseLife,HStockOrgID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HUseLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HUseLife.ToString() + "," + oSub.HStockOrgID.ToString() + |
| | | |
| | | ") "); |
| | | |
| | |
| | | public bool HStopflag; //ç¦ç¨æ å¿ bit |
| | | public string HRemark; //夿³¨ varchar(50) |
| | | public string HHelpCode; //å©è®°ç varchar(20) |
| | | public string HUseFlag; //使ç¨ç¶æï¼æªæ£æµï¼æªä½¿ç¨ï¼å·²ä½¿ç¨ï¼ |
| | | public string HUseFlag="æªä½¿ç¨"; //使ç¨ç¶æï¼æªæ£æµï¼æªä½¿ç¨ï¼å·²ä½¿ç¨ï¼ |
| | | public DateTime HMakeTime; //å»ºç«æ¶é´(getdate()) |
| | | public string HMakeEmp; //å建人 |
| | | public string HCheckEmp; //å®¡æ ¸äºº |
| | |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.pdb"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>10/20/2021 14:32:02</publishTime> |
| | | <publishTime>10/21/2021 18:45:37</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>10/20/2021 14:32:02</publishTime> |
| | | <publishTime>10/21/2021 18:45:37</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>10/20/2021 14:32:01</publishTime> |
| | | <publishTime>10/21/2021 18:45:35</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>10/20/2021 14:32:01</publishTime> |
| | | <publishTime>10/21/2021 18:45:35</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>10/20/2021 14:32:00</publishTime> |
| | | <publishTime>10/21/2021 18:45:30</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>10/20/2021 14:32:00</publishTime> |
| | | <publishTime>10/21/2021 18:45:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Interop.gregn6Lib.dll"> |
| | | <publishTime>08/25/2021 10:28:25</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>08/25/2021 20:46:09</publishTime> |
| | | <publishTime>08/16/2021 17:23:13</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>09/20/2018 19:28:34</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> |
| | | <publishTime>03/19/2015 01:02:50</publishTime> |
| | | <publishTime>03/18/2015 17: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 19:48:56</publishTime> |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>10/20/2021 14:32:00</publishTime> |
| | | <publishTime>10/21/2021 18:45:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>10/20/2021 14:32:00</publishTime> |
| | | <publishTime>10/21/2021 18:45:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/04/2014 04:33:56</publishTime> |
| | | <publishTime>08/03/2014 20:33:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>10/20/2021 14:31:58</publishTime> |
| | | <publishTime>10/21/2021 18:45:27</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>10/20/2021 14:31:58</publishTime> |
| | | <publishTime>10/21/2021 18:45:27</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>10/20/2021 14:31:59</publishTime> |
| | | <publishTime>10/21/2021 18:45:28</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>10/20/2021 14:31:59</publishTime> |
| | | <publishTime>10/21/2021 18:45:28</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>10/20/2021 14:31:59</publishTime> |
| | | <publishTime>10/21/2021 18:45:28</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>10/20/2021 14:31:59</publishTime> |
| | | <publishTime>10/21/2021 18:45:28</publishTime> |
| | | </File> |
| | | <File Include="bin/stdole.dll"> |
| | | <publishTime>05/09/2021 13:35:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | <publishTime>02/15/2015 17:57:08</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 18:03:34</publishTime> |
| | | <publishTime>08/19/2014 10:03: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.Formatting.dll"> |
| | | <publishTime>11/28/2018 21:00:36</publishTime> |
| | | <publishTime>11/28/2018 13:00:36</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 20:58:44</publishTime> |
| | | <publishTime>11/28/2018 12: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 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.Cors.dll"> |
| | | <publishTime>11/28/2018 21:01:26</publishTime> |
| | | <publishTime>11/28/2018 13:01:26</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.dll"> |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Optimization.dll"> |
| | | <publishTime>02/11/2014 23:26:04</publishTime> |
| | | <publishTime>02/11/2014 15:26:04</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Razor.dll"> |
| | | <publishTime>01/28/2015 12:02:32</publishTime> |
| | | <publishTime>01/28/2015 04: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 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Razor.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04: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/WebActivatorEx.dll"> |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>10/20/2021 14:32:04</publishTime> |
| | | <publishTime>10/21/2021 18:45:41</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>10/20/2021 14:32:04</publishTime> |
| | | <publishTime>10/21/2021 18:45:41</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |
| | | <publishTime>07/17/2013 17:03:52</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:02</publishTime> |
| | | <publishTime>11/29/2018 13:26:02</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | <publishTime>11/29/2018 13:26:30</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.map"> |
| | | <publishTime>08/06/2021 22:57:28</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>10/20/2021 14:32:09</publishTime> |
| | | <publishTime>10/21/2021 18:46:44</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> |
| | | <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Gitä»åº\æºäºè¿æ\项ç®\MESWMS\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>false</UseIISExpress> |
| | | <Use64BitIISExpress /> |