派生自 MES-WEB-API
WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
@@ -27,18 +27,27 @@ /// </summary> [Route("Gy_Material/list")] [HttpGet] public object list(string sWhere, string Organization) public object list(string sWhere,string user, string Organization) { try { //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_Material", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where 组织名称='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_Gy_MaterialList"); ds = oCN.RunProcReturn(sql1 + sWhere + " order by 物料代码 ", "h_v_Gy_MaterialList"); } else { string sql = sql1 + sWhere + "order by HItemID desc"; string sql = sql1 + sWhere + " order by 物料代码 "; ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterialList"); } @@ -80,12 +89,23 @@ { DataSet ds; var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[1].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_Material_Edit", 1, false, msg2)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限！"; objJsonResult.data = null; return objJsonResult; } //获取最大ID值赋值 DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_Material ", "Gy_Material"); if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) @@ -96,6 +116,7 @@ HItemID = maxid; } ListModels oListModels = new ListModels(); try { DLL.ClsGy_Material_Ctl oBill = new DLL.ClsGy_Material_Ctl(); @@ -276,21 +297,20 @@ /// <returns></returns> [Route("Gy_Material/Delete")] [HttpGet] public object DeltetGy_Material(string HItemID) public object DeltetGy_Material(string HItemID,string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //删除权限 //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "审核失败！无权限！"; // objJsonResult.data = null; // return objJsonResult; //} if (!DBUtility.ClsPub.Security_Log("Gy_Material_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)) @@ -353,7 +373,7 @@ { try { if (!DBUtility.ClsPub.Security_Log(ModRightNameSelect, 1, true, user)) if (!DBUtility.ClsPub.Security_Log(ModRightNameSelect, 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -363,30 +383,31 @@ } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by 日期 desc", "h_v_Gy_MouldFileList"); ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList " + sWhere + "order by hmainid desc", "h_v_Gy_MouldFileList"); } else { string sql1 = "select * from h_v_Gy_MouldFileList where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList"); } 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; } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception e) { @@ -457,36 +478,47 @@ /// </summary> [Route("Gy_BarCodeBillList/GetBarCodeBillList")] [HttpGet] public object GetBarCodeBillList(string sWhere) public object GetBarCodeBillList(string sWhere,string user) { try { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBill_Query", 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_IF_BarCodeBillList " + sWhere + "order by 日期 desc", "h_v_IF_BarCodeBillList"); ds = oCN.RunProcReturn("select * from h_v_IF_BarCodeBillList order by hmainid desc", "h_v_IF_BarCodeBillList"); } else { string sql1 = "select * from h_v_IF_BarCodeBillList where 1 = 1 "; string sql = sql1 + sWhere + "order by 日期 desc"; string sql = sql1 + sWhere + "order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_BarCodeBillList"); } 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; } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "无数据"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception e) { @@ -498,6 +530,79 @@ } } #region [返回条码档案删除功能] /// <summary> /// 返回条码档案删除功能 /// </summary> /// <returns></returns> [Route("Gy_MaterialController/DeltetBarCodeBill")] [HttpGet] public object DeltetBarCodeBill(string HInterID, string user) { //编辑权限 if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBillList_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } try { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据ID为空！"; objJsonResult.data = null; return objJsonResult; } DataSet Ds, Ds2; Ds = oCN.RunProcReturn("Select * from h_v_IF_BarCodeBillList Where HItemID=" + lngBillKey.ToString(), "h_v_IF_BarCodeBillList"); if (Ds.Tables[0].Rows.Count != 0) { oCN.BeginTran(); Ds2 = oCN.RunProcReturn("Delete from Gy_BarCodeBill Where HItemID=" + lngBillKey.ToString(), "Gy_BarCodeBill"); if (Ds2.Tables[0].Rows.Count != 0) { oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功"; objJsonResult.data = null; return objJsonResult; } oCN.RollBack(); 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; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = null; return objJsonResult; } } #endregion /// <summary> @@ -517,7 +622,7 @@ string msg4 = sArray[2].ToString();//当前人 oCN.BeginTran(); if (!DBUtility.ClsPub.Security_Log(msg3, 1, true, msg4)) if (!DBUtility.ClsPub.Security_Log(msg3, 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -594,6 +699,8 @@ int HCaveQty = mainList[0].HCaveQty; int HMouldDotCheckRuleInterID= mainList[0].HMouldDotCheckRuleInterID; int HMouldMaintainRuleInterID= mainList[0].HMouldMaintainRuleInterID; int HNowSupID = mainList[0].HNowSupID; int HNowSupTypeID = mainList[0].HNowSupTypeID; @@ -606,7 +713,7 @@ ",HMaterID,HMaterNumber,HMouldType,HUnitID" + ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" + ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" + ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife" + ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" + ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID" + ") " + " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + @@ -616,7 +723,7 @@ "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID + ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" + "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID +","+ HCaveQty+ "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "'" + "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID+"','"+ HNowSupTypeID+"'"+ ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID+"','"+ HMouldMaintainRuleInterID+"'"+ ") "); @@ -673,7 +780,7 @@ string msg4 = sArray[2].ToString();//当前人 try { if (!DBUtility.ClsPub.Security_Log(msg3, 1, true, msg4)) if (!DBUtility.ClsPub.Security_Log(msg3, 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -732,7 +839,8 @@ int HCaveQty = mainList[0].HCaveQty; int HMouldDotCheckRuleInterID = mainList[0].HMouldDotCheckRuleInterID; int HMouldMaintainRuleInterID = mainList[0].HMouldMaintainRuleInterID; int HNowSupID = mainList[0].HNowSupID; int HNowSupTypeID = mainList[0].HNowSupTypeID; //若MAINDI重复则重新获取 oCN.BeginTran(); @@ -781,6 +889,8 @@ ",HMouldDotCheckRuleInterID="+ HMouldDotCheckRuleInterID.ToString()+ ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() + ",HMouldOWNER='" + HMouldOWNER + "'" + ",HNowSupID="+HNowSupID.ToString()+ ",HNowSupTypeID="+HNowSupTypeID.ToString()+ ",HProdWeight=" + HProdWeight.ToString() + " where HInterID=" + HInterID.ToString()); @@ -850,7 +960,7 @@ DAL.ClsGy_MouldFile oBill = new DAL.ClsGy_MouldFile(); try { if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, user)) if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -898,7 +1008,7 @@ /// <returns></returns> [Route("Gy_Material/InitializeProdInBill")] [HttpGet] public object InitializeProdInBill(long hmainid, string user) public object InitializeProdInBill(long hmainid, string user,string userID) { DAL.ClsGy_MouldFile oBill = new DAL.ClsGy_MouldFile(); try @@ -921,17 +1031,26 @@ ", 0," + dr["HDeptID"].ToString() + ",' ',0" + ") "; string sql1 = string.Format(@"Insert Into Sc_MouldStockBillSub (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID, HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitRate,HSecUnitID,HUnitID, HBatchNo,HQtyMust,HQty,HPrice,HMoney,HDesignLife,HLeaveLife,HUseLife,HWHID,HSCWHID,HSPID,HSCSPID,HSPGroupID,HCorrespondentTypeID,HCorrespondentID, HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID+ ",1,'',getdate(),0,'',0,0,'','',"+ "0,0,"+dr["HInterID"].ToString()+",0,0,0,"+ dr["HUnitID"].ToString()+",0,"+ dr["HProdQty"].ToString() +","+ dr["HProdQty"].ToString()+",0,"+ "0,"+ dr["HDesignLife"].ToString()+","+ dr["HLeaveLife"].ToString() + ","+dr["HUseLife"].ToString() + "," + dr["HWHID"].ToString() + ",0," + dr["HSPID"].ToString()+",0,0" + ",0,0,"+ userID + ",0,0,'')"); //主表 oCN.RunProc(sql); oCN.RunProc(sql1); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "初始化成功！"; objJsonResult.Message = "初始化成功，单据号为"+ HBillNo; //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) catch (Exception) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -939,6 +1058,7 @@ objJsonResult.data = null; } return objJsonResult; } #region [模具档案审核、反审核] @@ -958,7 +1078,7 @@ try { //审核权限 if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0;
