派生自 MES-WEB-API
WebAPI/Controllers/MJJY/Mj_PDA_MoudlCheckController.cs
@@ -17,13 +17,16 @@ private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; public WebS.WebService1 oWebs = new WebS.WebService1(); //public WebS.ClsGy_BarCodeBill_WMS_Model_View ds = new WebS.ClsGy_BarCodeBill_WMS_Model_View(); public Model.ClsKF_PonderationBillMain_Temp omodel = new Model.ClsKF_PonderationBillMain_Temp(); public DAL.ClsSc_MouldDotCheckBill BillNew = new DAL.ClsSc_MouldDotCheckBill(); //对应单据类 public DAL.ClsSc_MouldDotCheckBill BillOld = new DAL.ClsSc_MouldDotCheckBill(); //对应单据类 public DAL.ClsSc_MouldMaintainBill BillNew1 = new DAL.ClsSc_MouldMaintainBill(); //对应单据类 public DAL.ClsSc_MouldMaintainBill BillOld1 = new DAL.ClsSc_MouldMaintainBill(); //对应单据类 DataSet ds; #region 模治具点检记录单 @@ -32,6 +35,68 @@ [HttpGet] public object txtHBarCode_KeyDown(string HBarCode) { //try //{ // if (HBarCode == null || HBarCode.Equals("")) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "条形码不能为空！"; // objJsonResult.data = null; // return objJsonResult; // } // //得到信息 // ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould"); // //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); // //写入信息 // if (ds == null ) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "未查询到模具信息！"; // objJsonResult.data = null; // return objJsonResult; // } // else // { // omodel.HInterID = HInterID; // omodel.HBillType = "3796"; // omodel.HMaker = DBUtility.ClsPub.CurUserName; // omodel.HMaterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HMaterID"]); // omodel.HQty = 0; // omodel.HBarCode = Convert.ToString(ds.Tables[0].Rows[0]["HBarCode"]); // omodel.HWhID = HWHID; // omodel.HStockPlaceID = HSPID; // omodel.HSourceBillNo = "1"; // omodel.HSourceBillType = "1"; // omodel.HSourceEntryID = 0; // omodel.HSourceInterID = 0; // if (set_SavePonderationBillMain_Temp(omodel, ref DBUtility.ClsPub.sErrInfo)) // { // objJsonResult.code = "1"; // objJsonResult.count = 1; // objJsonResult.Message = "扫码成功！"; // objJsonResult.data = ds.Tables[0]; // return objJsonResult; // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "存入缓存表失败！"; // objJsonResult.data = null; // return objJsonResult; // } // } //} //catch (Exception e) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "Exception！" + e.ToString(); // objJsonResult.data = null; // return objJsonResult; //} try { if (HBarCode == null || HBarCode.Equals("")) @@ -44,8 +109,9 @@ } //得到信息 ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould"); //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); //写入信息 if (ds == null || ds.Tables[0].Rows.Count == 0) if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -53,11 +119,14 @@ objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { @@ -68,7 +137,118 @@ return objJsonResult; } } [Route("EquipMaintainBill/txtHBarCode")] [HttpGet] public object txtHBarCode(string HBarCode) { try { if (HBarCode == null || HBarCode.Equals("")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "条形码不能为空！"; objJsonResult.data = null; return objJsonResult; } //得到信息 ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_EquipFileMainList where 条形码 = '" + HBarCode + "'", "h_v_Gy_EquipFileMainList"); //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); //写入信息 if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未查询到设备信息！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } public bool set_SavePonderationBillMain_Temp(Model.ClsKF_PonderationBillMain_Temp oMain, ref string sErrMsg) { DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); DAL.ClsGy_BarCodeBill_View oBar = new DAL.ClsGy_BarCodeBill_View(); dal.oModel = oMain; if (!oBar.GetInfoByNumber_View(oMain.HBarCode)) { sErrMsg = "无效条码"; return false; } else { if (oBar.omodel_View.HBarCodeType == "托盘条码") { if (!dal.IsBarCode_Pack(oMain.HBarCode, oMain.HInterID, oMain.HBillType)) { sErrMsg = "存在相同条码，请勿重复扫描！"; return false; } if (dal.AddNew_More(ref sErrMsg)) { //sErrMsg = "保存成功！"; return true; } else { //sErrMsg = "保存失败！"; return false; } } else { if (oBar.omodel_View.HBarCodeType == "唯一条码") { if (!dal.IsBarCode(oMain.HBarCode, oMain.HInterID, oMain.HErpClsID, oMain.HBillType)) { sErrMsg = "存在相同条码，请勿重复扫描！"; return false; } //判断条码临时表中是否存在(调拨单同一条码相同调入调出仓库仓位只允许扫描一次，销售出库同一条码同一仓库仓位只允许扫描一次) 丸井 //if (!dal.IsBarCode(oMain.HBarCode, oMain.HInterID, oMain.HErpClsID, oMain.HBillType,oMain.HWhID,oMain.HStockPlaceID,oMain.HSCWHID,oMain.HOutStockPlaceID,oMain.)) //{ // sErrMsg = "存在相同条码，请勿重复扫描！"; // return false; //} } if (dal.AddNew(ref sErrMsg)) { //sErrMsg = "保存成功！"; return true; } else { //sErrMsg = "保存失败！"; return false; } } } //dal.oCn.CnClose(); //dal.oCn.CnDispose(); //oBar. } #endregion #region 模治具点检记录提交 @@ -112,6 +292,7 @@ //oItem.HInnerBillNo = ""; // --内部单据号 oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); oItem.HMouldID = DBUtility.ClsPub.isLong(lsmain[0].HMouldID); //oItem.HEquipID = 0; //设备ID(Gy_EquipMent) //oItem.HPeriod = 0; //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --维修日期 @@ -141,6 +322,289 @@ ls = oListModels.getObjectByJson_Gy_MouldDotCheckBillSub(msg2); int i = 0; foreach (Models.ClsSc_MouldDotCheckBillSub 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.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); //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 设备点检记录提交 [Route("Sb_EquipDotCheckBill/savebill")] [HttpPost] public object savebill([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 UserName = ""; ListModels oListModels = new ListModels(); try { DLL.ClsSb_EquipDotCheckBill oBill = new DLL.ClsSb_EquipDotCheckBill(); List<Models.ClsSb_EquipDotCheckBillMain> lsmain = new List<Models.ClsSb_EquipDotCheckBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_EquipCheckBillMain(msg2); foreach (Models.ClsSb_EquipDotCheckBillMain oItem in lsmain) { //单据号是否重复 if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复！不允许保存！"; objJsonResult.data = 1; return objJsonResult; } //oItem.HMaker = ""; UserName = oItem.HMaker; //制单人 oItem.HBillType = "3903"; oItem.HBillSubType = "3903"; //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 = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); //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; } //子表体数据 List<Models.ClsSb_EquipDotCheckBillSub> ls = new List<Models.ClsSb_EquipDotCheckBillSub>(); ls = oListModels.getObjectByJson_Gy_EquipDotCheckBillSub(msg2); int i = 0; foreach (Models.ClsSb_EquipDotCheckBillSub 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.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); //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 设备维修记录提交 [Route("Sb_EquipRepairWorkBill/savebill1")] [HttpPost] public object savebill1([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 UserName = ""; ListModels oListModels = new ListModels(); try { DLL.ClsSb_EquipRepairWorkBill oBill = new DLL.ClsSb_EquipRepairWorkBill(); List<Models.ClsSb_EquipRepairWorkBillMain> lsmain = new List<Models.ClsSb_EquipRepairWorkBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.wxmain(msg2); foreach (Models.ClsSb_EquipRepairWorkBillMain oItem in lsmain) { //单据号是否重复 if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据号重复！不允许保存！"; objJsonResult.data = 1; return objJsonResult; } //oItem.HMaker = ""; UserName = oItem.HMaker; //制单人 oItem.HBillType = "3903"; oItem.HBillSubType = "3903"; //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 = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); //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; } //子表体数据 List<Models.ClsSb_EquipRepairWorkBillSub> ls = new List<Models.ClsSb_EquipRepairWorkBillSub>(); ls = oListModels.wxsub(msg2); int i = 0; foreach (Models.ClsSb_EquipRepairWorkBillSub oItemSub in ls) { i++; @@ -214,44 +678,44 @@ #region 根据模治具条码查找模具档案信息 [Route("Mj_PDA_MouldMaintainBill/txtHBarCodeMaintain_KeyDown")] [HttpGet] public object txtHBarCodeMaintain_KeyDown(string HBarCode) { try { if (HBarCode == null || HBarCode.Equals("")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "条形码不能为空！"; objJsonResult.data = null; return objJsonResult; } //得到信息 ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HNumber= '" + HBarCode + "'", "h_v_IF_Mould"); //写入信息 if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "未查询到模具信息！"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } //public object txtHBarCodeMaintain_KeyDown(string HBarCode) //{ // try // { // if (HBarCode == null || HBarCode.Equals("")) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "条形码不能为空！"; // objJsonResult.data = null; // return objJsonResult; // } // //得到信息 // ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HNumber= '" + HBarCode + "'", "h_v_IF_Mould"); // //写入信息 // if (ds == null || ds.Tables[0].Rows.Count == 0) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "未查询到模具信息！"; // objJsonResult.data = null; // return objJsonResult; // } // objJsonResult.code = "1"; // objJsonResult.count = 1; // objJsonResult.Message = "Sucess！"; // objJsonResult.data = ds.Tables[0]; // return objJsonResult; // } // catch (Exception e) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "Exception！" + e.ToString(); // objJsonResult.data = null; // return objJsonResult; // } //} #endregion #region 模治具保养记录提交
