using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using Pub_Class;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Web.Http;
|
using WebAPI.Models;
|
namespace WebAPI.Controllers
|
{
|
public class Gy_TemporaryAreaController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
|
|
#region 暂放区 保存
|
[Route("Gy_TemporaryAreaBill/ModifyByID")]
|
[HttpPost]
|
public object ModifyByID([FromBody] JObject oMain)
|
{
|
try
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string user = sArray[1].ToString();
|
|
//反序列化
|
msg2 = "[" + msg2.ToString() + "]";
|
List<Gy_TemporaryArea> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_TemporaryArea>>(msg2);
|
|
|
string HNumber = list[0].HNumber;
|
string HName = list[0].HName;
|
string HHelpCode = list[0].HHelpCode;
|
|
int HStopFlag = list[0].HStopFlag?1:0;
|
long HCREATEORGID = list[0].HCREATEORGID;
|
long HUSEORGID = list[0].HUSEORGID;
|
string HBarCode = list[0].HBarCode;
|
|
string HRemark = list[0].HRemark;
|
long HItemID = list[0].HItemID;
|
string HShortNumber = list[0].HShortNumber;
|
long HParentID = list[0].HParentID;
|
|
long HLevel = ClsPub.GetLevel(list[0].HNumber.Trim());
|
int HEndFlag = 1;
|
|
string Emp = user;
|
string Time = DateTime.Now.ToString("yyyy-MM-dd");
|
|
#region [注释代码]
|
//判断权限
|
if (!ClsPub.Security_Log("Gy_TemporaryArea_Edit", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无权限！！！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (!DBUtility.ClsPub.AllowNumber(HNumber))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
#endregion
|
|
//保存
|
//保存完毕后处理
|
if (HItemID == 0) //新增保存
|
{
|
oCN.BeginTran();
|
string sql = "Insert into Gy_TemporaryArea" +
|
"(HNumber,HName,HHelpCode,HStopFlag,HCREATEORGID,HUSEORGID,HBarCode,HRemark,HShortNumber,HParentID,HEndFlag,HLevel,HMakeEmp,HMakeTime)" +
|
" values(" +
|
"'" + HNumber +
|
"','" + HName +
|
"','" + HHelpCode +
|
"'," + HStopFlag +
|
"," + HCREATEORGID +
|
"," + HUSEORGID +
|
",'" + HBarCode +
|
"','" + HRemark +
|
"','" + HShortNumber +
|
"'," + HParentID +
|
"," + HEndFlag +
|
"," + HLevel +
|
",'" + Emp +
|
"','" + Time +
|
"')";
|
oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
|
//新增后上级为非末级代码
|
oCN.RunProc("Update Gy_TemporaryArea set HEndFlag=0 where HItemID = " + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
|
oCN.Commit();
|
}else{ //编辑保存
|
oCN.BeginTran();
|
|
//判断该记录更改后，该记录的上级记录是否为末级，并更改末级标记
|
string sql = @"select * from Gy_TemporaryArea AS a where a.HParentID in (select b.HParentID from Gy_TemporaryArea AS b where b.HItemID = " + HItemID + ")";
|
ds = oCN.RunProcReturn(sql, "Gy_TemporaryArea");
|
if (ds != null && ds.Tables[0].Rows.Count == 1)
|
{
|
sql = "update Gy_TemporaryArea set HEndFlag = 1 where HItemID = " + ds.Tables[0].Rows[0]["HParentID"].ToString();
|
oCN.RunProc(sql);
|
}
|
|
if (HStopFlag == 1)
|
{
|
//更新记录
|
sql = "Update Gy_TemporaryArea set " +
|
" HNumber = '" + HNumber +
|
"', HName = '" + HName +
|
"', HHelpCode = '" + HHelpCode +
|
"', HStopFlag = " + HStopFlag +
|
", HCREATEORGID = " + HCREATEORGID +
|
", HUSEORGID = " + HUSEORGID +
|
", HBarCode = '" + HBarCode +
|
"', HRemark = '" + HRemark +
|
"', HShortNumber = '" + HShortNumber +
|
"', HParentID = " + HParentID +
|
", HEndFlag = " + HEndFlag +
|
", HLevel = " + HLevel +
|
", HModifyEmp = '" + Emp +
|
"', HModifyTime = '" + Time +
|
"', HStopEmp = '" + Emp +
|
"', HStopTime = '" + Time +
|
"' Where HItemID=" + HItemID;
|
}
|
else
|
{
|
//更新记录
|
sql = "Update Gy_TemporaryArea set " +
|
" HNumber = '" + HNumber +
|
"', HName = '" + HName +
|
"', HHelpCode = '" + HHelpCode +
|
"', HStopFlag = " + HStopFlag +
|
", HCREATEORGID = " + HCREATEORGID +
|
", HUSEORGID = " + HUSEORGID +
|
", HBarCode = '" + HBarCode +
|
"', HRemark = '" + HRemark +
|
"', HShortNumber = '" + HShortNumber +
|
"', HParentID = " + HParentID +
|
", HEndFlag = " + HEndFlag +
|
", HLevel = " + HLevel +
|
", HModifyEmp = '" + Emp +
|
"', HModifyTime = '" + Time +
|
"', HStopEmp = '" + "" +
|
"', HStopTime = " + "null" +
|
" Where HItemID=" + HItemID;
|
}
|
oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
|
|
//修改后，将新上级更新为非末级
|
oCN.RunProc("Update Gy_TemporaryArea set HEndFlag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
|
|
oCN.Commit();
|
}
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.Message;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 暂存区-查询
|
/// <summary>
|
/// 返回项目阶段列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("Gy_TemporaryArea/list")]
|
[HttpGet]
|
public object getTemporaryArea(string sWhere, string user)
|
{
|
try
|
{
|
List<object> columnNameList = new List<object>();
|
if (!DBUtility.ClsPub.Security_Log("Gy_TemporaryAreaList", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无查看权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_TemporaryAreaList order by HItemID desc", "h_v_Gy_TemporaryAreaList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_Gy_TemporaryAreaList where 1 = 1 ";
|
string sql = sql1 + sWhere + " order by HItemID desc";
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_TemporaryAreaList");
|
}
|
|
//添加列名
|
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>
|
///参数：string HInterID。
|
///返回值：object。
|
/// </summary>
|
[Route("Gy_TemporaryArea/editInit")]
|
[HttpGet]
|
public object getTemporaryAreaeditInit(string HInterID, string user)
|
{
|
try
|
{
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_TemporaryArea_Edit", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无编辑权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (HInterID == null || HInterID.Equals(""))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HInterID不能为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
string sql = "select * from Gy_TemporaryArea where HItemID = " + HInterID;
|
ds = oCN.RunProcReturn(sql, "Gy_TemporaryArea");
|
|
if(ds==null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "未查询到记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}else if(ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "该暂存区已审核，不可编辑！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 暂放区 删除
|
/// <summary>
|
///参数：string HInterID。
|
///返回值：object。
|
/// </summary>
|
[Route("Gy_TemporaryArea/delete")]
|
[HttpGet]
|
public object deleteTemporaryArea(string HInterID, string user)
|
{
|
try
|
{
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Gy_TemporaryArea_Drop", 1, false, user))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "无删除权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (HInterID == null || HInterID.Equals(""))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "HInterID不能为空！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//根据记录状态判断是否可以删除
|
string sql = "select * from Gy_TemporaryArea where HItemID = " + HInterID;
|
ds = oCN.RunProcReturn(sql, "Gy_TemporaryArea");
|
if(ds!=null && ds.Tables[0].Rows.Count>0 && ds.Tables[0].Rows[0]["HCheckEmp"].ToString()!="" && ds.Tables[0].Rows[0]["HStopEmp"].ToString()=="")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "该暂存区不可删除，请检查该暂存区的状态！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.BeginTran();
|
|
//判断该记录删除后，该记录的上级记录是否为末级，并更改末级标记
|
sql = @"select * from Gy_TemporaryArea AS a where a.HParentID in (select b.HParentID from Gy_TemporaryArea AS b where b.HItemID = " + HInterID + ")";
|
ds = oCN.RunProcReturn(sql, "Gy_TemporaryArea");
|
if(ds!=null && ds.Tables[0].Rows.Count == 1)
|
{
|
sql = "update Gy_TemporaryArea set HEndFlag = 1 where HItemID = " + ds.Tables[0].Rows[0]["HParentID"].ToString();
|
oCN.RunProc(sql);
|
}
|
|
//删除该记录
|
oCN.RunProc("delete from Gy_TemporaryArea where HItemID = " + HInterID);
|
|
oCN.Commit();
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = null;
|
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="HInterID">单据ID</param>
|
/// <param name="Type">审核(1),反审核(2)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_TemporaryArea/AuditGy_TemporaryArea")]
|
[HttpGet]
|
public object AuditGy_TemporaryArea(int HInterID, int IsAudit, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_TemporaryArea_Check", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "审核失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
ds = oCN.RunProcReturn("select * from Gy_TemporaryArea where HItemID=" + HInterID, "Gy_TemporaryArea");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
//if (bool.Parse(ds.Tables[0].Rows[0]["HStopFlag"].ToString())){
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "暂放区已禁用!不能再进行审核或反审核！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
//}
|
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) //审核判断
|
{
|
oCN.RunProc("update Gy_TemporaryArea set HCheckEmp='" + CurUserName + "',HCheckTime=getdate() where HItemID=" + HInterID);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功";
|
objJsonResult.data = null;
|
}
|
if (IsAudit == 1) //反审核判断
|
{
|
oCN.RunProc("update Gy_TemporaryArea set HCheckEmp='',HCheckTime=null where HItemID=" + HInterID);
|
|
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;
|
}
|
}
|
#endregion
|
|
#region 暂放区 禁用、反禁用
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="HInterID">单据ID</param>
|
/// <param name="IsStop">禁用(0),反禁用(1)</param>
|
/// <param name="CurUserName">审核人</param>
|
/// <returns></returns>
|
[Route("Gy_TemporaryArea/StopGy_TemporaryArea")]
|
[HttpGet]
|
public object StopGy_TemporaryArea(int HInterID, int IsStop, string CurUserName)
|
{
|
try
|
{
|
//审核权限
|
if (!DBUtility.ClsPub.Security_Log_second("Gy_TemporaryArea_Stop", 1, false, CurUserName))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "禁用失败！无权限！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var ds = oCN.RunProcReturn("select * from Gy_TemporaryArea where HItemID=" + HInterID, "Gy_TemporaryArea");
|
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) //禁用判断
|
{
|
oCN.RunProc("update Gy_TemporaryArea set HStopEmp='" + CurUserName + "',HStopTime=getdate(),HStopFlag=1 where HItemID=" + HInterID);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "禁用成功";
|
objJsonResult.data = null;
|
}
|
if (IsStop == 1) //反禁用判断
|
{
|
oCN.RunProc("update Gy_TemporaryArea set HStopEmp='',HStopTime=null,HStopflag=0 where HItemID=" + HInterID);
|
|
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;
|
}
|
}
|
#endregion
|
}
|
}
|
