派生自 MES-WEB-API
WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
@@ -4,6 +4,7 @@ using System.Collections.Generic; using System.Data; using System.Web.Http; using ViewAPI; using WebAPI.Models; namespace WebAPI.Controllers { @@ -183,28 +184,37 @@ /// <returns></returns> [Route("Sc_MouldMaintainBill/GetMouldMaintainBillList")] [HttpGet] public object GetMouldMaintainBillList(string sWhere) public object GetMouldMaintainBillList(string sWhere,string user) { try { ds = Sc_MouldMaintainBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_MouldMaintainBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -223,12 +233,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain order by 日期 desc", "h_v_Sc_MouldMaintain"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain order by hmainid desc", "h_v_Sc_MouldMaintain"); } else { string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMaintain"); } @@ -244,28 +254,37 @@ /// <returns></returns> [Route("Sc_MouldDotCheckPlanBill/GetMouldDotCheckPlanBillList")] [HttpGet] public object GetMouldDotCheckPlanBillList(string sWhere) public object GetMouldDotCheckPlanBillList(string sWhere,string user) { try { ds = Sc_MouldDotCheckPlanBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckPlanBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_MouldDotCheckPlanBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -282,7 +301,7 @@ public static DataSet Sc_MouldDotCheckPlanBillList_s(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList order by 日期 desc", "h_v_Sc_MouldDotCheckPlanBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckPlanBillList where 1=1 "+sWhere+ " order by hmainid desc", "h_v_Sc_MouldDotCheckPlanBillList"); } #endregion @@ -292,28 +311,36 @@ /// <returns></returns> [Route("Sc_MouldDotCheckBill/GetMouldDotCheckBillList")] [HttpGet] public object GetMouldDotCheckBillList(string sWhere) public object GetMouldDotCheckBillList(string sWhere,string user) { try { ds = Sc_MouldDotCheckBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_MouldDotCheckBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -330,7 +357,7 @@ public static DataSet Sc_MouldDotCheckBillList_s(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 " + sWhere + "order by 日期 desc", "h_v_Sc_MouldDotCheckBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldDotCheckBillList where 1=1 " + sWhere + "order by hmainid desc", "h_v_Sc_MouldDotCheckBillList"); } #endregion @@ -390,28 +417,37 @@ /// <returns></returns> [Route("Sc_MouldMaintainPlanBill/GetMouldMaintainPlanBillList")] [HttpGet] public object GetMouldMaintainPlanBillList(string sWhere) public object GetMouldMaintainPlanBillList(string sWhere,string user) { try { ds = Sc_MouldMaintainPlanBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainPlanBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_MouldMaintainPlanBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -428,7 +464,7 @@ public static DataSet Sc_MouldMaintainPlanBillList_s(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList where 1=1 "+sWhere+" order by 日期 desc", "h_v_Sc_MouldMaintainPlanBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainPlanBillList where 1=1 "+sWhere+ " order by hmainid desc", "h_v_Sc_MouldMaintainPlanBillList"); } #endregion @@ -439,12 +475,21 @@ /// <returns></returns> [Route("Sc_MouldConkBookBill/GetMouldConkBookBillList")] [HttpGet] public object GetMouldConkBookBillList(string sWhere) public object GetMouldConkBookBillList(string sWhere,string user) { try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } ds = Sc_MouldConkBookBillList_s(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; @@ -469,7 +514,7 @@ DataSet ds; if (sWhere == null || sWhere.Equals("")) { ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList order by 日期 desc" + sWhere, "h_v_Sc_MouldConkBookBillList"); ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList where 1=1 " + sWhere+ " order by hmainid desc", "h_v_Sc_MouldConkBookBillList"); } else { @@ -489,11 +534,21 @@ /// <returns></returns> [Route("Sc_MouldRepairCheckBill/GetMouldRepairCheckBillList")] [HttpGet] public object GetMouldRepairCheckBillList(string sWhere) public object GetMouldRepairCheckBillList(string sWhere,string user) { try { if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = Sc_MouldRepairCheckBillList_s(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -519,12 +574,12 @@ DataSet ds; if (sWhere == null || sWhere.Equals("")) { ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit order by 日期 desc" + sWhere, "h_v_Sc_MouldRepairCheckBillList_Edit"); ds = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1=1" + sWhere+ " order by hmainid desc", "h_v_Sc_MouldRepairCheckBillList_Edit"); } else { string sql1 = "select * from h_v_Sc_MouldRepairCheckBillList_Edit where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; ds = new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairCheckBillList_Edit"); } return ds; @@ -595,28 +650,37 @@ /// <returns></returns> [Route("Sb_MouldRepairWorkBill/GetMouldRepairWorkBillList")] [HttpGet] public object GetMouldRepairWorkBillList(string sWhere) public object GetMouldRepairWorkBillList(string sWhere,string user) { try { ds = Sc_MouldRepairWorkBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_MouldRepairWorkBillList_s(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -635,12 +699,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairWorkBillList order by 日期 desc" + sWhere, "h_v_Sc_MouldRepairWorkBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairWorkBillList where 1=1 " + sWhere+ " order by hmainid desc", "h_v_Sc_MouldRepairWorkBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairWorkBillList where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList"); } } @@ -751,35 +815,46 @@ /// <returns></returns> [Route("Kf_MoveStockBill/GetMoveStockBillList")] [HttpGet] public object GetMoveStockBillList(string sWhere) public object GetMoveStockBillList(string sWhere,string user) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by 日期 desc", "h_v_IF_MoveStockBillList"); } else { string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by 日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_MoveStockBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_MoveStockBillQuery", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_MoveStockBillList order by hmainid desc", "h_v_IF_MoveStockBillList"); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; string sql = "select * from h_v_IF_MoveStockBillList where 1=1 " + sWhere+ "order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_MoveStockBillList"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -797,28 +872,38 @@ /// <returns></returns> [Route("Kf_SellOutBill/GetSellOutBillList")] [HttpGet] public object GetSellOutBillList(string sWhere) public object GetSellOutBillList(string sWhere,string user) { try { ds = Sc_GetSellOutBillList(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBillQuery", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "没有查询权限!"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } ds = Sc_GetSellOutBillList(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -835,10 +920,20 @@ /// <returns></returns> [Route("Kf_SellOutBill/DeltetSellOutBill")] [HttpGet] public object DeltetSeOutStockBackBill(string HInterID) public object DeltetSeOutStockBackBill(string HInterID,string user) { try { //判断是否有删除权限 if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBill_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限删除!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); oCN.RunProc("Delete From Kf_ICStockBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Kf_ICStockBillSub where HInterID = " + HInterID); @@ -864,7 +959,14 @@ public static DataSet Sc_GetSellOutBillList(string sWhere) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by 日期 desc", "h_v_IF_SellOutBillList"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by hmainid desc", "h_v_IF_SellOutBillList"); } else { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList where 1=1 " + sWhere + " order by hmainid desc", "h_v_IF_SellOutBillList"); } } #endregion @@ -875,36 +977,46 @@ /// <returns></returns> [Route("Kf_OtherOutBill/GetOtherOutBillList")] [HttpGet] public object GetOtherOutBillList(string sWhere) public object GetOtherOutBillList(string sWhere,string user) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_OtherOutBillList where 1=1 order by 日期 desc", "h_v_Kf_OtherOutBillList"); } else { string sql = "select * from h_v_Kf_OtherOutBillList where 1 = 1 " + sWhere+ " order by 日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherOutBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_OtherOutBillQuery", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_OtherOutBillList where 1=1 order by hmainid desc", "h_v_Kf_OtherOutBillList"); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; string sql = "select * from h_v_Kf_OtherOutBillList where 1 = 1 " + sWhere+ " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherOutBillList"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -1022,36 +1134,47 @@ /// <returns></returns> [Route("Kf_ProductInBill/GetProductInBill")] [HttpGet] public object GetProductInBill(string sWhere) public object GetProductInBill(string sWhere,string user) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where 1=1 order by 日期 desc", "h_v_IF_ProductInBillList"); } else { string sql = "select * from h_v_IF_ProductInBillList where 1 = 1 " + sWhere + " order by 日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_ProductInBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_ProductInBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_ProductInBillList where 1=1 order by hmainid desc", "h_v_IF_ProductInBillList"); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; string sql = "select * from h_v_IF_ProductInBillList where 1 = 1 " + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_ProductInBillList"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -1102,36 +1225,46 @@ /// <returns></returns> [Route("Kf_OtherInBill/GetOtherInBill")] [HttpGet] public object GetOtherInBill(string sWhere) public object GetOtherInBill(string sWhere,string user) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_OtherInBillList where 1=1 order by 日期 desc", "h_v_Kf_OtherInBillList"); } else { string sql = "select * from h_v_Kf_OtherInBillList where 1 = 1 " + sWhere+ " order by 日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherInBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_OtherInBillQuery", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_OtherInBillList where 1=1 order by hmainid desc", "h_v_Kf_OtherInBillList"); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; string sql = "select * from h_v_Kf_OtherInBillList where 1 = 1 " + sWhere+ " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Kf_OtherInBillList"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -1149,35 +1282,45 @@ /// <returns></returns> [Route("Kf_EntrustInBill/GetEntrustInBill")] [HttpGet] public object GetEntrustInBill(string sWhere) public object GetEntrustInBill(string sWhere,string user) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustInBillList where 1=1", "h_v_Kf_EntrustInBillList"); } else { string sql = "select * from h_v_Kf_EntrustInBillList where 1 = 1 " + sWhere; ds = oCN.RunProcReturn(sql, "h_v_Kf_EntrustInBillList"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBillQuery", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！"; objJsonResult.Message = "无权限查询!"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustInBillList where 1=1 order by hmainid desc", "h_v_Kf_EntrustInBillList"); } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; string sql = "select * from h_v_Kf_EntrustInBillList where 1 = 1 " + sWhere+ " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Kf_EntrustInBillList"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -1235,12 +1378,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSb_MouldRepairWorkBill oBill = new DAL.ClsSb_MouldRepairWorkBill(); List<Model.ClsSb_MouldRepairWorkBillMain> lsmain = new List<Model.ClsSb_MouldRepairWorkBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -1420,17 +1573,17 @@ /// <returns></returns> [Route("Sb_MouldRepairWorkBill/DeltetMouldRepairWorkBill")] [HttpGet] public object DeltetMouldRepairWorkBill(string HInterID) public object DeltetMouldRepairWorkBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -1656,6 +1809,15 @@ ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DLL.ClsSc_MouldRepairCheckBill oBill = new DLL.ClsSc_MouldRepairCheckBill(); List<Model.ClsSc_MouldRepairCheckBillMain> lsmain = new List<Model.ClsSc_MouldRepairCheckBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -1839,17 +2001,17 @@ /// <returns></returns> [Route("Sc_MouldRepairCheckBill/DeltetMouldRepairCheckBill")] [HttpGet] public object DeltetMouldRepairCheckBill(string HInterID) public object DeltetMouldRepairCheckBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairCheckBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -1917,7 +2079,7 @@ #region 模具故障登记表保存/编辑 /// <summary> /// 保存模具维修单 /// 保存故障登记表 /// </summary> /// <param name="msg"></param> /// <returns></returns> @@ -1930,12 +2092,20 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_MouldConkBookBill oBill = new DAL.ClsSc_MouldConkBookBill(); List<Model.ClsSc_MouldConkBookBillMain> lsmain = new List<Model.ClsSc_MouldConkBookBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -2115,22 +2285,22 @@ #region [模具故障登记表删除功能] /// <summary> /// 模具维修单删除功能 /// 模具故障登记表删除功能 /// </summary> /// <returns></returns> [Route("Sc_MouldConkBookBill/DeltetMouldConkBookBill")] [HttpGet] public object DeltetMouldConkBookBill(string HInterID) public object DeltetMouldConkBookBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -2212,12 +2382,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainPlanBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_MouldMaintainPlanBill oBill = new DAL.ClsSc_MouldMaintainPlanBill(); List<Model.ClsSc_MouldMaintainPlanBillMain> lsmain = new List<Model.ClsSc_MouldMaintainPlanBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -2391,17 +2571,17 @@ /// <returns></returns> [Route("Sc_MouldMaintainPlanBill/DeltetMouldMaintainPlanBill")] [HttpGet] public object DeltetMouldMaintainPlanBill(string HInterID) public object DeltetMouldMaintainPlanBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainPlanBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -2484,11 +2664,21 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainBill_Edit", 1, false, msg5)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_MouldMaintainBill oBill = new DAL.ClsSc_MouldMaintainBill(); List<Model.ClsSc_MouldMaintainBillMain> lsmain = new List<Model.ClsSc_MouldMaintainBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -2732,8 +2922,17 @@ /// <returns></returns> [Route("Sc_MouldMaintainBill/DeltetSc_MouldMaintainBill")] [HttpGet] public object DeltetSc_MouldMaintainBill(string HInterID) public object DeltetSc_MouldMaintainBill(string HInterID,string user) { if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) @@ -2813,12 +3012,21 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_MouldDotCheckBill oBill = new DAL.ClsSc_MouldDotCheckBill(); List<Model.ClsSc_MouldDotCheckBillMain> lsmain = new List<Model.ClsSc_MouldDotCheckBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -2987,22 +3195,22 @@ #region [模具点检记录表删除功能] /// <summary> /// 模具维修单删除功能 /// 模具点检记录删除功能 /// </summary> /// <returns></returns> [Route("Sc_MouldDotCheckBill/DeltetSc_MouldDotCheckBill")] [HttpGet] public object DeltetSc_MouldDotCheckBill(string HInterID) public object DeltetSc_MouldDotCheckBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -3085,12 +3293,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckPlanBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DAL.ClsSc_MouldDotCheckPlanBill oBill = new DAL.ClsSc_MouldDotCheckPlanBill(); List<Model.ClsSc_MouldDotCheckPlanBillMain> lsmain = new List<Model.ClsSc_MouldDotCheckPlanBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -3265,17 +3483,17 @@ /// <returns></returns> [Route("Sc_MouldDotCheckPlanBill/DeltetSc_MouldDotCheckPlanBillBill")] [HttpGet] public object DeltetSc_MouldDotCheckPlanBillBill(string HInterID) public object DeltetSc_MouldDotCheckPlanBillBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckPlanBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; @@ -3426,7 +3644,7 @@ /// <returns></returns> [Route("Sc_MouldScrapInHouseBill/SaveGetMouldScrapInHouseBillList")] [HttpPost] public object fSaveGetMouldScrapInHouseBillList([FromBody] JObject msg) public object SaveGetMouldScrapInHouseBillList([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); @@ -3774,6 +3992,7 @@ } ds = Sc_GetMouldScrapOutHouseBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -3795,11 +4014,11 @@ string sql1 = string.Format(@"select * from h_v_Sc_MouldScrapOutHouseBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 制单日期 desc", "h_v_Sc_MouldScrapOutHouseBillList"); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldScrapOutHouseBillList"); } else { string sql = sql1 + sWhere + "order by 制单日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldScrapOutHouseBillList"); } } @@ -4349,6 +4568,7 @@ } ds = Sc_GetMouldProdBackBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -4370,11 +4590,11 @@ string sql1 = string.Format(@"select * from h_v_Sc_MouldProdBackBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 制单日期 desc", "h_v_Sc_MouldProdBackBillList"); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldProdBackBillList"); } else { string sql = sql1 + sWhere + "order by 制单日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdBackBillList"); } @@ -4787,6 +5007,7 @@ } ds = Sc_GetMouldProdOutBill(sWhere, Organization); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -4808,11 +5029,12 @@ string sql1 = string.Format(@"select * from h_v_Sc_MouldProdOutHouseBillList where 库存组织='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by 制单日期 desc", "h_v_Sc_MouldProdOutHouseBillList"); Log.LogInfo(sql1); return new SQLHelper.ClsCN().RunProcReturn(sql1 + "order by hmainid desc", "h_v_Sc_MouldProdOutHouseBillList"); } else { string sql = sql1 + sWhere + "order by 制单日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdOutHouseBillList"); } @@ -5245,12 +5467,21 @@ [Route("Sc_MouldLifeChangeBill/GetMouldLifeChangeBill")] [HttpGet] public object GetMouldLifeChangeBill(string sWhere) public object GetMouldLifeChangeBill(string sWhere,string user) { try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = Sc_GetMouldLifeChangeBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; @@ -5271,12 +5502,12 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldLifeChangeBillList order by 日期 desc", "h_v_Sc_MouldLifeChangeBillList"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldLifeChangeBillList order by hmainid desc", "h_v_Sc_MouldLifeChangeBillList"); } else { string sql1 = "select * from h_v_Sc_MouldLifeChangeBillList where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldLifeChangeBillList"); } @@ -5367,12 +5598,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } DLL.ClsSc_MouldLifeChangeBill oBill = new DLL.ClsSc_MouldLifeChangeBill(); List<Model.ClsSc_MouldLifeChangeBillMain> lsmain = new List<Model.ClsSc_MouldLifeChangeBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -5494,17 +5735,17 @@ /// <returns></returns> [Route("Sc_MouldLifeChangeBill/DeltetMouldLifeChangeBill")] [HttpGet] public object DeltetMouldLifeChangeBill(string HInterID) public object DeltetMouldLifeChangeBill(string HInterID,string user) { //编辑权限 //if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "无删除权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Sc_MouldLifeChangeBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0;
