New file |
| | |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Models; |
| | | namespace WebAPI.Controllers |
| | | { |
| | | public class Gy_ICBomBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | [Route("Gy_ICBomBill/Gy_ICBomBillaveApi")] |
| | | [HttpPost] |
| | | public object Gy_ICBomBillaveApi([FromBody] JObject oMain) |
| | | { |
| | | try |
| | | { |
| | | var model = oMain["model"].ToString(); |
| | | var subModel = oMain["model"]["HENTRY"].ToString(); |
| | | //ååºåå |
| | | model = "[" + model + "]"; |
| | | List<Model.ClsGy_ICBomBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ICBomBillMain>>(model); |
| | | List<Model.ClsGy_ICBomBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ICBomBillSub>>(subModel); |
| | | string sql = string.Empty; |
| | | oCN.BeginTran(); |
| | | sql = $"delete Gy_ICBomBillMain where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Gy_ICBomBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | oCN.RunProc("Insert Into Gy_ICBomBillMain " + |
| | | "(HBillType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HMaterTypeID,HStatus" + |
| | | ",HMaterID,HParentID,HVersion,HPicNo,HPropertyID" + |
| | | ",HUnitID,HQty,HProdRate,HJump" + |
| | | ") " + |
| | | " values('" + mainList[0].HBillType + "'," + mainList[0].HInterID.ToString() + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'" + |
| | | "," + mainList[0].HYear.ToString() + "," + mainList[0].HPeriod.ToString() + ",'" + mainList[0].HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate(),'" + mainList[0].HMaterTypeID.ToString() + "','" + mainList[0].HStatus + |
| | | "','" + mainList[0].HMaterID.ToString() + "'," + mainList[0].HParentID.ToString() + ",'" + mainList[0].HVersion + "','" + mainList[0].HPicNo + "'," + mainList[0].HPropertyID.ToString() + |
| | | "," + mainList[0].HUnitID.ToString() + "," + mainList[0].HQty.ToString() + "," + mainList[0].HProdRate.ToString() + ",'" + mainList[0].HJump + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsGy_ICBomBillSub oSub in subList) |
| | | { |
| | | oCN.RunProc("Insert into Gy_ICBomBillSub " + |
| | | " (HInterID,HEntryID,HMaterID,HRemark2" + |
| | | ",HQty,HUnitID,HRemark3,HRelQty,HWasteRate" + |
| | | ",HProcID,HWhID,HRemark4,HChildType," + |
| | | "HCloseMan,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + oSub.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() + ",'" + oSub.HRemark2 + "'" + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() + ",'" + oSub.HRemark3 + "'," + oSub.HRelQty.ToString() + "," + oSub.HWasteRate.ToString() + |
| | | "," + oSub.HProcID.ToString() + "," + oSub.HWhID.ToString() + ",'" + oSub.HRemark4 + "','" + oSub.HChildType.ToString() + "'" + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ") "); |
| | | } |
| | | 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; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | var _value = msg["model"].ToString(); |
| | | var model = msg["model"].ToString(); |
| | | var stockplaceModel = msg["model"]["HStockplaceEntry"].ToString(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //ååºåå |
| | | _value = "[" + _value.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(_value); |
| | | model = "[" + model.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(model);//ä»åº |
| | | List<Gy_StockPlace> stockplaceList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_StockPlace>>(stockplaceModel);//ä»ä½ |
| | | string sql = string.Empty; |
| | | //DataTable dt = DataHelper.ListToDataTable<Warehouse>(list); |
| | | //oCN.SqlBulkCopyByDatatable("Gy_Warehouse", dt); |
| | |
| | | oCN.RunProc(sql); |
| | | oCN.RunProc("Insert into Gy_Warehouse " + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID,HCREATEORGID) " + |
| | | " Values('" + list[0].HItemID + "','" + list[0].HNumber + "','" +list[0].HName + "','" + list[0].HHelpCode + "','" + list[0].HShortNumber + "'," + list[0].HParentID.ToString() + |
| | | "," + list[0].HLevel.ToString() + "," + Convert.ToString(list[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(list[0].HStopFlag ? 1 : 0) + ",'" + list[0].HRemark + "'," + list[0].HEmpID.ToString() + ",'" + list[0].HAddress + "','" + list[0].HPhone + "','" + list[0].HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + list[0].HLevel.ToString() + "," + Convert.ToString(list[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(list[0].HStopFlag ? 1 : 0) + ",'" + list[0].HRemark + "'," + list[0].HEmpID.ToString() + ",'" + list[0].HAddress + "','" + list[0].HPhone + "','" + list[0].HUSEORGID + "','" + list[0].HCREATEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | sql = "set identity_insert Gy_Warehouse off"; |
| | | oCN.RunProc(sql); |
| | | sql = $"delete gy_stockplace where HSPGroupID in ({list[0].HItemID})"; |
| | | oCN.RunProc(sql); |
| | | sql = "set identity_insert gy_stockplace on"; |
| | | oCN.RunProc(sql); |
| | | foreach (var item in stockplaceList) |
| | | { |
| | | oCN.RunProc("Insert into gy_stockplace " + |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HSPGroupID,HSPType,HSrcSPType,HDesSPType) " + |
| | | " Values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HHelpCode + "','" + item.HShortNumber + "'," + item.HParentID.ToString() + |
| | | "," + item.HLevel.ToString() + "," + Convert.ToString(item.HEndFlag ? 1 : 0) + "," + Convert.ToString(item.HStopFlag ? 1 : 0) + ",'" + item.HRemark + "','" + item.HUSEORGID + "','" + item.HCREATEORGID + "','" + item.HSPGroupID + "','" + item.HSPType + "','" + item.HSrcSPType + "','" + item.HDesSPType + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | sql = "set identity_insert gy_stockplace off"; |
| | | oCN.RunProc(sql); |
| | | oCN.Commit(); |
| | | |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Gy_StockPlace |
| | | { |
| | | public bool HEndFlag { get; set; } |
| | | public string HHelpCode { get; set; } |
| | | public long HItemID { get; set; } |
| | | public long HLevel { get; set; } |
| | | public string HName { get; set; } |
| | | public string HNumber { get; set; } |
| | | public long HParentID { get; set; } |
| | | public string HRemark { get; set; } |
| | | public string HShortNumber { get; set; } |
| | | public bool HStopFlag { get; set; } |
| | | public string HUseFlag { get; set; } |
| | | public Int64 HEmpID { get; set; } |
| | | public string HAddress { get; set; } |
| | | public string HPhone { get; set; } |
| | | public Int64 HSPGroupID { get; set; } |
| | | public string HBarCode { get; set; } |
| | | public Int64 HUSEORGID { get; set; } |
| | | public Int64 HCREATEORGID { get; set; } |
| | | public string HMaker { get; set; } |
| | | public string HUpDater { get; set; } |
| | | public string HSPType { get; set; } |
| | | public string HSrcSPType { get; set; } |
| | | public string HDesSPType { get; set; } |
| | | } |
| | | } |
| | |
| | | public Int64 HSPGroupID { get; set; } |
| | | public string HBarCode { get; set; } |
| | | public Int64 HUSEORGID { get; set; } |
| | | public Int64 HCREATEORGID { get; set; } |
| | | public string HMaker { get; set; } |
| | | public string HUpDater { get; set; } |
| | | |
| | |
| | | <Compile Include="App_Start\WebApiConfig.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_BarCodeBillController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_ConkTypeController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_ICBomBillController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_WorkDayController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_PackTypeController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_RoutingGroupController.cs" /> |
| | |
| | | <Compile Include="Models\åºç¡èµæ\ConkType.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_Duty.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_StockPlace.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\WorkDay.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\PackType.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\WorkStation.cs" /> |