派生自 MES-WEB-API
WebAPI/Controllers/WebAPIController.cs
@@ -329,6 +329,33 @@ } //删除表记录 [Route("Web/Delete_Table")] [HttpGet] public object Delete_Table(string sqlStr) { try { //SQLHelper oCn; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); oCN.RunProc(sqlStr); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！异常"; objJsonResult.data = null; return objJsonResult; } } #region 基础资料 /// <summary> /// 获取仓库列表 @@ -677,6 +704,111 @@ return objjson; } } /// <summary> /// 获取物料列表 /// </summary> /// <returns></returns> [Route("Web/GetMaterialList_Json")] [HttpGet] public object GetMaterialList_Json(string Material) { sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Material != "") { sWhere = sWhere + " and ( HNumber like '%" + Material + "%' or HName like '%" + Material + "%' ) "; } try { ds = webserver.GetMaterialList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取单位列表 /// </summary> /// <returns></returns> [Route("Web/GetUnitList_Json")] [HttpGet] public object GetUnitList_Json(string Unit) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Unit != "") { sWhere = sWhere + " and ( HNumber like '%" + Unit + "%' or HName like '%" + Unit + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_Unit where HStopflag=0 Order by HItemID ", "Gy_Unit"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_Unit where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_Unit"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取客户列表 /// </summary> @@ -721,6 +853,241 @@ return objjson; } } /// <summary> /// 获取工序列表 /// <summary> ///参数：string sql。 ///返回值：object。 /// </summary> [Route("Web/GetProcList_Json")] [HttpGet] public object GetProcList_Json(string sWhere) { DataSet ds; //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (sWhere != "") { sWhere = sWhere + " and ( HNumber like '%" + sWhere + "%' or HName like '%" + sWhere + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("Select HItemID,HNumber 工序代码,HName 工序 from Gy_Process where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Process"); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败"; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception e) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + e.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取当前数据库名 /// </summary> /// <returns></returns> [Route("Web/GetDataBases")] [HttpGet] public object GetDataBases() { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid)", "SysDataBases"); 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; ; } } /// <summary> /// 获取不良原因列表 /// </summary> /// <returns></returns> [Route("Web/GetBadReasonList_Json")] [HttpGet] public object GetBadReasonList_Json(string BadReason) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (BadReason != "") { sWhere = sWhere + " and ( HNumber like '%" + BadReason + "%' or HName like '%" + BadReason + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_BadReason where HStopflag=0 Order by HItemID ", "Gy_BadReason"); } else { string sql1 = "Select HItemID,HNumber ,HName from Gy_BadReason where HStopflag=0 and HEndFlag=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "Gy_BadReason"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取工序计划单列表 /// </summary> /// <returns></returns> [Route("Web/GetPlanList_Json")] [HttpGet] public object GetPlanList_Json(string Billno) { //sWhere = " Where HStopFlag=0 and HEndFlag=1"; //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); if (Billno != "") { sWhere = sWhere + " and ( 单据号 like '%" + Billno + "%' ) "; } try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList", "h_v_Sc_ProcessPlanList"); } else { string sql1 = "select hmainid,hsubid,单据号,HMaterID,物料代码,物料名称,HCenterID,工作中心,规格型号,计划数量 from h_v_Sc_ProcessPlanList where 1=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessPlanList"); } //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); if (ds == null || ds.Tables[0].Rows.Count <= 0) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; objjson.data = null; return objjson; } else { objjson.code = "0"; objjson.count = 1; objjson.Message = "获取成功!"; objjson.data = ds.Tables[0]; return objjson; } } catch (Exception ex) { objjson.code = "0"; objjson.count = 0; objjson.Message = "获取失败" + ex.ToString(); objjson.data = null; return objjson; } } /// <summary> /// 获取登录页组织列 /// </summary> /// <returns></returns> [Route("Web/GetOrganizations")] [HttpGet] public object GetOrganizations() { try { ClsCN oCn = new ClsCN(); DataSet oDs = new DataSet(); //========== oDs = oCn.RunProcReturn("select HItemID ID,Hname Name,HStopflag Stopflag from Xt_ORGANIZATIONS", "Xt_ORGANIZATIONS"); 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; ; } } #endregion }
