| WebAPI/Controllers/WebAPIController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/Xs_CutWorkSendBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Models/Xs_CutWorkSendBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Web References/WebS/Reference.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/WebAPIController.cs
@@ -780,6 +780,37 @@ } } #endregion /// <summary> /// 获取班组下拉 /// </summary> /// <returns></returns> [Route("Web/GetHGroup")] [HttpGet] public object GetHGroup() { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Gy_Group", "Gy_Group"); objjson.code = "1"; objjson.count = 1; objjson.Message = "获取成功！"; objjson.data = oDs.Tables[0]; return objjson; ; } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败！异常" + e.ToString(); objjson.data = null; return objjson; ; } } } } WebAPI/Controllers/Xs_CutWorkSendBillController.cs
New file @@ -0,0 +1,141 @@ using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { /** * 裁切派工单 */ public class Xs_CutWorkSendBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); /// <summary> /// 扫描找货单号获取相关信息 /// </summary> /// <returns></returns> [Route("Xs_CutWorkSendBill/getHSEOrderBillNo")] [HttpGet] public object getHSEOrderBillNo(string HSEOrderBillNo) { if (HSEOrderBillNo == null || ("").Equals(HSEOrderBillNo)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "请输入找货单号！"; objJsonResult.data = null; return objJsonResult; } try { ds = getHSEOrderBillNo_s(HSEOrderBillNo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 生成裁切派工单 /// </summary> /// <returns></returns> [Route("Xs_CutWorkSendBill/set_SaveCutWorkSendBill")] [HttpPost] public object set_SaveCutWorkSendBill([FromBody] JObject oMain) { string oMainData = oMain["oMain"].ToString(); oMainData = oMainData.Substring(8, oMainData.Length - 9); try { List<Xs_CutWorkSendBill> lsmain = new List<Xs_CutWorkSendBill>(); ListModels oListModels = new ListModels(); List<Xs_CutWorkSendBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xs_CutWorkSendBill>>(oMainData); int HYear = Pub_Class.ClsPub.isInt(DateTime.Now.Year); int HPeriod = Pub_Class.ClsPub.isInt(DateTime.Now.Month); string HBillType = "9191"; oCN.BeginTran(); var mainSql = "Insert Into Xs_CutWorkSendBillMain " + "(HYear,HPeriod,HBillType,HInterID,HDate" + ",HBillNo,HMaker,HMakeDate,HMainSourceBillType" + ",HGroupID)" + " values" + "(" + HYear + "," + HPeriod + ",'" + HBillType + "'," + list[0].HInterID + ",GETDATE(),'" + list[0].HBillNo + "','" + list[0].HMaker + "',GETDATE(),'1401'," + list[0].HGroupID + ")"; oCN.RunProc(mainSql); for (int i = 0; i < list.Count; i++) { var subSql = "Insert Into Xs_CutWorkSendBillSub " + "(HInterID,HBillNo_bak,HSourceInterID,HSourceBillNo,HSourceBillType" + ",HSEOrderBillNo,HSEOrderInterID)" + " values" + "(" + list[i].HInterID + ",'" + list[i].HBillNo + "'," + list[i].HMainSourceInterID + ",'" + list[i].HMainSourceBillNo + "','1401','" + list[i].HMainSourceBillNo + "'," + list[i].HMainSourceInterID + ")"; oCN.RunProc(subSql); //反写金蝶销售订单的裁切派工班组 //var HGroupSql = "update AIS20200908101915zs..T_SAL_ORDER set Group=(select HName from Gy_Group where HItemID=" + list[i].HGroupID + ") where FID = " + list[i].HMainSourceInterID + ""; //oCN.RunProc(HGroupSql); } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "生成找货单成功！单据号为：" + list[0].HBillNo; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "上传失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region sql语句 public static DataSet getHSEOrderBillNo_s(string HSEOrderBillNo) { return new SQLHelper.ClsCN().RunProcReturn( "select FID HMainSourceInterID,FBILLNO HMainSourceBillNo,1 pages,'' HMaker from AIS20200908101915zs..T_SAL_ORDER where FBILLNO ='" + HSEOrderBillNo + "'" , "AIS20200908101915zs..T_SAL_ORDER"); } #endregion } } WebAPI/Models/Xs_CutWorkSendBill.cs
New file @@ -0,0 +1,34 @@ namespace WebAPI.Models { public class Xs_CutWorkSendBill { public int HInterID { get; set; }//单据ID public string HBillNo { get; set; }//单据号 public string HMaker { get; set; }//制单人 public int HMainSourceInterID { get; set; }//源单主内码 public string HMainSourceBillNo { get; set; }//源单号 public int HGroupID { get; set; }//班组ID public string HMTONo { get; set; }//批号 public string HStatus { get; set; }//在库状态 public string HBarCode { get; set; }//条码编号 public int HWHID { get; set; }//仓库ID public string HWHName { get; set; }//仓库 public int HSPID { get; set; }//仓位ID public string HSPName { get; set; }//仓位 public string HGroup { get; set; }//班组 public int HSourceID { get; set; }//生产资源ID public string HSource { get; set; }//生产资源 public string HMakerID { get; set; }//制单人ID public double HQty { get; set; }//数量 public int HMaterID { get; set; }//物料ID public string HMaterName { get; set; }//物料名称 public string HMaterNumber { get; set; }//物料编码 public string HMaterModel { get; set; }//规格型号 public string HIsStatus { get; set; }//是否扫码 public string HBillType { get; set; }//单据类型 } } WebAPI/Properties/PublishProfiles/WEBAPI.pubxml.user
@@ -157,10 +157,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>04/14/2021 14:40:14</publishTime> <publishTime>06/09/2021 10:48:44</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>04/14/2021 14:40:14</publishTime> <publishTime>06/09/2021 10:48:44</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>02/04/2021 21:35:21</publishTime> @@ -280,61 +280,61 @@ <publishTime>01/13/2021 21:47:30</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:40</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> <publishTime>02/22/2021 09:25:21</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> <publishTime>02/22/2021 09:25:21</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> <publishTime>02/22/2021 09:25:21</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> <publishTime>02/22/2021 09:25:21</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:41</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> <publishTime>02/22/2021 09:25:20</publishTime> <publishTime>04/23/2021 13:11:40</publishTime> </File> <File Include="Web.config"> <publishTime>04/14/2021 14:40:25</publishTime> <publishTime>06/09/2021 10:48:56</publishTime> </File> </ItemGroup> </Project> WebAPI/Web References/WebS/Reference.cs
Diff too large WebAPI/WebAPI.csproj
@@ -315,6 +315,7 @@ <Compile Include="App_Start\SwaggerConfig.cs" /> <Compile Include="App_Start\WebApiConfig.cs" /> <Compile Include="Controllers\LMESController.cs" /> <Compile Include="Controllers\Xs_CutWorkSendBillController.cs" /> <Compile Include="Controllers\LookingForBillController.cs" /> <Compile Include="Controllers\NewApiController.cs" /> <Compile Include="Dapper\SqlHelper.cs" /> @@ -323,6 +324,7 @@ <Compile Include="Models\ApiConfig.cs" /> <Compile Include="Models\ApiResult.cs" /> <Compile Include="Models\DocumentsView.cs" /> <Compile Include="Models\Xs_CutWorkSendBill.cs" /> <Compile Include="Models\LookingForBill.cs" /> <Compile Include="Models\M_Department.cs" /> <Compile Include="Models\M_ProcMul.cs" />
