using Model; 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; using Newtonsoft.Json; using System.Web; using WebAPI.Controllers.SCGL.日计划管理; using System.IO; namespace WebAPI.Controllers { public class Gy_WorkCenterController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; #region 工作中心 文件上传 [Route("Gy_WorkCenter/Gy_WorkCenter_Excel")] [HttpPost] public object Gy_WorkCenter_Excel() { try { //获取文件名称 var file = HttpContext.Current.Request.Files[0]; //获取文件物理路径 string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName); //保存文件 file.SaveAs(ExcelPath); NpoiHelper np = new NpoiHelper(); DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0"); //删除文件 File.Delete(ExcelPath); //创建临时表 DataTable tb2 = new DataTable("dt2"); //添加列名 for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) { tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); } //模板缺少列 但需要从数据库中查询出来显示在页面的字段 tb2.Columns.Add("HOrgID", typeof(Int32));//组织ID tb2.Columns.Add("HDeptID", typeof(Int32));//部门ID //添加数据 for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) { DataRow row = tb2.NewRow(); for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) { row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); } tb2.Rows.Add(row); } var error = ""; //查询工作中心没有的列 if (!tb2.Columns.Contains("组织代码")) error += "没有找到【组织代码】的标题,"; if (!tb2.Columns.Contains("组织名称")) error += "没有找到【组织名称】的标题,"; if (!tb2.Columns.Contains("部门代码")) error += "没有找到【部门代码】的标题,"; if (!tb2.Columns.Contains("部门名称")) error += "没有找到【部门名称】的标题,"; if (!tb2.Columns.Contains("工作中心代码")) error += "没有找到【工作中心代码】的标题,"; if (!tb2.Columns.Contains("工作中心名称")) error += "没有找到【工作中心名称】的标题,"; if (!tb2.Columns.Contains("工作时间")) error += "没有找到【工作时间】的标题,"; if (!tb2.Columns.Contains("设备数量")) error += "没有找到【设备数量】的标题,"; if (error.Length > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = $"Excel模板存在错误,{error}\r\n"; objJsonResult.data = null; return objJsonResult; } for (int i = 0; i <= tb2.Rows.Count - 1; i++) { string HORGNumber = ""; string HORGName = ""; string HDeptNum = ""; string HDeptName = ""; string HCentNum = ""; string HCentName = ""; string HWorkTimes = ""; string HQty = ""; HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织代码"].ToString()); HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织名称"].ToString()); HDeptNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["部门代码"].ToString()); HDeptName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["部门名称"].ToString()); HCentNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["工作中心代码"].ToString()); HCentName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["工作中心名称"].ToString()); HWorkTimes = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["工作时间"].ToString()); HQty = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["设备数量"].ToString()); //检查组织 int index = i + 1; if (HORGNumber != "") { //查询组织 ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,组织不存在！"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); //查询部门 ds = oCN.RunProcReturn("select * from Gy_Department where HNumber='" + HDeptNum + "' and HUSEORGID=" + HORGid + "", "Gy_Department"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,部门:" + HDeptName + ",不存在！"; objJsonResult.data = null; return objJsonResult; } else { tb2.Rows[i]["HDeptID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); } //工作中心名称 if (HCentName == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,工作中心名称不能为空！"; objJsonResult.data = null; return objJsonResult; } //工作中心代码 if (HCentNum == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,工作中心代码不能为空！"; objJsonResult.data = null; return objJsonResult; } //工作时间 if (HWorkTimes == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,工作时间不能为空！"; objJsonResult.data = null; return objJsonResult; } //工作数量 if (HWorkTimes == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + index + "行,工作数量不能为空！"; objJsonResult.data = null; return objJsonResult; } } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "第" + index + "行,组织代码为空"; objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = error; objJsonResult.data = tb2; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工作中心 导入(保存) [Route("Gy_WorkCenter/Gy_WorkCenter_btnSave")] [HttpPost] public object Gy_Source_btnSave([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { "&和" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string user = sArray[1].ToString(); try { if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } List Excel = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); List> list = new List>(); foreach (JObject item in Excel) { Dictionary dic = new Dictionary(); foreach (var itm in item.Properties()) { dic.Add(itm.Name, itm.Value.ToString()); } list.Add(dic); } oCN.BeginTran(); int i = 1; foreach (Dictionary item in list) { string HDeptID = item["HDeptID"].ToString();//部门 string HDeptNum = item["部门代码"].ToString();//部门 string HOrgID = item["HOrgID"].ToString();//组织ID string HWorkCenterName = item["工作中心名称"].ToString(); string HWorkCenterNum = item["工作中心代码"].ToString(); string HWorkTimes = item["工作时间"].ToString(); ; string HQty = item["设备数量"].ToString(); ; string sShortNumber; sShortNumber = DBUtility.ClsPub.GetShortNumber(HWorkCenterNum);//短代码 if (sShortNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！短代码为空！"; objJsonResult.data = 1; return objJsonResult; } int HEndFlag = 1;//末级标志 int HLevel = DBUtility.ClsPub.GetLevel(HWorkCenterNum); //等级 if (!DBUtility.ClsPub.AllowNumber(HWorkCenterNum.Trim())) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = 1; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HNumber='" + HWorkCenterNum + "'", "Gy_WorkCenter"); if (ds.Tables[0].Rows.Count == 0) { string sql = "insert into Gy_WorkCenter(HName,HNumber,HDeptID,HDeptNumber,HUSEORGID,HShortNumber,HEndFlag,HLevel,HWorkTimes,HQty,HParentID,HStopflag,HRemark,HHelpCode)" + $"values('{HWorkCenterName}', '{HWorkCenterNum}',{HDeptID}, '{HDeptNum}',{HOrgID}, '{sShortNumber}', {HEndFlag},{HLevel},{HWorkTimes},{HQty},0,0,'','')"; oCN.RunProc(sql); } else { oCN.RunProc(" update Gy_WorkCenter set HWorkTimes=" + HWorkTimes + ",HDeptID=" + HDeptID + ",HQty=" + HQty + " where HNumber='" + HWorkCenterNum + "'"); } i++; } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "导入成功!"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write(e); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion /// /// 工作中心动态列 /// /// /// /// [Route("Gy_WorkCenter/Gy_WorkCenterDyCollist")] [HttpGet] public object Gy_WorkCenterDyCollist(string sWhere,string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_WorkCenterList where 1 = 1 " + sWhere + " order by 工作中心代码 ", "h_v_WorkCenterList"); List listCol = new List(); foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; listCol.Add(JsonConvert.DeserializeObject(str)); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = listCol; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// /// 返回工作中心列表 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/list")] [HttpGet] public object list(string sWhere, string user) { try { List columnNameList = new List(); //查看权限 if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_WorkCenterList where 1 = 1 " + sWhere + " order by 工作中心代码 ", "h_v_WorkCenterList"); //添加列名 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; } } /// /// 根据基础资料ID 查找记录 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_WorkCenterList where HitemID=" + HInterID, "h_v_WorkCenterList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "false！"; objJsonResult.data = null; return objJsonResult; } else { 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; } } [Route("Gy_WorkCenter/LoadTree")] [HttpGet] public object LoadTree_Json(string sWhere) { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); ds = oCN.RunProcReturn("select * from h_v_WorkCenterLoadTree", "h_v_WorkCenterLoadTree"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "false！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } /// /// 新增单据-保存按钮 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/AddBill")] [HttpPost] public object AddBill([FromBody] JObject oMain) { try { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); //反序列化 msg1 = "[" + msg1.ToString() + "]"; DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View(); List list = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg1); long HItemID = list[0].HItemID ; string HNumber = list[0].HNumber; string HName = list[0].HName; string HShortNumber = list[0].HShortNumber; long HParentID = list[0].HParentID; string HHelpCode = list[0].HHelpCode; string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; string HUseFlag = list[0].HUseFlag; var HWorkTimes = list[0].HWorkTimes; var HQty = list[0].HQty; var HBarCodeForBase = list[0].HBarCodeForBase; var HDayMoney = list[0].HDayMoney; var HDeptID = list[0].HDeptID; var HDeptNumber = ""; var HEndFlag = 0; var HLevel = ""; var HProcID = ""; if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！"; objJsonResult.data = null; return objJsonResult; } //若MAINDI重复则重新获取 oCN.BeginTran(); //主表 string sql = "Insert into Gy_WorkCenter " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HDeptNumber,HWorkTimes,HQty" + ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" + ",HProcID,HDayMoney) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + ",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty + ",'" + HLevel.ToString() + "'," + HEndFlag + "," + HStopflag + ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "','" + HProcID + "'," + HDayMoney + ")"; oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 if (list[0].HItemID.ToString() != "") { oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "新增成功！"; //objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.Message; objJsonResult.data = null; return objJsonResult; } } /// /// 保存按钮 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/ModifyByID")] [HttpPost] public object ModifyByID([FromBody] JObject oMain) { try { DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View(); var _value = oMain["oMain"].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, msg2)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无编辑权限!"; objJsonResult.data = null; return objJsonResult; } //反序列化 msg1 = "[" + msg1.ToString() + "]"; List list = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg1); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HDeptNumber = list[0].HDeptNumber; string HHelpCode = list[0].HHelpCode; string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; string HUseFlag = list[0].HUseFlag; var HQty = list[0].HQty; var HBarCodeForBase = list[0].HBarCodeForBase; var HDayMoney = list[0].HDayMoney; var HDeptID = list[0].HDeptID; var HProcID = list[0].HProcID; var HWorkTimes = list[0].HWorkTimes; int HUSEORGID = list[0].HUSEORGID; string HMaker = msg2; //末级标志 bool HEndFlag = true; //得到短代码 string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); if (HShortNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！短代码为空！"; objJsonResult.data = 1; return objJsonResult; } //等级 int HLevel = DBUtility.ClsPub.GetLevel(HNumber); //检查父级是否存在 long HParentID = 0; string sParent = DBUtility.ClsPub.GetParentCode(HNumber); if (sParent.Trim() == "") { HParentID = 0; } else { ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HNumber='" + sParent + "' and HStopFlag=0 ", "Gy_WorkCenter"); if (ds.Tables[0].Rows.Count > 0) { HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！上级代码不存在或被禁用！"; objJsonResult.data = 1; return objJsonResult; } } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！"; // objJsonResult.data = null; // return objJsonResult; //} //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代码重复！"; // objJsonResult.data = null; // return objJsonResult; //} //保存 //保存完毕后处理 if (HItemID == 0) { oCN.BeginTran(); oCN.RunProc("Insert into Gy_WorkCenter " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HDeptNumber,HWorkTimes,HQty" + ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" + ",HProcID,HDayMoney,HUSEORGID,HMaker,HMakeTime) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + ",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty + "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ","+ HUSEORGID + "" + ",'"+ HMaker + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { //若MAINDI重复则重新获取 oCN.BeginTran(); oCN.RunProc("Update Gy_WorkCenter set " + " HNumber='" + HNumber + "'" + ",HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HParentID=" + HParentID + ",HStopflag='" + HStopflag + "'" + ",HRemark= '" + HRemark + "'" + ",HUpDater= '" + HMaker + "'" + ",HUpDateDate= getdate()" + ",HDeptID=" + HDeptID + ",HLevel=" + HLevel + ",HQty=" + HQty + ",HWorkTimes=" + HWorkTimes + ",HDayMoney=" + HDayMoney + ",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //修改子项目代码 //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_WorkCenter,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //将上级 为非末级 oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.Message; objJsonResult.data = null; return objJsonResult; } } ///// ///// 修改单据-保存按钮 /////参数：string sql。 /////返回值：object。 ///// //[Route("Gy_WorkCenter/EditBill")] //[HttpPost] //public object EditBill([FromBody] JObject oMain) //{ // try // { // var _value = oMain["oMain"].ToString(); // string msg1 = _value.ToString(); // //反序列化 // msg1 = "[" + msg1.ToString() + "]"; // DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); // List list = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg1); //long HItemID = list[0].HItemID; //string HNumber = list[0].HNumber; //string HName = list[0].HName; //string HShortNumber = list[0].HNumber; //long HParentID = list[0].HParentID; //string HHelpCode = list[0].HHelpCode; //string HRemark = list[0].HRemark; //string HStopflag = list[0].HStopflag; //string HUseFlag = list[0].HUseFlag; //var HQty = list[0].HQty; //var HBarCodeForBase = list[0].HBarCodeForBase; //var HDayMoney = list[0].HDayMoney; //var HDeptID = list[0].HDeptID; //var HWorkTimes = list[0].HWorkTimes; // //判断权限 // //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) // //{ // // 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; // //} // //if (oDept.HavSameNumber(HItemID, HNumber)) // //{ // // objJsonResult.code = "0"; // // objJsonResult.count = 0; // // objJsonResult.Message = "代码重复！"; // // objJsonResult.data = null; // // return objJsonResult; // //} // //若MAINDI重复则重新获取 // oCN.BeginTran(); // //主表 // oCN.RunProc("Update Gy_WorkCenter set " + // " HNumber='" + HNumber + "'" + // ",HName='" + HName + "'" + // ",HShortNumber='" + HShortNumber + "'" + // ",HHelpCode='" + HHelpCode + "'" + // ",HParentID=" + HParentID + // ",HStopflag='" + HStopflag + "'" + // ",HRemark= '" + HRemark + "'"+ // ",HDeptID=" + HDeptID + // ",HQty=" + HQty + // ",HWorkTimes=" + HWorkTimes + // ",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); // //修改子项目代码 // //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_WorkCenter,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); // //将上级 为非末级 // oCN.RunProc("Update Gy_WorkCenter 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) // { // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "Exception！" + e.Message; // objJsonResult.data = null; // return objJsonResult; // } //} /// /// 工作中心删除功能 /// /// [Route("DeltetGy_WorkCenter")] [HttpGet] public object DeltetGy_WorkCenter(string HItemID,string user) { DataSet ds; DataSet ds1; try { //删除权限 if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_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_WorkCenter where HItemID=" + HItemID, "Gy_WorkCenter"); 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"] != null && ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "已经审核不能删除！"; objJsonResult.data = null; return objJsonResult; ; } //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); //if (HStopflag) //{ // oCN.RollBack();//回滚事务 // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "数据已删除无法再次删除！"; // objJsonResult.data = null; // return objJsonResult; //} ds1 = oCN.RunProcReturn("Select HItemID from Gy_WorkCenter Where HParentID='" + HItemID + "'", " Gy_WorkCenter"); if (ds1.Tables[0].Rows.Count != 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此项目存在子项目，不能删除！"; objJsonResult.data = null; return objJsonResult; } string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]); if (HUseFlag == "已使用") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此项目已使用，不能删除！"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("delete from Gy_WorkCenter where HItemID=" + HItemID); 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; } } /// /// 工作中心列表修改按钮方法 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/xg")] [HttpGet] public object xg(long HInterID) { try { ds = oCN.RunProcReturn("select a.*,b.HName HDeptName from Gy_WorkCenter a left join Gy_Department b on a.HDeptID = b.HItemID where a.HItemID=" + HInterID, "Gy_WorkCenter"); 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; } } /// /// 维修方式列表删除按钮 ///参数：string sql。 ///返回值：object。 /// [Route("Gy_WorkCenter/Delete_Json")] [HttpGet] public object Delete_Json(long HItemID, string User, string ModRightNameDelete) { DAL.ClsGy_WorkCenter_Ctl oDept = new DAL.ClsGy_WorkCenter_Ctl(); DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View(); try { if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有删除权限"; objJsonResult.data = null; return objJsonResult; } if (oDeptHlp.GetInfoByID(HItemID)) { if (oDept.HavChildCodes(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此项目存在子项目,不能删除！"; objJsonResult.data = null; return objJsonResult; } //删除前判断是否 已使用 20141020 if (oDeptHlp.omodel.HUseFlag != "未使用") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此项目已使用或者未检测，不能删除！请重新检测再删除！"; objJsonResult.data = null; return objJsonResult; } // if (oDept.DeleteByID(HItemID)) { //写入日志 ClsPub.Add_Log("", "删除项目，代码：" + oDeptHlp.omodel.HNumber + ",名称：" + oDeptHlp.omodel.HName, ClsPub.CurUserName); //更新上级为 末级 objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败"; objJsonResult.data = null; return objJsonResult; } } //ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department"); 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.ToString(); objJsonResult.data = null; return objJsonResult; } } #region 工作中心审核、反审核 /// /// /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// [Route("Gy_WorkCenter/AuditGy_WorkCenter")] [HttpGet] public object AuditGy_WorkCenter(int HInterID, int IsAudit, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_WorkCenter_Check", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HItemID=" + HInterID, "Gy_WorkCenter"); 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) //审核判断 { oCN.RunProc("update Gy_WorkCenter 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_WorkCenter 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 工作中心禁用、反禁用 /// /// /// /// 单据ID /// 禁用(0),反禁用(1) /// 审核人 /// [Route("Gy_WorkCenter/StopGy_WorkCenter")] [HttpGet] public object StopGy_Material(int HInterID, int IsStop, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_WorkCenter_Stop", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "禁用失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HItemID=" + HInterID, "Gy_WorkCenter"); 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_WorkCenter 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_WorkCenter 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 } }