| | |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | LogService.Write("åæ®ç±»å:" + _value); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | | List<Model.ClsXt_BillType_Model> lsmain = new List<Model.ClsXt_BillType_Model>(); |
| | |
| | | //sql = "set identity_insert Xt_BillType on"; |
| | | //oCN.RunProc(sql); |
| | | |
| | | LogService.Write("åæ®ç±»å:" + $@"insert into Xt_BillType(HBilltypeID,HNumber,HName,HTemplate,HHeadTable,HEntryTable,HViewName,HRightName) |
| | | values('{lsmain[0].HBilltypeID}','{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HTemplate}','{lsmain[0].HHeadTable}','{lsmain[0].HEntryTable}','{lsmain[0].HViewName}','{lsmain[0].HRightName}' )"); |
| | | |
| | | oCN.RunProc($@"insert into Xt_BillType(HBilltypeID,HNumber,HName,HTemplate,HHeadTable,HEntryTable,HViewName,HRightName) |
| | | values('{lsmain[0].HBilltypeID}','{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HTemplate}','{lsmain[0].HHeadTable}','{lsmain[0].HEntryTable}','{lsmain[0].HViewName}','{lsmain[0].HRightName}' )", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | LogService.Write("å¸å«:" + _value); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | | List<Model.ClsGy_Currency_Model> lsmain = new List<Model.ClsGy_Currency_Model>(); |
| | |
| | | sql = "set identity_insert Gy_Currency on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("å¸å«:" + $@"insert into Gy_Currency(HItemID,HNumber,HName,HShortNumber,HParentID |
| | | ,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HScale,HExchangeRate) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HScale}','{lsmain[0].HExchangeRate}')"); |
| | | |
| | | oCN.RunProc($@"insert into Gy_Currency(HItemID,HNumber,HName,HShortNumber,HParentID |
| | | ,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HScale,HExchangeRate) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | |
| | | try |
| | | { |
| | | var model = oMain["model"].ToString(); |
| | | LogService.Write("客æ·:" + model); |
| | | var custLocationModel = oMain["model"]["HCustLocationEntry"].ToString(); |
| | | var custContactModel = oMain["model"]["HCustContactEntry"].ToString(); |
| | | //ååºåå |
| | |
| | | oCN.RunProc(sql); |
| | | sql = "set identity_insert gy_Customer on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("客æ·:" + "Insert into Gy_Customer " + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark" + |
| | | ",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" + |
| | | ",HFax,HPostalCode,HEmail,HBank,HBankAccount" + |
| | | ",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" + |
| | | ",HEnglishAddress,HCurID,HSSID,HAreaID,HCusStatus" + |
| | | ",HEmpID,HCreditDate,HCreditRatingDate,HMaxCreditRatingDate" + |
| | | ",HMonthUseQty,HForecastCreditRating,HCreditLevelID,HCountAccrualRating" + |
| | | ",HSubsidyAccrualRating,HCreditRating,HMaxCreditRating" + |
| | | ",HCusTypeID) " + |
| | | " Values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "'," + lsmain[0].HParentID + |
| | | ", " + lsmain[0].HLevel + ",0,'" + lsmain[0].HStopFlag + "','" + lsmain[0].HRemark + "'" + |
| | | ",'" + lsmain[0].HShortName + "','" + lsmain[0].HAddress + "','" + lsmain[0].HLinkMan + "','" + lsmain[0].HLinkPhone + "','" + lsmain[0].HMobilePhone + "'" + |
| | | ",'" + lsmain[0].HFax + "','" + lsmain[0].HPostalCode + "','" + lsmain[0].HEmail + "','" + lsmain[0].HBank + "','" + lsmain[0].HBankAccount + "'" + |
| | | ",'" + lsmain[0].HTaxNum + "'," + lsmain[0].HTaxRate + ",'" + lsmain[0].HCountry + "','" + lsmain[0].HCorMan + "','" + lsmain[0].HEnglishName + "'" + |
| | | ",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID + ",'" + lsmain[0].HCusStatus + "'" + |
| | | "," + lsmain[0].HEmpID + "," + lsmain[0].HCreditDate + "," + lsmain[0].HCreditRatingDate + "," + lsmain[0].HMaxCreditRatingDate + |
| | | "," + lsmain[0].HMonthUseQty + "," + lsmain[0].HForecastCreditRating + "," + lsmain[0].HCreditLevelID + "," + lsmain[0].HCountAccrualRating + |
| | | "," + lsmain[0].HSubsidyAccrualRating + "," + lsmain[0].HCreditRating + "," + lsmain[0].HMaxCreditRating + |
| | | ", " + lsmain[0].HCusTypeID + ")"); |
| | | //主表_å®¢æ· |
| | | oCN.RunProc("Insert into Gy_Customer " + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("åä½ï¼" + msg.ToString()); |
| | | var _value = msg["model"].ToString(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | oCN.RunProc(sql); |
| | | sql = "set identity_insert Gy_Unit on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("åä½ï¼" + "Insert into Gy_Unit" + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID,HCREATEORGID) " + |
| | | " Values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "'," + lsmain[0].HParentID.ToString() + |
| | | "," + lsmain[0].HLevel.ToString() + "," + Convert.ToString(lsmain[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(lsmain[0].HStopflag ? 1 : 0) + ",'" + lsmain[0].HRemark + |
| | | "'," + lsmain[0].HRate.ToString() + "," + DBUtility.ClsPub.BoolToString(lsmain[0].HStandard) + "," + lsmain[0].HUSEORGID + "," + lsmain[0].HCREATEORGID + ")"); |
| | | |
| | | oCN.RunProc("Insert into Gy_Unit" + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID,HCREATEORGID) " + |
| | |
| | | oBill.omodel.HPlanEndDate = oItem.HPlanEndDate;// 计åå®å·¥æ¥æ |
| | | oBill.omodel.HQty = oItem.HQty;// æ°é |
| | | oBill.omodel.HBillNo = oItem.HBillNo;// åæ®å· |
| | | oBill.omodel.HProjectNum = oItem.HProjectNum;// 项ç®å· |
| | | } |
| | | |
| | | //è¡¨ä½æ°æ® |
| | |
| | | { |
| | | try |
| | | { |
| | | //LogService.Write("éå®è®¢å忥,ä¿åæ¹æ³æ§è¡å®æå¼å¸¸ï¼" + sMainSub.ToString()); |
| | | LogService.Write("éå®è®¢å忥ï¼" + sMainSub.ToString()); |
| | | var model = sMainSub["model"].ToString(); |
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
| | | |
| | |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Xs_SeOrderBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("éå®è®¢å忥ï¼" + @"Insert Into Xs_SeOrderBillMain |
| | | (HInterID, HYear, HPeriod, HBillType, HBillSubType, HDate |
| | | , HBillNo, HBillStatus |
| | | , HAddress, HSSID, HSSDate, HCusID, HCurID, HExRate |
| | | , HEmpID, HManagerID, HDeptID, HExplanation, HRemark, HInnerBillNo |
| | | , HChecker, HCheckDate, HMaker, HMakeDate, HCloseMan, HCloseDate |
| | | , HERPInterID, HERPBillType, HSALEORGID, HSALEGROUPID, HRECEIVEID, HSETTLEID |
| | | , HCHARGEID, HHEADLOCID, HRECCONTACTID, HCORRESPONDORGID, HBUSINESSTYPE) |
| | | values(" + mainList[0].HInterID + ", " + DateTime.Now.Year + ", " + DateTime.Now.Month + ", '" + 1401 + "', '" + |
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "','" + mainList[0].HAddress + "'," + mainList[0].HSSID + |
| | | ",'" + mainList[0].HSSDate + "'," + mainList[0].HCusID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + "," + mainList[0].HEmpID + "," + mainList[0].HManagerID + "," + mainList[0].HDeptID + ",'" + mainList[0].HExplanation + "','" + mainList[0].HRemark + "','" + |
| | | mainList[0].HInnerBillNo + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','" |
| | | + mainList[0].HCloseMan + "','" + mainList[0].HCloseDate + "'," + mainList[0].HERPInterID + ",'" |
| | | + mainList[0].HERPBillType + "'," + mainList[0].HSALEORGID + "," + mainList[0].HSALEGROUPID + "," + mainList[0].HRECEIVEID + "," + mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + "," + mainList[0].HHEADLOCID + "," + mainList[0].HRECCONTACTID + "," + mainList[0].HCORRESPONDORGID + ",'" + mainList[0].HBUSINESSTYPE + "'" + ")"); |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Xs_SeOrderBillMain |
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate |
| | |
| | | /// </summary> |
| | | [Route("QC_CustomerAppealReport/QC_InspectionFormReport")] |
| | | [HttpGet] |
| | | public object QC_InspectionFormReport(string sWhere) |
| | | public object QC_InspectionFormReport(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | if (sWhere == null || sWhere == "") { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æ¡ä»¶ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ds = oCN.RunProcReturn("exec h_p_QC_InspectionFormReport '" + Year + "','" + DeptName + "'", "h_p_QC_InspectionFormReport"); |
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
| | | |
| | | |
| | | string HBeginDate = dic["HBeginDate"].ToString(); |
| | | string HEndDate = dic["HEndDate"].ToString(); |
| | | int limit = int.Parse(dic["limit"].ToString()); |
| | | int HQCCheckItemID = int.Parse(dic["HQCCheckItemID"].ToString()); |
| | | int HMaterID = int.Parse(dic["HMaterID"].ToString()); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_QC_InspectionFormReport '" + HBeginDate + "','" + HEndDate + "'," + limit + "," + HQCCheckItemID + "," + HMaterID, "h_p_QC_InspectionFormReport"); |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | LogService.Write("客æ·:" + _value); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | | List<Model.ClsGy_PaymentCondition_Model> lsmain = new List<Model.ClsGy_PaymentCondition_Model>(); |
| | |
| | | sql = "set identity_insert Gy_PaymentCondition on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("客æ·:" + $@"insert into Gy_PaymentCondition(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | | ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HUseFlag}' |
| | | ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' |
| | | ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})"); |
| | | |
| | | oCN.RunProc($@"insert into Gy_PaymentCondition(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | LogService.Write("æ±ç:" + _value.ToString()); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | | List<Model.ClsGy_RateType_Model> lsmain = new List<Model.ClsGy_RateType_Model>(); |
| | |
| | | sql = "set identity_insert Gy_RateType on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("æ±ç:" + $@"insert into Gy_RateType(HItemID,HNumber,HName ,HShortNumber,HParentID ,HLevel |
| | | ,HEndFlag,HStopflag,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | | ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HUseFlag}' |
| | | ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' |
| | | ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})"); |
| | | |
| | | oCN.RunProc($@"insert into Gy_RateType(HItemID,HNumber,HName ,HShortNumber,HParentID ,HLevel |
| | | ,HEndFlag,HStopflag,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | LogService.Write("æ¶æ¬¾æ¡ä»¶:" + _value.ToString()); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | | List<Model.ClsGy_RecCondition_Model> lsmain = new List<Model.ClsGy_RecCondition_Model>(); |
| | |
| | | sql = "set identity_insert Gy_RecCondition on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("æ¶æ¬¾æ¡ä»¶:" + $@"insert into Gy_RecCondition(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | | ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HUseFlag}' |
| | | ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' |
| | | ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})"); |
| | | oCN.RunProc($@"insert into Gy_RecCondition(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("åºåç¶æï¼" + msg.ToString()); |
| | | var _value = msg["model"].ToString(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | oCN.RunProc(sql); |
| | | sql = "set identity_insert Gy_StockStatus on"; |
| | | oCN.RunProc(sql); |
| | | LogService.Write("åºåç¶æï¼" + $@"insert into Gy_StockStatus(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | | ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HUseFlag}' |
| | | ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' |
| | | ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})"); |
| | | |
| | | |
| | | oCN.RunProc($@"insert into Gy_StockStatus(HItemID,HNumber,HName ,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("ç¨çï¼" + msg.ToString()); |
| | | var _value = msg["model"].ToString(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | sql = "set identity_insert Gy_TaxRate on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("ç¨çï¼" + $@"insert into Gy_TaxRate(HItemID,HNumber,HName ,HTaxRate,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | | ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}',{lsmain[0].HTaxRate},'{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} |
| | | ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HUseFlag}' |
| | | ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' |
| | | ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})"); |
| | | |
| | | oCN.RunProc($@"insert into Gy_TaxRate(HItemID,HNumber,HName ,HTaxRate,HShortNumber ,HParentID ,HLevel |
| | | ,HEndFlag ,HStopflag ,HRemark ,HHelpCode ,HUseFlag |
| | | ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("ä½ä¸ï¼" + msg.ToString()); |
| | | var _value = msg["model"].ToString(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | oCN.RunProc(sql); |
| | | sql = "set identity_insert Gy_Work on"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("ä½ä¸ï¼" + $@"insert into Gy_Work(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID, |
| | | HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID,HWORKCENTERID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HHelpCode}','{lsmain[0].HShortNumber}', |
| | | {lsmain[0].HParentID},{lsmain[0].HLevel},{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) }, |
| | | '{lsmain[0].HRemark}','{lsmain[0].HUseFlag}',{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID},{lsmain[0].HWORKCENTERID})"); |
| | | |
| | | oCN.RunProc($@"insert into Gy_Work(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID, |
| | | HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID,HWORKCENTERID) |
| | | values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HHelpCode}','{lsmain[0].HShortNumber}', |
| | |
| | | { |
| | | try |
| | | { |
| | | //LogService.Write(sMainSub.ToString()); |
| | | LogService.Write("ç产订å"+sMainSub.ToString()); |
| | | var model = sMainSub["model"].ToString(); |
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
| | | var _model = sMainSub["model"]["HPPBOMMAINENTRY"].ToString(); |
| | |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Sc_ICMOBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | |
| | | LogService.Write("ç产订å" + @"Insert Into Sc_ICMOBillMain |
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate,HChecker,HCheckDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus |
| | | ,HOWNERID,HOWNERTYPEID) |
| | | values('3710'," + mainList[0].HInterID + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'," + mainList[0].HPRDORGID + |
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "',getdate(),'" + mainList[0].HMaker + "',getdate()" + |
| | | ",'" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HEmpID + "," + mainList[0].HCusID + |
| | | "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + |
| | | "," + mainList[0].HOWNERID + ",'" + mainList[0].HOWNERTYPEID + "') "); |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Sc_ICMOBillMain |
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |