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 Sc_MouldMoveStockStepOutBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); #region 器具分布式调出单据列表 [Route("Sc_MouldMoveStockStepOutBill/GetMouldMoveStockStepOutBillList")] [HttpGet] public object GetMouldMoveStockStepOutBill(string sWhere) { try { ds = Sc_MouldMoveStockStepOutBill(sWhere); 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; } } public static DataSet Sc_MouldMoveStockStepOutBill(string sWhere) { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMoveStockStepOutBill ", "h_v_Sc_MouldMoveStockStepOutBill"); } else { string sql1 = "select * from h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 "; string sql = sql1 + sWhere; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill"); } } #endregion #region sql语句 public static DataSet Sc_MouldOtherOutBillList_s(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList"); } #endregion #region[模具领用单编辑时获取表头数据] [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")] [HttpGet] public ApiResult Sc_MouldMoveStockStepOutBillListCheckDetai(string HID) { if (string.IsNullOrEmpty(HID)) return new ApiResult { code = -1, msg = "ID不能为空" }; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMoveStockStepOutBill where hmainid= " + HID + " ", "h_v_Sc_MouldMoveStockStepOutBill"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult { code = -1, msg = "不存在退库单号" }; return new ApiResult { code = 1, msg = "查询成功", data = dataSet }; } #endregion #region[模具领用单编辑时获取表体数据] [Route("Sc_MouldMoveStockStepOutBill/Sc_MouldMoveStockStepOutBillListCheckDetai")] [HttpGet] public object Sc_MouldMoveStockStepOutBillListProjectDetai(string sqlWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sqlWhere == null || sqlWhere.Equals("")) { 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_MouldMoveStockStepOutBill"), "h_v_Sc_MouldMoveStockStepOutBill"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } else { //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, 单价 HPrice, 金额 HMoney,HWHSonID HWHID, 发料仓库代码 HWHCode, 发料仓库 HWHName,HSPID, 仓位代码 HSPCode, 仓位 HSPName,表体备注 HRemark FROM h_v_Sc_MouldMoveStockStepOutBill where 1 = 1 "); string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMoveStockStepOutBill"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; } return objJsonResult; } #endregion // #region 模治具其他出库单 保存/编辑 // /// // /// 保存模具维修单 // /// // /// // /// // [Route("Sc_MouldOtherOutBill/SaveMouldOtherOutBillList")] // [HttpPost] // public object SaveMouldOtherOutBillList([FromBody] JObject msg) // { // var _value = msg["msg"].ToString(); // string msg1 = _value.ToString(); // string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); // string msg2 = sArray[0].ToString(); // string msg3 = sArray[1].ToString(); // string UserName = ""; // ListModels oListModels = new ListModels(); // try // { // DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill(); // List lsmain = new List(); // msg2 = msg2.Replace("\\", ""); // msg2 = msg2.Replace("\n", ""); //\n // lsmain = oListModels.getObjectByJson_Sc_MouldStockBillMain(msg2); // foreach (Model.ClsSc_MouldStockBillMain oItem in lsmain) // { // //oItem.HMaker = ""; // UserName = oItem.HMaker; //制单人 // oItem.HBillType = "3828"; // oItem.HBillSubType = "3828"; // //oItem.HInterID =0; // //oItem.HBillNo = ""; // oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期 // oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); // //oItem.HMakeDate = ""; // //oItem.HYear = ""; // //oItem.HPeriod = ""; // //oItem.HRemark = ""; // //oItem.HCycleUnit = ""; // //oItem.HCheckCycle = ""; // //oItem.HBeginDate = ""; // //oItem.HEndDate = ""; // //oItem.HInnerBillNo = ""; // //oItem.HExplanation = ""; // //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); // if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存失败！没有单据日期，无法保存！"; // objJsonResult.data = 1; // return objJsonResult; // } // oBill.omodel = oItem; // } // //表体数据 // //按 },{来拆分数组 //去掉【和】 // msg3 = msg3.Substring(1, msg3.Length - 2); // msg3 = msg3.Replace("\\", ""); // msg3 = msg3.Replace("\n", ""); //\n // //msg2 = msg2.Replace("'", "’"); // List ls = new List(); // ls = oListModels.getObjectByJson_Sc_MouldStockBillSub(msg3); // int i = 0; // foreach (Model.ClsSc_MouldStockBillSub oItemSub in ls) // { // i++; // oItemSub.HEntryID = i; // //oItemSub.HCloseMan = ""; //行关闭 // oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); // oItemSub.HCloseType = false; //关闭类型 // //oItemSub.HRemark = ""; //备注 // oItemSub.HSourceInterID = 0; // 源单主内码 // oItemSub.HSourceEntryID = 0; //源单子内码 // //oItemSub.HSourceBillNo = ""; //源单单号 // //oItemSub.HSourceBillType = ""; //源单类型 // oItemSub.HRelationQty = 0; //关联数量 // //oItemSub.HRelationMoney = 0; //关联金额 // //HMaterID = "";//配件代码 // //HUnitID = "";//单位代码 // //HQty = "";//实际用量 // //HQtyMust = "";//单位用量 // //HRemark = "";//备注 // oBill.DetailColl.Add(oItemSub); // } // //保存 // //保存完毕后处理 // bool bResult; // if (oBill.omodel.HInterID == 0) // { // // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); // } // else // { // bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); // } // if (bResult) // { // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = "保存成功！"; // //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); // objJsonResult.data = 1; // return objJsonResult; // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo; // objJsonResult.data = 1; // return objJsonResult; // } // } // catch (Exception e) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "保存失败！" + e.ToString(); // objJsonResult.data = 1; // return objJsonResult; // } // } // #endregion // #region [模治具其他出库单删除功能] // /// // /// 模具维修单删除功能 // /// // /// // [Route("Sc_MouldOtherOutBill/DeltetMouldOtherOutBillList")] // [HttpGet] // public object DeltetMouldOtherOutBillList(string HInterID) // { // //编辑权限 // //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; // // objJsonResult.Message = "无删除权限！"; // // objJsonResult.data = null; // // return objJsonResult; // //} // Int64 lngBillKey = 0; // lngBillKey = DBUtility.ClsPub.isLong(HInterID); // if (lngBillKey == 0) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "单据ID为空！"; // objJsonResult.data = null; // return objJsonResult; // } // DAL.ClsSc_MouldOtherOutBill oBill = new DAL.ClsSc_MouldOtherOutBill(); // if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) // { // if (oBill.omodel.HBillStatus > 1) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "单据当前处于不能删除状态,不能删除！"; // objJsonResult.data = null; // return objJsonResult; // } // if (oBill.omodel.HChecker != "") // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "单据已经审核,不能删除！"; // objJsonResult.data = null; // return objJsonResult; // } // bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); // if (IsDete) // { // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; // objJsonResult.data = null; // return objJsonResult; // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; // objJsonResult.data = null; // return objJsonResult; // } // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "单据未找到"; // objJsonResult.data = null; // return objJsonResult; // } // } // #endregion // #region[模治具其他出库单编辑时获取表头数据] // [Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListCheckDetai")] // [HttpGet] // public ApiResult Sc_MouldOtherOutBillListCheckDetai(string HID) // { // if (string.IsNullOrEmpty(HID)) // return new ApiResult { code = -1, msg = "ID不能为空" }; // SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); // var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherOutBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList"); // if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) // return new ApiResult { code = -1, msg = "不存在设备保养记录表" }; // return new ApiResult { code = 1, msg = "查询成功", data = dataSet }; // } // #endregion // #region[模治具其他出库单编辑时获取表题数据] // [Route("Sc_MouldOtherOutBill/Sc_MouldOtherOutBillListProjectDetai")] // [HttpGet] // public object Sc_MouldOtherOutBillListProjectDetai(string sqlWhere) // { // DataSet ds; // try // { // SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); // if (sqlWhere == null || sqlWhere.Equals("")) // { // ds = oCN.RunProcReturn(@"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark //from h_v_Sc_MouldOtherOutBillList", "h_v_Sc_MouldOtherOutBillList_Edit"); // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = "获取信息成功！"; // objJsonResult.data = ds.Tables[0]; // } // else // { // string sql1 = @"select 模具代码 HMaterID,模具名称 HMaterName,规格型号 HMaterSpec ,批次 HBatchNo,设计寿命 HDesignLife,剩余寿命 HLeaveLife,累积使用寿命 HUseLife,实发数量 HQty,单价 HPrice,金额 HMoney,模具仓库代码 HWHID,发货仓库 HWHName,表体备注 HRemark //from h_v_Sc_MouldOtherOutBillList where 1 = 1 "; // string sql = sql1 + sqlWhere; // ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList"); // objJsonResult.code = "0"; // objJsonResult.count = 1; // objJsonResult.Message = "获取信息成功！"; // objJsonResult.data = ds.Tables[0]; // } // } // catch (Exception e) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "没有返回任何计划！" + e.ToString(); // objJsonResult.data = null; // } // return objJsonResult; // } // #endregion } }