using DBUtility;
|
using Newtonsoft.Json;
|
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;
|
using System.Web;
|
using WebAPI.Controllers.SCGL.日计划管理;
|
using System.IO;
|
|
namespace WebAPI.Controllers.基础资料.基础资料
|
{
|
public class Gy_RepairCheckClassController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
Models.ClsGy_RepairCheck oDept = new Models.ClsGy_RepairCheck();
|
Models.ClsGy_RepairCheck oDeptHlp = new Models.ClsGy_RepairCheck();
|
|
#region 维修验收项目分类列表查询
|
[Route("Gy_RepairCheckClass/list")]
|
[HttpGet]
|
public object list(string sWhere,string user)
|
{
|
try
|
{
|
//查询权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheckClass_Query", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查询权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
List<object> columnNameList = new List<object>();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_RepairCheckClass where 1=1 order by HItemID ", "h_v_Gy_RepairCheckClass");
|
}
|
else
|
{
|
string sql = "select * from h_v_Gy_RepairCheckClass where 1 = 1 " + sWhere + " order by HItemID ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_RepairCheckClass");
|
}
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.list = columnNameList;
|
return objJsonResult;
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 维修验收项目分类 设置列表/保存/编辑/删除方法
|
/// <summary>
|
/// 维修验收项目分类 保存
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[Route("SaveGy_RepairCheckClass")]
|
[HttpPost]
|
public object SaveGy_RepairCheckClass([FromBody] JObject msg)
|
{
|
DataSet ds;
|
var _value = msg["msg"].ToString();
|
string msg3 = _value.ToString();
|
string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg1 = sArray[0].ToString();
|
string msg2 = sArray[1].ToString();
|
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheckClass_Edit", 1, false, msg2))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无保存权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
Int64 HItemID = 0;
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
//获取最大ID值赋值
|
DataSet Maxds = oCN.RunProcReturn("select isNull(MAX(HItemID),0) HItemID from Gy_RepairCheckClass ", "Gy_RepairCheckClass");
|
if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
|
{
|
//HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
|
var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
|
maxid += 1;
|
HItemID = maxid;
|
}
|
ListModels oListModels = new ListModels();
|
try
|
{
|
|
DAL.ClsGy_RepairCheckClass_Ctl oBill = new DAL.ClsGy_RepairCheckClass_Ctl();
|
List<Model.ClsGy_RepairCheckClass_Model> lsmain = new List<Model.ClsGy_RepairCheckClass_Model>();
|
msg1 = msg1.Replace("\\", "");
|
msg1 = msg1.Replace("\n", "");
|
lsmain = oListModels.getObjectByJson_Gy_RepairCheckClass(msg1);
|
foreach (Model.ClsGy_RepairCheckClass_Model oItem in lsmain)
|
{
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (oItem.HName.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！名称不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//查询数据中是否存在重复代码
|
|
ds = oCN.RunProcReturn("select * from Gy_RepairCheckClass where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_RepairCheckClass");
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//新增时判断
|
if (oItem.HItemID == 0)
|
{
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码重复！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
else//编辑时判断
|
{
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
//得到短代码
|
string sShortNumber;
|
sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
|
if (sShortNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！短代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
oItem.HShortNumber = sShortNumber;//短代码
|
oItem.HEndFlag = true;//末级标志
|
oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
|
oItem.HMakeEmp = msg2; //创建人
|
|
oBill.oModel = oItem;
|
}
|
|
//保存
|
//保存完毕后处理
|
bool bResult;
|
string sExeReturnInfo = "";
|
if (oBill.oModel.HItemID == 0)
|
{
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
bResult = oBill.AddNew(ref sExeReturnInfo);
|
}
|
else
|
{
|
bResult = oBill.ModifyByID(oBill.oModel.HItemID, ref 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 = "保存失败！" + sExeReturnInfo;
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
#region 修改 维修验收项目分类 获取绑定数据
|
[Route("Gy_RepairCheckClass/EditGy_RepairCheckClass")]
|
[HttpGet]
|
public object EditGy_RepairCheckClass(long HInterID)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_RepairCheckClass where HItemID=" + HInterID, "h_v_Gy_RepairCheckClass");
|
|
objJsonResult.code = "1";
|
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;
|
}
|
}
|
|
#endregion
|
|
|
/// <summary>
|
/// 维修验收项目分类 审核、反审核
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsAudit">审核(0),反审核(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_RepairCheckClass/AuditGy_RepairCheckClass")]
|
[HttpGet]
|
public object AuditGy_RepairCheckClass(int HInterID, int IsAudit, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_RepairCheckClass_Check", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_RepairCheckClass where HItemID=" + HInterID, "Gy_RepairCheckClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsAudit == 0) //审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未审核!不需要反审核!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsAudit == 0) //审核判断
|
{
|
//审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_BeforeCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_BeforeCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairCheckClass set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
|
|
//审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_AfterCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功";
|
objJsonResult.data = null;
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
//反审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_BeforeUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_BeforeUnCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairCheckClass set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
|
|
//反审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_AfterUnCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 维修验收项目分类 禁用、反禁用
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsStop">禁用(0),反禁用(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_RepairCheckClass/StopGy_RepairCheckClass")]
|
[HttpGet]
|
public object StopGy_RepairCheckClass(int HInterID, int IsStop, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_RepairCheckClass_Close", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_RepairCheckClass where HItemID=" + HInterID, "Gy_RepairCheckClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsStop == 0) //禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能再次禁用！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未禁用!不需要反禁用!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsStop == 0) //禁用判断
|
{
|
//禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_BeforeStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_BeforeStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairCheckClass set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
|
|
//禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_AfterStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "禁用成功";
|
objJsonResult.data = null;
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
//反禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_BeforeUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_BeforeUnStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("update Gy_RepairCheckClass set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
|
|
//反禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairCheckClass_AfterUnStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反禁用成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败或者反禁用失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 维修验收项目分类 删除功能
|
/// </summary>
|
/// <returns></returns>
|
[Route("DeltetGy_RepairCheckClass")]
|
[HttpGet]
|
public object DeltetGy_RepairCheckClass(string HItemID, string user)
|
{
|
DataSet ds;
|
//string ModRightNameCheck = "Sc_ProcessReport_check";
|
try
|
{
|
//删除权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairCheckClass_Delete", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无删除权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (string.IsNullOrWhiteSpace(HItemID))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HItemID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.BeginTran();//开始事务
|
|
ds = oCN.RunProcReturn("select * from Gy_RepairCheckClass where HItemID=" + HItemID, "Gy_RepairCheckClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//删除前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_BeforeDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_RepairCheckClass_BeforeDelCtrl");
|
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("delete Gy_RepairCheckClass where HItemID=" + HItemID);
|
|
//删除后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairCheckClass_AfterDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_RepairCheckClass_AfterDelCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.Commit();//提交事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "数据删除成功！";
|
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("Gy_RepairClass/list")]
|
[HttpGet]
|
public object Gy_RepairClasslist(string sWhere, string user)
|
{
|
try
|
{
|
//查询权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairClass_Query", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查询权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
List<object> columnNameList = new List<object>();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_RepairClass where 1=1 order by HItemID ", "h_v_Gy_RepairClass");
|
}
|
else
|
{
|
string sql = "select * from h_v_Gy_RepairClass where 1 = 1 " + sWhere + " order by HItemID ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_RepairClass");
|
}
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.list = columnNameList;
|
return objJsonResult;
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 维修项目分类 设置列表/保存/编辑/删除方法
|
/// <summary>
|
/// 维修项目分类 保存
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[Route("SaveGy_RepairClass")]
|
[HttpPost]
|
public object SaveGy_RepairClass([FromBody] JObject msg)
|
{
|
DataSet ds;
|
var _value = msg["msg"].ToString();
|
string msg3 = _value.ToString();
|
string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg1 = sArray[0].ToString();
|
string msg2 = sArray[1].ToString();
|
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairClass_Edit", 1, false, msg2))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无保存权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
Int64 HItemID = 0;
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
//获取最大ID值赋值
|
DataSet Maxds = oCN.RunProcReturn("select isNull(MAX(HItemID),0) HItemID from Gy_RepairClass ", "Gy_RepairClass");
|
if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
|
{
|
//HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
|
var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
|
maxid += 1;
|
HItemID = maxid;
|
}
|
ListModels oListModels = new ListModels();
|
try
|
{
|
|
DAL.ClsGy_RepairClass_Ctl oBill = new DAL.ClsGy_RepairClass_Ctl();
|
List<Model.ClsGy_RepairClass_Model> lsmain = new List<Model.ClsGy_RepairClass_Model>();
|
msg1 = msg1.Replace("\\", "");
|
msg1 = msg1.Replace("\n", "");
|
lsmain = oListModels.getObjectByJson_Gy_RepairClass(msg1);
|
foreach (Model.ClsGy_RepairClass_Model oItem in lsmain)
|
{
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (oItem.HName.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！名称不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//查询数据中是否存在重复代码
|
|
ds = oCN.RunProcReturn("select * from Gy_RepairClass where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_RepairClass");
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//新增时判断
|
if (oItem.HItemID == 0)
|
{
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码重复！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
else//编辑时判断
|
{
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
//得到短代码
|
string sShortNumber;
|
sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
|
if (sShortNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！短代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
oItem.HShortNumber = sShortNumber;//短代码
|
oItem.HEndFlag = true;//末级标志
|
oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
|
oItem.HMakeEmp = msg2; //创建人
|
|
oBill.oModel = oItem;
|
}
|
|
//保存
|
//保存完毕后处理
|
bool bResult;
|
string sExeReturnInfo = "";
|
if (oBill.oModel.HItemID == 0)
|
{
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
bResult = oBill.AddNew(ref sExeReturnInfo);
|
}
|
else
|
{
|
bResult = oBill.ModifyByID(oBill.oModel.HItemID, ref 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 = "保存失败！" + sExeReturnInfo;
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
#region 修改 维修项目分类 获取绑定数据
|
[Route("Gy_RepairClass/EditGy_RepairClass")]
|
[HttpGet]
|
public object EditGy_RepairClass(long HInterID)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_RepairClass where HItemID=" + HInterID, "h_v_Gy_RepairClass");
|
|
objJsonResult.code = "1";
|
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;
|
}
|
}
|
|
#endregion
|
|
|
/// <summary>
|
/// 维修项目分类 审核、反审核
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsAudit">审核(0),反审核(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_RepairClass/AuditGy_RepairClass")]
|
[HttpGet]
|
public object AuditGy_RepairClass(int HInterID, int IsAudit, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_RepairClass_Check", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_RepairClass where HItemID=" + HInterID, "Gy_RepairClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsAudit == 0) //审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未审核!不需要反审核!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsAudit == 0) //审核判断
|
{
|
//审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_BeforeCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_BeforeCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairClass set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
|
|
//审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_AfterCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功";
|
objJsonResult.data = null;
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
//反审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_BeforeUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_BeforeUnCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairClass set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
|
|
//反审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_AfterUnCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 维修项目分类 禁用、反禁用
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsStop">禁用(0),反禁用(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_RepairClass/StopGy_RepairClass")]
|
[HttpGet]
|
public object StopGy_RepairClass(int HInterID, int IsStop, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_RepairClass_Close", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_RepairClass where HItemID=" + HInterID, "Gy_RepairClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsStop == 0) //禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能再次禁用！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未禁用!不需要反禁用!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsStop == 0) //禁用判断
|
{
|
//禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_BeforeStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_BeforeStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_RepairClass set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
|
|
//禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_AfterStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "禁用成功";
|
objJsonResult.data = null;
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
//反禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_BeforeUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_BeforeUnStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("update Gy_RepairClass set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
|
|
//反禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_RepairClass_AfterUnStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反禁用成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败或者反禁用失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 维修项目分类 删除功能
|
/// </summary>
|
/// <returns></returns>
|
[Route("DeltetGy_RepairClass")]
|
[HttpGet]
|
public object DeltetGy_RepairClass(string HItemID, string user)
|
{
|
DataSet ds;
|
//string ModRightNameCheck = "Sc_ProcessReport_check";
|
try
|
{
|
//删除权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_RepairClass_Delete", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无删除权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (string.IsNullOrWhiteSpace(HItemID))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HItemID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.BeginTran();//开始事务
|
|
ds = oCN.RunProcReturn("select * from Gy_RepairClass where HItemID=" + HItemID, "Gy_RepairClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//删除前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_BeforeDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_RepairClass_BeforeDelCtrl");
|
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("delete Gy_RepairClass where HItemID=" + HItemID);
|
|
//删除后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_RepairClass_AfterDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_RepairClass_AfterDelCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.Commit();//提交事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "数据删除成功！";
|
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("Gy_MaintainClass/list")]
|
[HttpGet]
|
public object Gy_MaintainClasslist(string sWhere, string user)
|
{
|
try
|
{
|
//查询权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_MaintainClass_Query", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查询权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
List<object> columnNameList = new List<object>();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_MaintainClass where 1=1 order by HItemID ", "h_v_Gy_MaintainClass");
|
}
|
else
|
{
|
string sql = "select * from h_v_Gy_MaintainClass where 1 = 1 " + sWhere + " order by HItemID ";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_MaintainClass");
|
}
|
//添加列名
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
objJsonResult.list = columnNameList;
|
return objJsonResult;
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 保养项目分类 设置列表/保存/编辑/删除方法
|
/// <summary>
|
/// 保养项目分类 保存
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
[Route("SaveGy_MaintainClass")]
|
[HttpPost]
|
public object SaveGy_MaintainClass([FromBody] JObject msg)
|
{
|
DataSet ds;
|
var _value = msg["msg"].ToString();
|
string msg3 = _value.ToString();
|
string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg1 = sArray[0].ToString();
|
string msg2 = sArray[1].ToString();
|
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_MaintainClass_Edit", 1, false, msg2))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无保存权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
Int64 HItemID = 0;
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
//获取最大ID值赋值
|
DataSet Maxds = oCN.RunProcReturn("select isNull(MAX(HItemID),0) HItemID from Gy_MaintainClass ", "Gy_MaintainClass");
|
if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
|
{
|
//HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
|
var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
|
maxid += 1;
|
HItemID = maxid;
|
}
|
ListModels oListModels = new ListModels();
|
try
|
{
|
|
DAL.ClsGy_MaintainClass_Ctl oBill = new DAL.ClsGy_MaintainClass_Ctl();
|
List<Model.ClsGy_MaintainClass_Model> lsmain = new List<Model.ClsGy_MaintainClass_Model>();
|
msg1 = msg1.Replace("\\", "");
|
msg1 = msg1.Replace("\n", "");
|
lsmain = oListModels.getObjectByJson_Gy_MaintainClass(msg1);
|
foreach (Model.ClsGy_MaintainClass_Model oItem in lsmain)
|
{
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (oItem.HName.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！名称不能为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//查询数据中是否存在重复代码
|
|
ds = oCN.RunProcReturn("select * from Gy_MaintainClass where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_MaintainClass");
|
if (oItem.HNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//新增时判断
|
if (oItem.HItemID == 0)
|
{
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！代码重复！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
else//编辑时判断
|
{
|
//检查父级是否存在
|
string sParent;
|
sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
|
if (sParent.Trim() == "")
|
{
|
oBill.oModel.HParentID = 0;
|
}
|
else
|
{
|
if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID))
|
{
|
oBill.oModel.HParentID = oBill.oModel.HItemID;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
}
|
//得到短代码
|
string sShortNumber;
|
sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
|
if (sShortNumber.Trim() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！短代码为空！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
oItem.HShortNumber = sShortNumber;//短代码
|
oItem.HEndFlag = true;//末级标志
|
oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
|
oItem.HMakeEmp = msg2; //创建人
|
|
oBill.oModel = oItem;
|
}
|
|
//保存
|
//保存完毕后处理
|
bool bResult;
|
string sExeReturnInfo = "";
|
if (oBill.oModel.HItemID == 0)
|
{
|
// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
bResult = oBill.AddNew(ref sExeReturnInfo);
|
}
|
else
|
{
|
bResult = oBill.ModifyByID(oBill.oModel.HItemID, ref 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 = "保存失败！" + sExeReturnInfo;
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
#region 修改 保养项目分类 获取绑定数据
|
[Route("Gy_MaintainClass/EditGy_MaintainClass")]
|
[HttpGet]
|
public object EditGy_MaintainClass(long HInterID)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_MaintainClass where HItemID=" + HInterID, "h_v_Gy_MaintainClass");
|
|
objJsonResult.code = "1";
|
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;
|
}
|
}
|
|
#endregion
|
|
|
/// <summary>
|
/// 保养项目分类 审核、反审核
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsAudit">审核(0),反审核(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_MaintainClass/AuditGy_MaintainClass")]
|
[HttpGet]
|
public object AuditGy_MaintainClass(int HInterID, int IsAudit, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_MaintainClass_Check", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_MaintainClass where HItemID=" + HInterID, "Gy_MaintainClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsAudit == 0) //审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能再次审核！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未审核!不需要反审核!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsAudit == 0) //审核判断
|
{
|
//审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_BeforeCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_BeforeCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_MaintainClass set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
|
|
//审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_AfterCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_AfterCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功";
|
objJsonResult.data = null;
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
//反审核前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_BeforeUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_BeforeUnCheckCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_MaintainClass set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
|
|
//反审核后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_AfterUnCheckCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_AfterUnCheckCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反审核成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 保养项目分类 禁用、反禁用
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsStop">禁用(0),反禁用(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_MaintainClass/StopGy_MaintainClass")]
|
[HttpGet]
|
public object StopGy_MaintainClass(int HInterID, int IsStop, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_MaintainClass_Close", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_MaintainClass where HItemID=" + HInterID, "Gy_MaintainClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (IsStop == 0) //禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能再次禁用！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据未禁用!不需要反禁用!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
if (IsStop == 0) //禁用判断
|
{
|
//禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_BeforeStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_BeforeStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.RunProc("update Gy_MaintainClass set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopflag=1 where HItemID=" + HInterID);
|
|
//禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_AfterStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_AfterStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "禁用成功";
|
objJsonResult.data = null;
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
//反禁用前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_BeforeUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_BeforeUnStopCtrl");
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("update Gy_MaintainClass set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
|
|
//反禁用后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_AfterUnStopCtrl " + HInterID + ",'" + CurUserName + "'", "h_p_Gy_MaintainClass_AfterUnStopCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "反禁用成功";
|
objJsonResult.data = null;
|
}
|
oCN.Commit();
|
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败或者反禁用失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 保养项目分类 删除功能
|
/// </summary>
|
/// <returns></returns>
|
[Route("DeltetGy_MaintainClass")]
|
[HttpGet]
|
public object DeltetGy_MaintainClass(string HItemID, string user)
|
{
|
DataSet ds;
|
//string ModRightNameCheck = "Sc_ProcessReport_check";
|
try
|
{
|
//删除权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_MaintainClass_Delete", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无删除权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (string.IsNullOrWhiteSpace(HItemID))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HItemID为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.BeginTran();//开始事务
|
|
ds = oCN.RunProcReturn("select * from Gy_MaintainClass where HItemID=" + HItemID, "Gy_MaintainClass");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
if (ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已审核!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (ds.Tables[0].Rows[0]["HStopEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据已禁用!不能进行删除！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据不存在!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//删除前控制=========================================
|
ds = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_BeforeDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_MaintainClass_BeforeDelCtrl");
|
|
if (ds == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除前判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
|
oCN.RunProc("delete Gy_MaintainClass where HItemID=" + HItemID);
|
|
//删除后控制=========================================
|
DataSet ds2 = oCN.RunProcReturn("Exec h_p_Gy_MaintainClass_AfterDelCtrl " + HItemID + ",'" + User + "'", "h_p_Gy_MaintainClass_AfterDelCtrl");
|
if (ds2 == null)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除后判断失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//=========================================================
|
|
oCN.Commit();//提交事务
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "数据删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
