WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/DLL/ClsSc_MouldProdInBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/DLL/ClsSc_MouldRepairInBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/DLL/ClsSc_MouldRepairOutBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/ListModels.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/ClsSc_MouldRepairOutBillMain.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/ClsSc_MouldRepairOutBillSub.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs
New file @@ -0,0 +1,629 @@ using DBUtility; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers.MJGL { public class Sc_MouldRepairOutBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态(新增,修改,浏览,更新单价,变更) private json objJsonResult = new json(); public DataSet ds = new DataSet(); public DLL.ClsSc_MouldRepairOutBill BillNew0 = new DLL.ClsSc_MouldRepairOutBill(); //模具改制出库对应单据类 public DLL.ClsSc_MouldRepairOutBill BillOld0 = new DLL.ClsSc_MouldRepairOutBill(); //模具改制出库对应单据类 #region 模具改制出库单列表 [Route("Sc_MouldRepairOutBill/Get_MouldRepairOutBillList")] [HttpGet] public object Get_MouldRepairOutBillList(string sWhere) { try { ds = Sc_GetMouldRepairOutHouseBill(sWhere); if (ds == null) { 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; } } public static DataSet Sc_GetMouldRepairOutHouseBill(string sWhere) { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairOutBillList " + sWhere, "h_v_Sc_MouldRepairOutBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairOutBillList where 1 = 1 "; string sql = sql1 + sWhere; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); } } #endregion #region [模具改制出库单删除功能] /// <summary> /// 模具采购入库单删除功能 /// </summary> /// <returns></returns> [Route("Sc_MouldRepairOutBill/set_DeleteBill")] [HttpGet] public object set_DeleteBill(string HInterID) { ////编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sc_MouldProdInBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限!"; // objJsonResult.data = null; // return objJsonResult; //} string s = ""; 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; } DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); 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; } if (!DBUtility.Xt_BaseBillFun.Fun_AllowDeleteBill(oBill, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许删除"; objJsonResult.data = null; return objJsonResult; } bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); if (IsDete) { objJsonResult.code = "1"; 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 模具改制出库保存/编辑 /// <summary> /// 保存模具采购入库单 /// </summary> /// <param name="msg"></param> /// <returns></returns> [Route("Sc_MouldRepairOutHouseBill/SaveGetMouldRepairOutHouseBillList")] [HttpPost] public object SaveGetMouldRepairOutHouseBillList([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 refSav = sArray[2].ToString(); string UserName = ""; string s = ""; ListModels oListModels = new ListModels(); try { DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); List<Models.ClsSc_MouldRepairOutBillMain> lsmain = new List<Models.ClsSc_MouldRepairOutBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_MouldRepairOutHouseBillMain(msg2); foreach (Models.ClsSc_MouldRepairOutBillMain oItem in lsmain) { if (refSav == "Add") { //单据号是否重复 if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld0.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复!不允许保存!"; objJsonResult.data = 1; return objJsonResult; } } if (refSav == "Update") { if (BillOld0.ShowBill(oItem.HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据有误!"; objJsonResult.data = 1; return objJsonResult; } //判断是否可编辑 if (BillOld0.omodel.HChecker != "" && BillOld0.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据已经被审核,不允许修改!"; objJsonResult.data = 1; return objJsonResult; } if (BillOld0.omodel.HBillStatus > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据处于不可编辑状态,不允许修改!"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld0, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许修改"; objJsonResult.data = 1; return objJsonResult; } } //oItem.HMaker = ""; UserName = oItem.HMaker; //制单人 oItem.HBillType = "3801"; oItem.HBillSubType = "3801"; //oItem.HBillNo = ""; //单据号 //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期 //oItem.HInnerBillNo = ""; // --内部单据号 oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); //oItem.HEquipID = 0; //设备ID(Gy_EquipMent) //oItem.HPeriod = 0; //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期 //oItem.HCheckResult = ""; //验收结论--(正常,异常) //oItem.HEmpID = 0; //验收人(Gy_Employee) //oItem.HManagerID = 0; //负责人(Gy_Employee) //oItem.HDeptID = 0; //验收部门(Gy_Department) //oItem.HExplanation = ""; //摘要(故障描述) //oItem.HRemark = ""; //备注 //oItem.HMainSourceInterID = oItem.HInterID; //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<Models.ClsSc_MouldRepairOutBillSub> ls = new List<Models.ClsSc_MouldRepairOutBillSub>(); ls = oListModels.getObjectByJson_Gy_MouldRepairOutHouseBillSub(msg3); int i = 0; foreach (Models.ClsSc_MouldRepairOutBillSub oItemSub in ls) { i++; oItemSub.HEntryID = i; //oItemSub.HRepairCheckID = 0; //验收项目ID //oItemSub.HRepairCheckContent = ""; //验收内容 //oItemSub.HManagerID = 0; //负责人ID //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; //关联金额 //oItemSub.HRepairID = 0; //维修项目 //oItemSub.HRepairExplanation =""; //维修要求 //oItemSub.HMoney = 0; //维修费用 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 [模具改制出单审核、反审核] /// <summary> /// 审核 /// </summary> /// <param name="HInterID">单据ID</param> /// <param name="CurUserName">审核人</param> /// <returns></returns> [Route("Sc_MouldRepairOutBill/set_CheckBill")] [HttpGet] public object set_CheckBill(int HInterID, string CurUserName) { string ModRightNameCheck = "Sc_MouldRepairOut_SingleBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!无权限!"; objJsonResult.data = null; return objJsonResult; } //审核前判断是否允许 string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许审核"; objJsonResult.data = null; return objJsonResult; } if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID小于0!"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //查看是否已审核,关闭,作废 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //审核提交 if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 反审核 /// </summary> /// <param name="HInterID">单据ID</param> /// <param name="CurUserName">审核人</param> /// <returns></returns> [Route("Sc_MouldRepairOutBill/set_AbandonCheck")] [HttpGet] public object set_AbandonCheck(int HInterID, string CurUserName) { string ModRightNameCheck = "Sc_MouldRepairOut_SingleBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; DLL.ClsSc_MouldRepairOutBill oBill = new DLL.ClsSc_MouldRepairOutBill(); try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!无权限!"; objJsonResult.data = null; return objJsonResult; } //反审核前判断 string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许反审核"; objJsonResult.data = null; return objJsonResult; } if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID小于0!"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //查看是否已审核,关闭,作废 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次反审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能再次反审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未审核!不需要反审核!"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //反审核提交AbandonCheck if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region[模具改制出库单编辑时获取表头数据] [Route("Sc_MouldRepairOutBill/Sc_MouldRepairOutHouseBillListCheckDetai")] [HttpGet] public ApiResult<DataSet> Sc_MouldRepairOutHouseBillListCheckDetai(string HID) { if (string.IsNullOrEmpty(HID)) return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldRepairOutBillList where hmainid= " + HID + " ", "h_v_Sc_MouldRepairOutBillList"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult<DataSet> { code = -1, msg = "不存在单号" }; return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; } #endregion #region[器具改制出库单编辑时获取表体数据] [Route("Sc_MouldRepairOutBill/Sc_MouldRepairOutBillListCheckDetai1")] [HttpGet] public object Sc_MouldRepairOutBillListCheckDetai(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, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark FROM h_v_Sc_MouldRepairOutBillList"), "h_v_Sc_MouldRepairOutBillList"); 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, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark FROM h_v_Sc_MouldRepairOutBillList where 1=1 "); string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); 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 } } WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs
@@ -4485,6 +4485,223 @@ } #endregion #region [器具改制入库单审核、反审核] /// <summary> /// 审核 /// </summary> /// <param name="HInterID">单据ID</param> /// <param name="CurUserName">审核人</param> /// <returns></returns> [Route("Sc_MouldRepairInBill/set_CheckBill")] [HttpGet] public object set_CheckBill(int HInterID, string CurUserName) { string ModRightNameCheck = "Sc_MouldRepairInBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; DLL.ClsSc_MouldRepairInBill oBill = new DLL.ClsSc_MouldRepairInBill(); try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!无权限!"; objJsonResult.data = null; return objJsonResult; } //审核前判断是否允许 string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许审核"; objJsonResult.data = null; return objJsonResult; } if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID小于0!"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //查看是否已审核,关闭,作废 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能再次审核!"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //审核提交 if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// 反审核 /// </summary> /// <param name="HInterID">单据ID</param> /// <param name="CurUserName">审核人</param> /// <returns></returns> [Route("Sc_MouldRepairInBill/set_AbandonCheck")] [HttpGet] public object set_AbandonCheck(int HInterID, string CurUserName) { string ModRightNameCheck = "Sc_MouldRepairInBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; DLL.ClsSc_MouldRepairInBill oBill = new DLL.ClsSc_MouldRepairInBill(); try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!无权限!"; objJsonResult.data = null; return objJsonResult; } //反审核前判断 string s = ""; if (!DBUtility.Xt_BaseBillFun.Fun_AllowCheckBill(oBill, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + ",不允许反审核"; objJsonResult.data = null; return objJsonResult; } if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID小于0!"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //查看是否已审核,关闭,作废 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次反审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能再次反审核!"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未审核!不需要反审核!"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //反审核提交AbandonCheck if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败!" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region [器具改制入库单删除功能] /// <summary> /// 器具改制入库单删除功能 WebAPI/DLL/ClsSc_MouldProdInBill.cs
@@ -44,12 +44,12 @@ //主表 oCn.RunProc("Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HRemark,HMaker,HMakeDate" + /*"HYear, HPeriod,"*/ ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + ", " + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + /*omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" +*/ ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + WebAPI/DLL/ClsSc_MouldRepairInBill.cs
@@ -17,7 +17,7 @@ base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey = "Sc_MouldStockBillMain"; base.MvarReportTitle = "模具采购入库单"; base.MvarReportTitle = "模具改制入库单"; base.BillType = "3826"; base.HBillSubType = "3826"; } WebAPI/DLL/ClsSc_MouldRepairOutBill.cs
New file @@ -0,0 +1,186 @@ using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; namespace WebAPI.DLL { public class ClsSc_MouldRepairOutBill : DBUtility.ClsXt_BaseBill { public Models.ClsSc_MouldRepairOutBillMain omodel = new Models.ClsSc_MouldRepairOutBillMain(); public List<Models.ClsSc_MouldRepairOutBillSub> DetailColl = new List<Models.ClsSc_MouldRepairOutBillSub>(); public ClsSc_MouldRepairOutBill() { base.MvarItemKeySub = "Sc_MouldStockBillSub"; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey = "Sc_MouldStockBillMain"; base.MvarReportTitle = "模具改制出库单"; base.BillType = "3825"; base.HBillSubType = "3825"; } #region 固定代码 ~ClsSc_MouldRepairOutBill() { DetailColl = null; } #endregion 自定义方法 //新增单据 public override bool AddBill(ref string sReturn) { try { //得到mainid omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); //若MAINDI重复则重新获取 oCn.BeginTran(); //主表 oCn.RunProc("Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + ") "); //插入子表 foreach (Models.ClsSc_MouldRepairOutBillSub oSub in DetailColl) { oCn.RunProc("Insert into Sc_MouldStockBillSub " + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + ",HDesignLife,HLeaveLife,HUseLife" + ",HSCSPID,HSPGroupID,HBatchNo" + ") values(" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + ") "); } DataSet Ds; foreach (Models.ClsSc_MouldRepairOutBillSub oSub in DetailColl) { Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); if (Ds.Tables[0].Rows.Count == 0) { oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][0]) == "N") { sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]) + ", 不允许保存!"; oCn.RollBack(); return false; } } sReturn = "新增单据成功!"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //修改单据 public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) { try { // oCn.BeginTran(); //更新主表 oCn.RunProc("UpDate Sc_MouldStockBillMain set " + " HBillNo='" + omodel.HBillNo + "'" + //固定赋值=============== ",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HYear.ToString() + "'" + ",HPeriod='" + omodel.HPeriod.ToString() + "'" + ",HRemark='" + omodel.HRemark + "'" + ",HUpDater='" + omodel.HMaker + "'" + ",HUpDateDate=getdate()" + //======================================== ",HSupID=" + omodel.HSupID.ToString() + ",HWHID=" + omodel.HWHID.ToString() + ",HSCWHID=" + omodel.HSCWHID.ToString() + ",HEmpID=" + omodel.HEmpID.ToString() + ",HManagerID=" + omodel.HManagerID.ToString() + ",HSecManagerID=" + omodel.HSecManagerID.ToString() + ",HKeeperID=" + omodel.HKeeperID.ToString() + ",HDeptID=" + omodel.HDeptID.ToString() + ",HExplanation='" + omodel.HExplanation + "'" + ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + " where HInterID=" + lngBillKey.ToString()); //删除关联 DeleteRelation(ref sReturn, lngBillKey); //删除子表 DeleteBillSub(lngBillKey); //插入子表 omodel.HInterID = lngBillKey; foreach (Models.ClsSc_MouldRepairOutBillSub oSub in DetailColl) { oCn.RunProc("Insert into Sc_MouldStockBillSub " + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + ",HDesignLife,HLeaveLife,HUseLife" + ",HSCSPID,HSPGroupID,HBatchNo" + ") values(" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + ") "); } DataSet Ds; foreach (Models.ClsSc_MouldRepairOutBillSub oSub in DetailColl) { Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); if (Ds.Tables[0].Rows.Count == 0) { oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][0]) == "N") { sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]) + ", 不允许保存!"; oCn.RollBack(); return false; } } sReturn = "修改单据成功!"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } } } WebAPI/ListModels.cs
@@ -870,6 +870,29 @@ return list; } /// <summary> /// 处理新增模具改制出库单主表的json /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSc_MouldRepairOutBillMain> getObjectByJson_Gy_MouldRepairOutHouseBillMain(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSc_MouldRepairOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSc_MouldRepairOutBillMain>>(jsonString); return list; } /// <summary> /// 处理新增模具改制出库单子表的json /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSc_MouldRepairOutBillSub> getObjectByJson_Gy_MouldRepairOutHouseBillSub(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSc_MouldRepairOutBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSc_MouldRepairOutBillSub>>(jsonString); return list; } /// <summary> ///设备点检记录表 主表 ///ClsSb_EquipDotCheckBillMain public List<Model.ClsSb_EquipDotCheckBillMain> getObjectByJson_Sb_EquipDotCheckBillMain(string jsonString) WebAPI/Models/ClsSc_MouldRepairOutBillMain.cs
New file @@ -0,0 +1,23 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class ClsSc_MouldRepairOutBillMain : DBUtility.ClsXt_BaseBillMain { public long HSCWHID;// int --调出仓库ID 界面上不需要显示,存0进去 public long HSupID;// int --往来单位 界面上不需要显示,存0进去 public long HEmpID;// int --业务员 界面上不需要显示,存0进去 public long HManagerID;// int --负责人 界面上不需要显示,存0进去 public long HWHID;// int --仓库 public long HSecManagerID;// int --验收员 public long HKeeperID;// int --保管员 public long HDeptID;// int --部门 public string HExplanation;// varchar(500) --摘要 public string HInnerBillNo;// varchar(50) --内部单据号 public bool HRedBlueFlag;// bit --红蓝单 public string HRepairType; } } WebAPI/Models/ClsSc_MouldRepairOutBillSub.cs
New file @@ -0,0 +1,29 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class ClsSc_MouldRepairOutBillSub : DBUtility.ClsXt_BaseBillSub { public Int64 HMaterID;// int --物料ID public Int64 HPropertyID;// int --辅助属性 public Int64 HSecUnitID;// int --辅助计量单位 public Single HSecUnitRate;// money --换算率 public Int64 HUnitID;// int --计量单位 public string HBatchNo;// varchar(50) --批次 public double HQtyMust;// --应收数量 public double HQty;// --实收数量 public double HPrice;// --单价 public double HMoney;// --盈亏金额 public double HDesignLife;// money --设计寿命 public double HLeaveLife;// money --剩余寿命 public double HUseLife;// money --使用寿命 public long HWHID;// int --收料仓库 public long HSCWHID;// int --调出仓库ID 界面上不需要显示,存0进去 public long HSPID;// int --仓位ID public long HSCSPID;// int --调出仓位ID 界面上不需要显示,存0进去 public long HSPGroupID;// int --仓位组ID 界面上不需要显示,存0进去 } } WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -9,40 +9,40 @@ </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 16:43:40</publishTime> <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/Antlr3.Runtime.pdb"> <publishTime>02/22/2013 16:43:40</publishTime> <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>09/22/2021 15:21:02</publishTime> <publishTime>09/27/2021 16:45:11</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>09/22/2021 15:21:02</publishTime> <publishTime>09/27/2021 16:45:11</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>09/22/2021 15:20:59</publishTime> <publishTime>09/27/2021 16:45:08</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>09/22/2021 15:20:59</publishTime> <publishTime>09/27/2021 16:45:08</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>09/22/2021 15:20:55</publishTime> <publishTime>09/27/2021 16:45:04</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>09/22/2021 15:20:55</publishTime> <publishTime>09/27/2021 16:45:04</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> <publishTime>08/09/2021 15:55:13</publishTime> <publishTime>08/16/2021 17:23:13</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -51,49 +51,49 @@ <publishTime>09/20/2018 19:28:34</publishTime> </File> <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> <publishTime>03/19/2015 01:02:50</publishTime> <publishTime>03/18/2015 17:02:50</publishTime> </File> <File Include="bin/Microsoft.CSharp.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/Microsoft.Web.Infrastructure.dll"> <publishTime>07/25/2012 19:48:56</publishTime> <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>09/22/2021 15:20:56</publishTime> <publishTime>09/27/2021 16:45:05</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>09/22/2021 15:20:56</publishTime> <publishTime>09/27/2021 16:45:05</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/04/2014 04:33:56</publishTime> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>09/22/2021 15:20:53</publishTime> <publishTime>09/27/2021 16:45:02</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>09/22/2021 15:20:53</publishTime> <publishTime>09/27/2021 16:45:02</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>09/22/2021 15:20:54</publishTime> <publishTime>09/27/2021 16:45:03</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>09/22/2021 15:20:54</publishTime> <publishTime>09/27/2021 16:45:03</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>09/22/2021 15:20:54</publishTime> <publishTime>09/27/2021 16:45:03</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>09/22/2021 15:20:54</publishTime> <publishTime>09/27/2021 16:45:03</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> <publishTime>02/15/2015 17:57:08</publishTime> </File> <File Include="bin/System.ComponentModel.DataAnnotations.dll"> <publishTime>09/26/2012 03:16:08</publishTime> @@ -117,13 +117,13 @@ <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> <publishTime>08/19/2014 18:03:34</publishTime> <publishTime>08/19/2014 10:03:34</publishTime> </File> <File Include="bin/System.Net.Http.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Net.Http.Formatting.dll"> <publishTime>11/28/2018 21:00:36</publishTime> <publishTime>11/28/2018 13:00:36</publishTime> </File> <File Include="bin/System.Runtime.Serialization.dll"> <publishTime>09/26/2012 03:16:08</publishTime> @@ -132,7 +132,7 @@ <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Cors.dll"> <publishTime>11/28/2018 20:58:44</publishTime> <publishTime>11/28/2018 12:58:44</publishTime> </File> <File Include="bin/System.Web.dll"> <publishTime>09/26/2012 03:16:08</publishTime> @@ -147,37 +147,37 @@ <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Helpers.dll"> <publishTime>01/28/2015 12:04:30</publishTime> <publishTime>01/28/2015 04:04:30</publishTime> </File> <File Include="bin/System.Web.Http.Cors.dll"> <publishTime>11/28/2018 21:01:26</publishTime> <publishTime>11/28/2018 13:01:26</publishTime> </File> <File Include="bin/System.Web.Http.dll"> <publishTime>11/28/2018 21:01:00</publishTime> <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 12:02:18</publishTime> <publishTime>01/28/2015 04:02:18</publishTime> </File> <File Include="bin/System.Web.Optimization.dll"> <publishTime>02/11/2014 23:26:04</publishTime> <publishTime>02/11/2014 15:26:04</publishTime> </File> <File Include="bin/System.Web.Razor.dll"> <publishTime>01/28/2015 12:02:32</publishTime> <publishTime>01/28/2015 04:02:32</publishTime> </File> <File Include="bin/System.Web.Services.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.WebPages.Deployment.dll"> <publishTime>01/28/2015 12:04:30</publishTime> <publishTime>01/28/2015 04:04:30</publishTime> </File> <File Include="bin/System.Web.WebPages.dll"> <publishTime>01/28/2015 12:04:30</publishTime> <publishTime>01/28/2015 04:04:30</publishTime> </File> <File Include="bin/System.Web.WebPages.Razor.dll"> <publishTime>01/28/2015 12:04:30</publishTime> <publishTime>01/28/2015 04:04:30</publishTime> </File> <File Include="bin/System.Xml.dll"> <publishTime>09/26/2012 03:16:08</publishTime> @@ -186,184 +186,184 @@ <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>09/22/2021 15:21:04</publishTime> <publishTime>09/27/2021 16:45:15</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>09/22/2021 15:21:04</publishTime> <publishTime>09/27/2021 16:45:15</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> <publishTime>07/17/2013 17:03:52</publishTime> </File> <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> <publishTime>11/29/2018 21:26:02</publishTime> <publishTime>11/29/2018 13:26:02</publishTime> </File> <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> <publishTime>11/29/2018 21:26:30</publishTime> <publishTime>11/29/2018 13:26:30</publishTime> </File> <File Include="Content/bootstrap.css"> <publishTime>08/09/2021 15:55:23</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/bootstrap.min.css"> <publishTime>08/09/2021 15:55:23</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Content/Site.css"> <publishTime>08/09/2021 15:55:23</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/BLL.dll"> <publishTime>08/09/2021 15:55:23</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/DAL.dll"> <publishTime>08/09/2021 15:55:23</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/DBUtility.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Model.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Class.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/Pub_Control.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="DLL/SQLHelper.dll"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Global.asax"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Index.html"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="packages.config"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:16</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/web.config"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> <publishTime>08/09/2021 15:55:25</publishTime> <publishTime>08/16/2021 17:23:15</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> <publishTime>09/22/2021 15:21:21</publishTime> <publishTime>09/27/2021 16:45:22</publishTime> </File> </ItemGroup> </Project> WebAPI/WebAPI.csproj
@@ -323,6 +323,7 @@ <Compile Include="Controllers\MJGL\Sc_MouldProdMoveBillListController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldMoveStockStepOutBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldProdInBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldRepairOutBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldScrapInBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldOtherOutBillController.cs" /> <Compile Include="Controllers\MJJY\Mj_PDA_MoudlCheckController.cs" /> @@ -391,6 +392,7 @@ <Compile Include="DLL\ClsSc_MouldProdOutBill.cs" /> <Compile Include="DLL\ClsSc_MouldRepairCheckBill.cs" /> <Compile Include="DLL\ClsSc_MouldRepairInBill.cs" /> <Compile Include="DLL\ClsSc_MouldRepairOutBill.cs" /> <Compile Include="DLL\ClsSc_MouldScrapInBill.cs" /> <Compile Include="DLL\ClsSc_MouldScrapOutBill.cs" /> <Compile Include="DLL\ClsSc_ProcessReport.cs" /> @@ -412,6 +414,8 @@ <Compile Include="Models\ClsSc_MouldProdBillSub.cs" /> <Compile Include="Models\ClsSc_MouldRepairInBillMain.cs" /> <Compile Include="Models\ClsSc_MouldRepairInBillSub.cs" /> <Compile Include="Models\ClsSc_MouldRepairOutBillMain.cs" /> <Compile Include="Models\ClsSc_MouldRepairOutBillSub.cs" /> <Compile Include="Models\Xt_ORGANIZATIONS.cs" /> <Compile Include="Models\ClsSb_EquipRepairWorkBillSub.cs" /> <Compile Include="Models\ClsSc_ICMOBillWorkQtyStatus_Tmp.cs" /> @@ -561,6 +565,7 @@ <Folder Include="App_Data\" /> <Folder Include="Views\MoveStockBill\" /> <Folder Include="Views\QC_Management\" /> <Folder Include="Views\Sc_MouldRepairOutBill\" /> </ItemGroup> <ItemGroup> <WCFMetadata Include="Service References\" /> WebAPI/WebAPI.csproj.user
@@ -9,7 +9,7 @@ <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> <UseIISExpress>false</UseIISExpress> <Use64BitIISExpress />