| | |
|---|
| | | #region [模具档案批量生成] |
|---|
| | | [Route("Gy_Mould/SaveBatchGen_MouldFile")] |
|---|
| | | [HttpGet] |
|---|
| | | public object SaveBatchGen_MouldFile(long HInterID, string StarNum, string EndNum) |
|---|
| | | public object SaveBatchGen_MouldFile(long HInterID, string StarNum, string EndNum,string user) |
|---|
| | | { |
|---|
| | | int StarNum1 = int.Parse(StarNum); |
|---|
| | | int EndNum1 = int.Parse(EndNum); |
|---|
| | |
|---|
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID" + |
|---|
| | | ") " + |
|---|
| | | " values('3899','3899'," + HItemID + ",'" + Num1 + j + "',getdate()" + |
|---|
| | | "," + dr["HYear"] + "," + dr["HPeriod"] + ",'" + dr["HRemark"] + "','" + dr["HMaker"] + "',getdate(),'" + Num1 + j + |
|---|
| | | "," + dr["HYear"] + "," + dr["HPeriod"] + ",'" + dr["HRemark"] + "','" + user + "',getdate(),'" + Num1 + j + |
|---|
| | | "','" + Num1 + j + "','" + dr["HName"] + "','" + dr["HModel"] + "','" + dr["HModel2"] + "','" + dr["HDiameter"] + "'" + |
|---|
| | | ",'" + dr["HSubjoin"] + "','" + dr["HSubjoin2"] + "','" + dr["HPICNo"] + "','" + dr["HWorkMaterModel"] + "'" + |
|---|
| | | "," + dr["HMaterID"] + ",'" + dr["HMaterNumber"] + "',0," + dr["HUnitID"] + |
|---|
| | | "," + dr["HMaterID"] + ",'" + dr["HMaterNumber"] + "',"+dr["HMouldType"]+"," + dr["HUnitID"] + |
|---|
| | | ",'" + dr["HOutComDate"] + "','" + dr["HOutComNo"] + "'," + dr["HDeptID"] + "," + dr["HSupID"] + ",'" + dr["HSupNumber"] + "'" + |
|---|
| | | "," + dr["HPrintQty"] + ",'" + dr["HMouldStatus"] + "'," + dr["HWHID"] + "," + dr["HRoutingID"] + ",'" + dr["HCaveQty"] + |
|---|
| | | "'," + dr["HBOMID"] + ",'" + dr["HVersion"] + "'," + dr["HSPGroupID"] + "," + dr["HSPID"] + ",'" + dr["HDesignLife"] + "','" + dr["HNowSupID"] + "','" + dr["HNowSupTypeID"] + "'" + |
|---|
