| | |
| | | public DataSet ds = new DataSet(); |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态(新增,修改,浏览,更新单价,变更) |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | public DAL.ClsSb_EquipDotCheckBill BillNew = new DAL.ClsSb_EquipDotCheckBill(); //对应单据类 |
| | | public DAL.ClsSb_EquipDotCheckBill BillOld = new DAL.ClsSb_EquipDotCheckBill(); //对应单据类 |
| | | public DAL.ClsSb_EquipPatrolCheckBill BillNew = new DAL.ClsSb_EquipPatrolCheckBill(); //对应单据类 |
| | | public DAL.ClsSb_EquipPatrolCheckBill BillOld = new DAL.ClsSb_EquipPatrolCheckBill(); //对应单据类 |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); //获取系统参数 |
| | | string fileip = System.Configuration.ConfigurationManager.AppSettings["FileIP"]; |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | #region 设备点检记录分页查询 |
| | | [Route("Sb_EquipDotCheckBill/GetEquipDotCheckBillListPage")] |
| | | #region 设备巡检记录分页查询 |
| | | [Route("Sb_EquipPatrolCheckBill/GetEquipPatrolCheckBillListPage")] |
| | | [HttpGet] |
| | | public object GetEquipDotCheckBillListPage(string sWhere, string user, int page, int size) |
| | | public object GetEquipPatrolCheckBillListPage(string sWhere, string user, int page, int size) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //编辑权限 |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipDotCheckBillList", 1, false, user)) |
| | | |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipPatrolCheckBillList", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | sWhere = sWhere.Replace("'", "''"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_Sb_EquipDotCheckBillListPage " + page + "," + size + ",''", "h_p_Sb_EquipDotCheckBillListPage"); |
| | | ds = oCN.RunProcReturn("exec h_p_Sb_EquipPatrolCheckBillListPage " + page + "," + size + ",''", "h_p_Sb_EquipPatrolCheckBillListPage"); |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("exec h_p_Sb_EquipDotCheckBillListPage " + page + "," + size + ",'" + sWhere + "'", "h_p_Sb_EquipDotCheckBillListPage"); |
| | | ds = oCN.RunProcReturn("exec h_p_Sb_EquipPatrolCheckBillListPage " + page + "," + size + ",'" + sWhere + "'", "h_p_Sb_EquipPatrolCheckBillListPage"); |
| | | } |
| | | |
| | | //添加列名 |
| | |
| | | #region sql语句 |
| | | |
| | | |
| | | public static DataSet Sb_EquipDotCheckBillList_s(string sWhere) |
| | | public static DataSet Sb_EquipPatrolCheckBillList_s(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipDotCheckBillList ", "h_v_Sb_EquipDotCheckBillList"); |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipPatrolCheckBillList ", "h_v_Sb_EquipPatrolCheckBillList"); |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检记录表 保存/编辑 |
| | | #region 设备巡检记录表 保存/编辑 |
| | | /// <summary> |
| | | /// 点检记录表 保存 |
| | | /// 巡检记录表 保存 |
| | | /// </summary> |
| | | /// <param name="msg"></param> |
| | | /// <returns></returns> |
| | | [Route("Sb_EquipDotCheckBill/SaveEquipDotCheckBillList")] |
| | | [Route("Sb_EquipPatrolCheckBill/SaveEquipPatrolCheckBillList")] |
| | | [HttpPost] |
| | | public object SaveEquipDotCheckBillList([FromBody] JObject msg) |
| | | public object SaveEquipPatrolCheckBillList([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckBill_Edit", 1, false, msg4)) |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipPatrolCheckBill_Edit", 1, false, msg4)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DAL.ClsSb_EquipDotCheckBill oBill = new DAL.ClsSb_EquipDotCheckBill(); |
| | | List<Model.ClsSb_EquipDotCheckBillMain> lsmain = new List<Model.ClsSb_EquipDotCheckBillMain>(); |
| | | DAL.ClsSb_EquipPatrolCheckBill oBill = new DAL.ClsSb_EquipPatrolCheckBill(); |
| | | List<Model.ClsSb_EquipPatrolCheckBillMain> lsmain = new List<Model.ClsSb_EquipPatrolCheckBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Sb_EquipDotCheckBillMain(msg2); |
| | | foreach (Model.ClsSb_EquipDotCheckBillMain oItem in lsmain) |
| | | lsmain = oListModels.getObjectByJson_Sb_EquipPatrolCheckBillMain(msg2); |
| | | foreach (Model.ClsSb_EquipPatrolCheckBillMain oItem in lsmain) |
| | | { |
| | | //oItem.HMaker = ""; |
| | | UserName = oItem.HMaker; //制单人 |
| | |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | //msg2 = msg2.Replace("'", "’"); |
| | | List<Model.ClsSb_EquipDotCheckBillSub> ls = new List<Model.ClsSb_EquipDotCheckBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sb_EquipDotCheckBillSub(msg3); |
| | | List<Model.ClsSb_EquipPatrolCheckBillSub> ls = new List<Model.ClsSb_EquipPatrolCheckBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sb_EquipPatrolCheckBillSub(msg3); |
| | | int i = 0; |
| | | foreach (Model.ClsSb_EquipDotCheckBillSub oItemSub in ls) |
| | | foreach (Model.ClsSb_EquipPatrolCheckBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region [设备点检记录表删除功能] |
| | | #region [设备巡检记录表删除功能] |
| | | /// <summary> |
| | | /// 模具维修单删除功能 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Sb_EquipDotCheckBill/DeltetEquipDotCheckBillList")] |
| | | [Route("Sb_EquipPatrolCheckBill/DeltetEquipPatrolCheckBillList")] |
| | | [HttpGet] |
| | | public object DeltetEquipDotCheckBillList(string HInterID,string user) |
| | | public object DeltetEquipPatrolCheckBillList(string HInterID,string user) |
| | | { |
| | | //编辑权限 |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipDotCheckBill_Delete", 1, false, user)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipPatrolCheckBill_Delete", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | DAL.ClsSb_EquipDotCheckBill oBill = new DAL.ClsSb_EquipDotCheckBill(); |
| | | DAL.ClsSb_EquipPatrolCheckBill oBill = new DAL.ClsSb_EquipPatrolCheckBill(); |
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HBillStatus > 1) |
| | |
| | | } |
| | | |
| | | //删除前控制 |
| | | DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_Sb_EquipDotCheckBill_BeforeDelCtrl " + HInterID.ToString() + ",'" + user + "'", "h_p_Sb_EquipDotCheckBill_BeforeDelCtrl"); |
| | | DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_Sb_EquipPatrolCheckBill_BeforeDelCtrl " + HInterID.ToString() + ",'" + user + "'", "h_p_Sb_EquipPatrolCheckBill_BeforeDelCtrl"); |
| | | if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | } |
| | | |
| | | bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterDelCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Sb_EquipPatrolCheckBill_AfterDelCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (IsDete) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region[设备点检记录表编辑时获取表头数据] |
| | | [Route("Sb_EquipDotCheckBill/Sb_EquipDotCheckBillListCheckDetai")] |
| | | #region[设备巡检记录表编辑时获取表头数据] |
| | | [Route("Sb_EquipPatrolCheckBill/Sb_EquipPatrolCheckBillListCheckDetai")] |
| | | [HttpGet] |
| | | public ApiResult<DataSet> Sb_EquipDotCheckBillListCheckDetai(string HID) |
| | | public ApiResult<DataSet> Sb_EquipPatrolCheckBillListCheckDetai(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_Sb_EquipDotCheckBill_Edit2 where hmainid= " + HID + " ", "h_v_Sb_EquipDotCheckBill_Edit2"); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipPatrolCheckBill_Edit2 where hmainid= " + HID + " ", "h_v_Sb_EquipPatrolCheckBill_Edit2"); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "不存在点检记录表" }; |
| | | return new ApiResult<DataSet> { code = -1, msg = "不存在巡检记录表" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "查询成功", data = dataSet }; |
| | | } |
| | | #endregion |
| | | |
| | | #region[设备点检记录表编辑时获取表题数据] |
| | | [Route("Sb_EquipDotCheckBill/Sb_EquipDotCheckBillListProjectDetai")] |
| | | #region[设备巡检记录表编辑时获取表题数据] |
| | | [Route("Sb_EquipPatrolCheckBill/Sb_EquipPatrolCheckBillListProjectDetai")] |
| | | [HttpGet] |
| | | public object Sb_EquipDotCheckBillListProjectDetai(string sqlWhere) |
| | | public object Sb_EquipPatrolCheckBillListProjectDetai(string sqlWhere) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckBill_Edit", "h_v_Sb_EquipDotCheckBill_Edit"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipPatrolCheckBill_Edit", "h_v_Sb_EquipPatrolCheckBill_Edit"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "获取信息成功!"; |
| | |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sb_EquipDotCheckBill_Edit where 1 = 1 "; |
| | | string sql1 = "select * from h_v_Sb_EquipPatrolCheckBill_Edit where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBill_Edit"); |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipPatrolCheckBill_Edit"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "获取信息成功!"; |
| | |
| | | |
| | | |
| | | #region 根据设备条码查找设备档案信息PDA |
| | | [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown")] |
| | | [Route("Sb_PDA_EquipPatrolCheckBill/txtHBarCode_KeyDown")] |
| | | [HttpGet] |
| | | public object txtHBarCode_KeyDown(string HBarCode) |
| | | { |
| | |
| | | #endregion |
| | | |
| | | #region 根据设备条码查找设备档案信息PDA 查询条码档案列表 |
| | | [Route("Sb_PDA_EquipDotCheckBill/txtHBarCode_KeyDown_List")] |
| | | [Route("Sb_PDA_EquipPatrolCheckBill/txtHBarCode_KeyDown_List")] |
| | | [HttpGet] |
| | | public object txtHBarCode_KeyDown_List(string HBarCode) |
| | | { |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检记录提交PDA |
| | | #region 设备巡检记录提交PDA |
| | | |
| | | [Route("Sb_PDA_EquipDotCheckBill/SaveGetEquipDotCheckBillList")] |
| | | [Route("Sb_PDA_EquipPatrolCheckBill/SaveGetEquipPatrolCheckBillList")] |
| | | [HttpPost] |
| | | public object SaveGetEquipDotCheckBillList([FromBody] JObject msg) |
| | | public object SaveGetEquipPatrolCheckBillList([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DLL.ClsSb_EquipDotCheckBill oBill = new DLL.ClsSb_EquipDotCheckBill(); |
| | | List<Models.ClsSb_EquipDotCheckBillMain> lsmain = new List<Models.ClsSb_EquipDotCheckBillMain>(); |
| | | DLL.ClsSb_EquipPatrolCheckBill oBill = new DLL.ClsSb_EquipPatrolCheckBill(); |
| | | List<Models.ClsSb_EquipPatrolCheckBillMain> lsmain = new List<Models.ClsSb_EquipPatrolCheckBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Sb_EquipDotCheckBillMainPDA(msg2); |
| | | foreach (Models.ClsSb_EquipDotCheckBillMain oItem in lsmain) |
| | | lsmain = oListModels.getObjectByJson_Sb_EquipPatrolCheckBillMainPDA(msg2); |
| | | foreach (Models.ClsSb_EquipPatrolCheckBillMain oItem in lsmain) |
| | | { |
| | | //单据号是否重复 |
| | | if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | List<Models.ClsSb_EquipDotCheckBillSub> ls = new List<Models.ClsSb_EquipDotCheckBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sb_EquipDotCheckBillSubPDA(msg3); |
| | | List<Models.ClsSb_EquipPatrolCheckBillSub> ls = new List<Models.ClsSb_EquipPatrolCheckBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sb_EquipPatrolCheckBillSubPDA(msg3); |
| | | int i = 0; |
| | | foreach (Models.ClsSb_EquipDotCheckBillSub oItemSub in ls) |
| | | foreach (Models.ClsSb_EquipPatrolCheckBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检记录单审核/反审核功能 |
| | | [Route("Sb_EquipDotCheckBill/CheckSb_EquipDotCheckBill")] |
| | | #region 设备巡检记录单审核/反审核功能 |
| | | [Route("Sb_EquipPatrolCheckBill/CheckSb_EquipPatrolCheckBill")] |
| | | [HttpGet] |
| | | public object CheckSb_EquipDotCheckBill(string HInterID, int Type, string user) |
| | | public object CheckSb_EquipPatrolCheckBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //判断是否有删除权限 |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckBill_Check", 1, false, user)) |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipPatrolCheckBill_Check", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | if (Type == 1) |
| | | { |
| | | //审核前控制========================================= |
| | | string sql1 = "exec h_p_Sb_EquipDotCheckBill_BeforeCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql1, "h_p_Sb_EquipDotCheckBill_BeforeCheckCtrl"); |
| | | string sql1 = "exec h_p_Sb_EquipPatrolCheckBill_BeforeCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql1, "h_p_Sb_EquipPatrolCheckBill_BeforeCheckCtrl"); |
| | | if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | //================================================================================== |
| | | |
| | | if (!BillOld.CheckBill(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo)) |
| | | if (!BillOld.CheckBill(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipPatrolCheckBill_AfterCheckCtrl", user, ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | else |
| | | { |
| | | //反审核前控制========================================= |
| | | string sql1 = "exec h_p_Sb_EquipDotCheckBill_BeforeUnCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql1, "h_p_Sb_EquipDotCheckBill_BeforeUnCheckCtrl"); |
| | | string sql1 = "exec h_p_Sb_EquipPatrolCheckBill_BeforeUnCheckCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql1, "h_p_Sb_EquipPatrolCheckBill_BeforeUnCheckCtrl"); |
| | | if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | //=========================================================== |
| | | |
| | | if (!BillOld.AbandonCheck(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo)) |
| | | if (!BillOld.AbandonCheck(int.Parse(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipPatrolCheckBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检记录单关闭/反关闭功能 |
| | | [Route("Sb_EquipDotCheckBill/CloseSb_EquipDotCheckBill")] |
| | | #region 设备巡检记录单关闭/反关闭功能 |
| | | [Route("Sb_EquipPatrolCheckBill/CloseSb_EquipPatrolCheckBill")] |
| | | [HttpGet] |
| | | public object CloseSb_EquipDotCheckBill(string HInterID, int Type, string user) |
| | | public object CloseSb_EquipPatrolCheckBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //判断是否有删除权限 |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckBill_Close", 1, false, user)) |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipPatrolCheckBill_Close", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | { |
| | | string sql = ""; |
| | | //关闭前控制===============================================Begin=================================================================== |
| | | sql = "exec h_p_Sb_EquipDotCheckBill_BeforeCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipDotCheckBill_BeforeCloseCtrl"); |
| | | sql = "exec h_p_Sb_EquipPatrolCheckBill_BeforeCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipPatrolCheckBill_BeforeCloseCtrl"); |
| | | if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | //关闭前控制===============================================End=================================================================== |
| | | |
| | | //关闭提交 |
| | | if (BillOld.CloseBill(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | if (BillOld.CloseBill(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipPatrolCheckBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | string sql = ""; |
| | | //反关闭前控制===============================================Begin=================================================================== |
| | | sql = "exec h_p_Sb_EquipDotCheckBill_BeforeUnCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipDotCheckBill_BeforeUnCloseCtrl"); |
| | | sql = "exec h_p_Sb_EquipPatrolCheckBill_BeforeUnCloseCtrl " + HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipPatrolCheckBill_BeforeUnCloseCtrl"); |
| | | if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | //反关闭前控制===============================================End=================================================================== |
| | | |
| | | //反关闭提交 |
| | | if (BillOld.CancelClose(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipDotCheckBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | if (BillOld.CancelClose(Convert.ToInt32(HInterID), BillOld.omodel.HBillNo, "h_p_Sb_EquipPatrolCheckBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检逾期预警报表 |
| | | #region 设备巡检逾期预警报表 |
| | | |
| | | [Route("Sb_EquipDotCheckWarning/Report")] |
| | | [Route("Sb_EquipPatrolCheckWarning/Report")] |
| | | [HttpGet] |
| | | public object Report(string HYear,string HMonth,string HEquipTypeID, string user) |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | string sql = "exec h_p_Sb_EquipDotCheckWarningReport " + HYear + "," + HMonth + "," + HEquipTypeID; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipDotCheckWarningReport"); |
| | | string sql = "exec h_p_Sb_EquipPatrolCheckWarningReport " + HYear + "," + HMonth + "," + HEquipTypeID; |
| | | ds = oCN.RunProcReturn(sql, "h_p_Sb_EquipPatrolCheckWarningReport"); |
| | | } |
| | | |
| | | //添加列名 |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 设备点检记录拍照上传 |
| | | [Route("Sb_EquipDotCheckBill/UploadFile")] |
| | | #region 设备巡检记录拍照上传 |
| | | [Route("Sb_EquipPatrolCheckBill/UploadFile")] |
| | | [HttpPost] |
| | | public object UploadFile() |
| | | { |
| | |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("Sb_EquipDotCheckBill/Filelist")] |
| | | [Route("Sb_EquipPatrolCheckBill/Filelist")] |
| | | [HttpGet] |
| | | public object Filelist(string HBillNo) |
| | | { |
| | |
| | | /// </summary> |
| | | /// <param name="sWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("Sb_EquipDotCheckBill/DeleteFilelist")] |
| | | [Route("Sb_EquipPatrolCheckBill/DeleteFilelist")] |
| | | [HttpGet] |
| | | public object DeleteFilelist(string HItemID, string HSourceBillNo, string HFileName) |
| | | { |