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 { //工序检验单Controller public class QC_LastPieceCheckBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; SQLHelper.ClsCN oCN1 = new SQLHelper.ClsCN(); DataSet ds1; public WebServer webserver = new WebServer(); public DAL.ClsQC_LastPieceCheckBill BillOld = new DAL.ClsQC_LastPieceCheckBill(); #region 检验值保存 [Route("QC_LastPieceCheckBill/set_SaveValue")] [HttpPost] public object set_SaveValue([FromBody] JObject msg) { ListModels oListModels = new ListModels(); try { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string Value = sArray[0].ToString(); //检验值表格 Int64 HInterID = Convert.ToInt64(sArray[1]); //主ID Int64 HEntryID = Convert.ToInt64(sArray[2]); //子ID bool bResult; List valueList = new List(); valueList = oListModels.getObjectByJson_ClsQC_LastPieceCheckBillSub_ValueGrid(Value); DAL.ClsQC_LastPieceCheckBill BillNew = new DAL.ClsQC_LastPieceCheckBill(); for (int i = 0; i < valueList.ToArray().Length; i++) { if (i >= 0)//HQty { Model.ClsQC_LastPieceCheckBillSub_ValueGrid oSub_Value = new Model.ClsQC_LastPieceCheckBillSub_ValueGrid(); oSub_Value.HInterID = HInterID; oSub_Value.HEntryID = HEntryID; oSub_Value.HSEQ = i + 1; oSub_Value.HInSpectResult = ClsPub.isStrNull(valueList[i].HInSpectResult); oSub_Value.HInSpectValue = ClsPub.isDoule(valueList[i].HInSpectValue); oSub_Value.HInSpectValueB = ClsPub.isLong(valueList[i].HInSpectValueB); oSub_Value.HInSpectValueT = ClsPub.isStrNull(valueList[i].HInSpectValueT); BillNew.DetailColl_Value.Add(oSub_Value); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无明细行信息!"; objJsonResult.data = null; return objJsonResult; } } bResult = BillNew.AddValue(ref ClsPub.sExeReturnInfo, ref HInterID, ref HEntryID); if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存检验值成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败!原因:" + ClsPub.sExeReturnInfo; 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 [返回检验值列表] /// ///返回检验值列表 /// /// /// [Route("QC_LastPieceCheckBill_ValueTable/getValueList")] [HttpGet] public object getValueList(Int64 HInterID, Int64 HEntryID, string user) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); List columnNameList = new List(); ds = oCN.RunProcReturn("select * from QC_LastPieceCheckBillSub_ValueGrid where HInterID=" + HInterID + " and HEntryID=" + HEntryID, "QC_LastPieceCheckBillSub_ValueGrid"); //添加列名 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列对象的列名 } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无检测值数据！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region [返回 编辑时 检验值 列表] [Route("QC_LastPieceCheckBill/QC_LastPieceCheckBill_Edit")] [HttpGet] public object QC_LastPieceCheckBill_Edit(string sWhere, string user) { try { List columnNameList = new List(); string sql1 = "select * from h_v_QC_LastPieceCheckBill_Edit where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_LastPieceCheckBill_Edit"); //添加列名 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列对象的列名 } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查询到数据"; objJsonResult.list = columnNameList; 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 生产入库校验单 审核 反审核 关闭 反关闭 作废 反作废 #region 生产入库校验单 审核 反审核 /// /// 入库校验单维护 审核、反审核 /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// [Route("QC_LastPieceCheck_ValueTable/QC_LastPieceCheckValue")] [HttpGet] public object QC_LastPieceCheckValue(int HInterID, int IsAudit, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("QC_LastPieceCheckBill_Check", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from QC_LastPieceCheckBillMain where HInterID=" + HInterID, "QC_LastPieceCheckBillMain"); if (ds.Tables[0].Rows.Count > 0) { if (IsAudit == 0) //审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能再次审核！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //反审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].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) //审核判断 { //审核前控制 DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_QC_LastPieceCheckBill_BeforeCheckCtrl " + HInterID.ToString() + ",'" + CurUserName + "'", "h_p_QC_LastPieceCheck_BeforeCheckCtrl"); if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核前判断失败！"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } oCN.RunProc("update QC_LastPieceCheckBillMain set HChecker='" + CurUserName + "',HCheckDate=getdate(), HBillStatus=2 where HInterID=" + HInterID); //审核后控制 DataSet EndDs = oCN.RunProcReturn("Exec h_p_QC_LastPieceCheckBill_AfterCheckCtrl " + HInterID.ToString() + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'", "h_p_QC_LastPieceCheck_AfterCheckCtrl"); if (EndDs == null || EndDs.Tables.Count == 0 || EndDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核后判断失败！"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } else { if (DBUtility.ClsPub.isLong(EndDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(EndDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核成功"; objJsonResult.data = null; } if (IsAudit == 1) //反审核判断 { //反审核前控制 DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_QC_LastPieceCheckBill_BeforeUnCheckCtrl " + HInterID.ToString() + ",'" + CurUserName + "'", "h_p_QC_LastPieceCheck_BeforeUnCheckCtrl"); if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核前判断失败！"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } oCN.RunProc("update QC_LastPieceCheckBillMain set HChecker='',HCheckDate=null,HBillStatus=1 where HInterID=" + HInterID); //反审核后控制 DataSet EndDs = oCN.RunProcReturn("Exec h_p_QC_LastPieceCheckBill_AfterUnCheckCtrl " + HInterID.ToString() + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'", " h_p_QC_LastPieceCheck_AfterUnCheckCtrl"); if (EndDs == null || EndDs.Tables.Count == 0 || EndDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核后判断失败！"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } else { if (DBUtility.ClsPub.isLong(EndDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(EndDs.Tables[0].Rows[0]["HRemark"]); 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; } } #endregion #region 产品入库检验单维护 关闭 反关闭 /// /// 产品入库检验单维护 关闭 反关闭 /// /// /// /// /// [Route("QC_LastPieceCheck_ValueTable/CloseQC_LastPieceCheckBill")] [HttpGet] public object CloseQC_LastPieceCheckValue(string HInterID, int Type, string user) { try { //判断是否有删除权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBill_Close", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限关闭!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空！"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); ClsPub.CurUserName = user; DAL.ClsQC_LastPieceCheckBill oBill = new DAL.ClsQC_LastPieceCheckBill(); BillOld.MvarItemKey = "QC_LastPieceCheckBillMain"; //针对需要进行的操作，检验当前单据的状态是否支持需要进行的操作 if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //根据HInterID获取该单据的数据 { if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能进行关闭！"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未审核!不能进行关闭！"; objJsonResult.data = null; return objJsonResult; } if (Type == 1) //关闭判断 { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次关闭！"; objJsonResult.data = null; return objJsonResult; } } if (Type == 2) //反关闭判断 { if (oBill.omodel.HCloseMan.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未关闭!不需要反关闭！"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //进行需要进行的关闭/反关闭操作 if (Type == 1) //关闭提交 { //关闭前控制========================================= string sql1 = "exec h_p_QC_LastPieceCheckBill_BeforeCloseCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'"; ds = oCN.RunProcReturn(sql1, "h_p_QC_LastPieceCheckBill_BeforeCloseCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "关闭失败!原因:关闭前判断失败，请与网络管理人员联系"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; return objJsonResult; } //================================================================================== //关闭提交 if (oBill.CloseBill(lngBillKey, oBill.omodel.HBillNo, "h_p_QC_LastPieceCheckBill_AfterCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "关闭成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } if (Type == 2) //反关闭提交 { //反关闭前控制========================================= string sql1 = "exec h_p_QC_LastPieceCheckBill_BeforeUnCloseCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + user + "'"; ds = oCN.RunProcReturn(sql1, "h_p_QC_LastPieceCheckBill_BeforeUnCloseCtrl "); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "反关闭失败!原因:反关闭前判断失败，请与网络管理人员联系"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "反关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; return objJsonResult; } //================================================================================== //反关闭提交 if (oBill.CancelClose(lngBillKey, oBill.omodel.HBillNo, "h_p_QC_LastPieceCheckBill_AfterUnCloseCtrl", user, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反关闭成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反关闭失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "执行失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 产品入库检验单维护 作废 反作废 /// /// 产品入库检验单维护 作废 反作废 /// /// /// /// /// [Route("QC_LastPieceCheck_ValueTable/DropQC_LastPieceCheckBill")] [HttpGet] public object DropQC_LastPieceCheckBills(string HInterID, int Type, string user) { try { //判断是否有作废权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBill_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无权限作废!"; objJsonResult.data = null; return objJsonResult; } if (string.IsNullOrWhiteSpace(HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterID为空！"; objJsonResult.data = null; return objJsonResult; } ClsPub.CurUserName = user; BillOld.MvarItemKey = "QC_LastPieceCheckBillMain"; oCN.BeginTran();//开始事务 //Type 1 作废 2 反作废 if (Type == 1) { //判断单据是否已经作废 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在！"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能进行作废!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不需要再作废!"; objJsonResult.data = null; return objJsonResult; } //作废单据 if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } } else { //判断单据是否已经反作废 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能进行作废!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未作废!不需要再反作废!"; objJsonResult.data = null; return objJsonResult; } //反作废单据 if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo; 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 #endregion #region 产品入库检验单保存 [Route("QC_LastPieceCheckBill/set_SaveBill")] [HttpPost] public object set_SaveBill([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //保存单据 return objJsonResult = AddBillMain(msg1); } public json AddBillMain(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string OperationType = sArray[2].ToString().Trim(); string user = sArray[3].ToString(); string Value = sArray[4].ToString(); bool bResult; try { //判断权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限"; objJsonResult.data = null; return objJsonResult; } msg2 = "[" + msg2.ToString() + "]"; List mainList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); DAL.ClsQC_LastPieceCheckBill BillNew = new DAL.ClsQC_LastPieceCheckBill(); //判断会计期是否合理 string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//日期 if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; //固定赋值================================= BillNew.omodel.HInterID = mainList[0].HInterID;//递入type得到的单据ID BillNew.omodel.HBillNo = mainList[0].HBillNo;//递入type得到的单据号 BillNew.omodel.HDate = HDate; BillNew.omodel.HRemark = mainList[0].HRemark;//备注 BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HSourceID = ClsPub.isLong(mainList[0].HSourceID); BillNew.omodel.HICMOInterID = ClsPub.isLong(mainList[0].HICMOInterID); BillNew.omodel.HICMOBillNo = ClsPub.isStrNull(mainList[0].HICMOBillNo); BillNew.omodel.HICMOEntryID = ClsPub.isLong(mainList[0].HICMOEntryID); BillNew.omodel.HICMOQty = ClsPub.isLong(mainList[0].HICMOQty); BillNew.omodel.HProcExchInterID = ClsPub.isLong(mainList[0].HProcExchInterID); BillNew.omodel.HProcExchEntryID = ClsPub.isLong(mainList[0].HProcExchEntryID); BillNew.omodel.HProcExchBillNo = ClsPub.isStrNull(mainList[0].HProcExchBillNo); BillNew.omodel.HProcExchQty = ClsPub.isLong(mainList[0].HProcExchQty); BillNew.omodel.HProcID = ClsPub.isLong(mainList[0].HProcID); BillNew.omodel.HMaterID = ClsPub.isLong(mainList[0].HMaterID); BillNew.omodel.HFirstCheckEmp = ClsPub.isLong(mainList[0].HFirstCheckEmp); BillNew.omodel.HLastResult = ClsPub.isBool(mainList[0].HLastResult); BillNew.omodel.HMainSourceInterID = ClsPub.isLong(mainList[0].HMainSourceInterID); BillNew.omodel.HMainSourceEntryID = ClsPub.isLong(mainList[0].HMainSourceEntryID); BillNew.omodel.HMainSourceBillNo = ClsPub.isStrNull(mainList[0].HMainSourceBillNo); BillNew.omodel.HMainSourceBillType = ClsPub.isStrNull(mainList[0].HMainSourceBillType); BillNew.omodel.HQCSchemeID = ClsPub.isLong(mainList[0].HQCSchemeID); BillNew.omodel.HBillStatus = 1; BillNew.omodel.HShiftsID = ClsPub.isLong(mainList[0].HShiftsID); BillNew.omodel.HErrTreatment = ClsPub.isStrNull(mainList[0].HErrTreatment); BillNew.omodel.HBatchNo = ClsPub.isStrNull(mainList[0].HBatchNo); BillNew.omodel.HTakeSampleCheckBillID = ClsPub.isLong(mainList[0].HTakeSampleCheckBillID); BillNew.omodel.HTakeSampleCheckBillNo = ClsPub.isStrNull(mainList[0].HTakeSampleCheckBillNo); List subList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg3); BillNew.DetailColl = new List(); for (int i = 0; i < subList.ToArray().Length; i++) { if (i >= 0)//HQty { Model.ClsQC_LastPieceCheckBillSub oSub = new Model.ClsQC_LastPieceCheckBillSub(); oSub.HEntryID = i + 1; oSub.HRemark = ClsPub.isStrNull(subList[i].HRemark); oSub.HSourceInterID = ClsPub.isLong(subList[i].HSourceInterID); oSub.HSourceEntryID = ClsPub.isLong(subList[i].HSourceEntryID); oSub.HSourceBillType = ClsPub.isStrNull(subList[i].HSourceBillType); oSub.HSourceBillNo = ClsPub.isStrNull(subList[i].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[i].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[i].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[i].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[i].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[i].HCloseType); oSub.HQCCheckItemID = DBUtility.ClsPub.isLong(subList[i].HQCCheckItemID); oSub.HQCStd = DBUtility.ClsPub.isStrNull(subList[i].HQCStd); oSub.HUnit = DBUtility.ClsPub.isStrNull(subList[i].HUnit); oSub.HQCNote = DBUtility.ClsPub.isStrNull(subList[i].HQCNote); oSub.HResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); oSub.HMax = DBUtility.ClsPub.isStrNull(subList[i].HMax); oSub.HMin = DBUtility.ClsPub.isStrNull(subList[i].HMin); oSub.HAvg = DBUtility.ClsPub.isStrNull(subList[i].HAvg); oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(mainList[0].HBillNo); oSub.HSampleSchemeID = DBUtility.ClsPub.isLong(subList[i].HSampleSchemeID); oSub.HSampleQty = DBUtility.ClsPub.isLong(subList[i].HSampleQty); oSub.HSampleDamageQty = DBUtility.ClsPub.isDoule(subList[i].HSampleDamageQty); oSub.HAcceptQty = DBUtility.ClsPub.isLong(subList[i].HAcceptQty); oSub.HRejectQty = DBUtility.ClsPub.isLong(subList[i].HRejectQty); oSub.HSampleUnRightQty = DBUtility.ClsPub.isDoule(subList[i].HSampleUnRightQty); oSub.HStatus = DBUtility.ClsPub.isStrNull(subList[i].HStatus); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[i].HUnitID); oSub.HInspectVal = DBUtility.ClsPub.isStrNull(subList[i].HInspectVal); oSub.HTargetVal = DBUtility.ClsPub.isStrNull(subList[i].HTargetVal); oSub.HUpLimit = DBUtility.ClsPub.isStrNull(subList[i].HUpLimit); oSub.HDownLimit = DBUtility.ClsPub.isStrNull(subList[i].HDownLimit); oSub.HUpOffSet = DBUtility.ClsPub.isStrNull(subList[i].HUpOffSet); oSub.HDownOffSet = DBUtility.ClsPub.isStrNull(subList[i].HDownOffSet); oSub.HAnalysisMethod = DBUtility.ClsPub.isStrNull(subList[i].HAnalysisMethod); oSub.HKeyInspect = DBUtility.ClsPub.isLong(subList[i].HKeyInspect); oSub.HInspectInstruMentID = DBUtility.ClsPub.isLong(subList[i].HInspectInstruMentID); oSub.HInspectResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); BillNew.DetailColl.Add(oSub); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无明细行信息!"; objJsonResult.data = null; return objJsonResult; } } //保存完毕后处理 if (OperationType.Equals("1") || OperationType.Equals("2")) { bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); } else { if (BillOld.ShowBill(mainList[0].HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据有误！"; objJsonResult.data = 1; return objJsonResult; } //判断是否可编辑 if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "此单据已经被审核，不允许修改！"; objJsonResult.data = 1; return objJsonResult; } bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo); } //提示 if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "单据号:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败!原因:" + ClsPub.sExeReturnInfo; 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 [生产入厂检验单] /// /// 返回列表 /// 生产入厂检验单 ///参数：string sql。 ///返回值：object。 /// [Route("QC_LastPieceCheckBill/GetLastPieceCheckBill")] [HttpGet] public object GetLastPieceCheckBill(string sWhere, string user) { try { List a = new List(); //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限！"; objJsonResult.data = null; return objJsonResult; } ds = QC_LastPieceCheckBill(sWhere); foreach (DataColumn col in ds.Tables[0].Columns)//遍历ds中第一个表（Tables[0]）的所有列（Columns）每次循环中，col变量会持有当前列的引用 { Type dataType = col.DataType; //获取当前数据类型传入 自定义变量datadataType string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; //字符串拼接 // 将列名和数据类型信息拼接成一个JSON格式的字符串 a.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = a; return objJsonResult; } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } public static DataSet QC_LastPieceCheckBill(string sWhere) { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_QC_Edit_LastPieceCheckBillList order by hmainid desc", "h_v_QC_Edit_LastPieceCheckBillList"); } else { string sql1 = "select * from h_v_QC_Edit_LastPieceCheckBillList where 1 = 1 "; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_QC_Edit_LastPieceCheckBillList"); } } #endregion #region [已废弃] #region[编辑时获取表头数据] [Route("QC_LastPieceCheckBill/QC_LastPieceCheckBillListCheckDetail")] [HttpGet] public ApiResult QC_LastPieceCheckBillListCheckDetail(string HID) { if (string.IsNullOrEmpty(HID)) return new ApiResult { code = -1, msg = "ID不能为空" }; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); var dataSet = oCN.RunProcReturn("select top 1 * from h_v_QC_LastPieceCheckBillListDetail where hmainid= " + HID + " ", "h_v_QC_LastPieceCheckBillListDetail"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult { code = -1, msg = "不存在结算单号" }; return new ApiResult { code = 1, msg = "查询成功", data = dataSet }; } #endregion #region[编辑时获取表体数据] [Route("QC_LastPieceCheckBill/QC_LastPieceCheckBillListProjectDetai")] [HttpGet] public object QC_LastPieceCheckBillListProjectDetai(string sqlWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = "SELECT 日期,单据号,备注,产品内码, 产品名称" + ", 产品型号, 检验员代码, 检验员名称, 制单人, 制单日期" + ", 审核人, 审核日期, 修改人, 修改日期, 关闭人, 关闭日期 FROM h_v_QC_LastPieceCheckBillListDetail where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_QC_LastPieceCheckBillListDetail"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "获取信息成功！"; objJsonResult.data = ds.Tables[0]; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; } return objJsonResult; } #endregion /// /// 新增单据-保存按钮 /// 产品入库检验单列表 ///参数：string sql。 ///返回值：object。 /// [Route("QC_LastPieceCheckBill/AddBill")] [HttpPost] public object AddBill([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); oCN.BeginTran(); //保存主表 objJsonResult = AddBillMain(msg1); if (objJsonResult.code == "0") { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "新增单据成功！"; return objJsonResult; } public json AddBillMain_Obsolete(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string user = sArray[2].ToString(); try { //判断权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限"; objJsonResult.data = null; return objJsonResult; } msg2 = "[" + msg2.ToString() + "]"; List mainList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); string BillType = "7507"; long HInterID = mainList[0].HInterID;//递入type得到的单据ID string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 DateTime HDate = mainList[0].HDate;//日期 int HYear = 2021; double HPeriod = 1; long HBillStatus = mainList[0].HBillStatus; long HCheckItemNowID = mainList[0].HCheckItemNowID; long HCkeckItemNextID = mainList[0].HCheckItemNextID; long HCheckFlowID = mainList[0].HCheckFlowID; string HRemark = mainList[0].HRemark;//备注 string HBacker = mainList[0].HBacker; DateTime HBackDate = mainList[0].HBackDate; string HBackRemark = mainList[0].HBackRemark; string HChecker = mainList[0].HChecker; DateTime HCheckDate = mainList[0].HCheckDate; string HMaker = mainList[0].HMaker; DateTime HMakeDate = mainList[0].HMakeDate; string HUpDater = mainList[0].HUpDater; DateTime HUpDateDate = mainList[0].HUpDateDate; string HCloseMan = mainList[0].HCloseMan; DateTime HCloseDate = mainList[0].HCloseDate; string HCloseType = mainList[0].HCloseType; string HDeleteMan = mainList[0].HDeleteMan; DateTime HDeleteDate = mainList[0].HDeleteDate; string HMainSourceBillType = mainList[0].HMainSourceBillType; long HMainSourceInterID = mainList[0].HMainSourceInterID; long HMainSourceEntryID = mainList[0].HMainSourceEntryID; string HMainSourceBillNo = mainList[0].HMainSourceBillNo; double HPrintQty = mainList[0].HPrintQty; long HICMOInterID = mainList[0].HICMOInterID; string HICMOBillNo = mainList[0].HICMOBillNo; Double HInStockQty = mainList[0].HInStockQty; Double HCheckQty = mainList[0].HCheckQty; Double HRightQty = mainList[0].HRightQTy; Double HBadQty = mainList[0].HBadQty; long HMaterID = mainList[0].HMaterID; long HFirstCheckEmp = mainList[0].HFirstCheckEmp; string HCheckerResult = mainList[0].HCheckerResult; long HCheckDept = mainList[0].HCheckDept; long HCheckDept2 = mainList[0].HCheckDept2; string HCheckDeptResult = mainList[0].HCheckDeptResult; string HCheckDeptResult2 = mainList[0].HCheckDeptResult2; string HBarCode = mainList[0].HBarCode; string HStoveBatchNo = mainList[0].HStoveBatchNo; long HCusID = mainList[0].HCusID; string HSortBillNo = mainList[0].HSortBillNo; string HContrctBatchNo = mainList[0].HContrctBatchNo; long HProdAreaID = mainList[0].HProdAreaID; long HProdTypeID = mainList[0].HProdTypeID; long HRoutingInterID = mainList[0].HRoutingInterID; long HDrawingDireID = mainList[0].HDrawingDireID; long HPackTypeID = mainList[0].HPackTypeID; //主表 oCN.RunProc("Insert Into QC_LastPieceCheckBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + ",HYear,HPeriod,HRemark" + ",HICMOInterID,HICMOBillNo,HInStockQTy,HCheckQty,HRightQty" + ",HBadQty,HMaterID,HFirstCheckEmp,HCheckerResult,HCheckDept" + ",HCheckDeptResult,HCheckDept2,HCheckDeptResult2,HBarCode,HStoveBatchNo" + ",HCusID,HSortBillNo,HContrctBatchNo,HProdAreaID,HProdTypeID" + ",HRoutingInterID,HDrawingDireID,HPackTypeID" + ") " + " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HBillStatus + "','" + HDate + "','" + HMaker + "','" + HDate + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "'" + "," + 0 + ",'" + HICMOBillNo + "'," + HInStockQty + "," + HCheckQty + "," + HRightQty + "," + HBadQty + "," + HMaterID + "," + HFirstCheckEmp + ",'" + HCheckerResult + "'," + HCheckDept + ",'" + HCheckDeptResult + "'," + HCheckDept2 + ",'" + HCheckDeptResult2 + "','" + HBarCode + "','" + HStoveBatchNo + "'" + "," + HCusID + ",'" + HSortBillNo + "','" + HContrctBatchNo + "'," + HProdAreaID + "," + HProdTypeID + "," + HRoutingInterID + "," + HDrawingDireID + "," + HPackTypeID + ") "); //保存子表 objJsonResult = AddBillSub(msg3, HInterID); if (objJsonResult.code == "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } public json AddBillSub(string msg3, long HInterID) { List subList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg3); for (int i = 0; i < subList.ToArray().Length; i++) { long HSourceInterID = 0;//源单主内码 long HSourceEntryID = 0;//源单子内码 string HSourceBillNo = "";//源单单号 string HSourceBillType = "";//源单类型 double HRelationQty = 0;//关联数量 double HRelationMoney = 0;//关联金额 oCN.RunProc("Insert into QC_LastPieceCheckBillSub " + "(HInterID,HEntryID,HCloseMan,HRemark,HSourceInterID,HSourceEntryID" + ",HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HQCCheckClassID,HQCCheckItemID,HQCStd,HResult,HQCRelValue" + ",HProcCheckEmp" + ") values(" + HInterID + "," + i + ",'" + subList[i].HCloseMan + "','" + subList[i].HRemark + "'," + HSourceInterID + "," + HSourceEntryID + "" + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty + "," + HRelationMoney + "," + subList[i].HQCCheckClassID + "," + subList[i].HQCCheckItemID + ",'" + subList[i].HQCStd + "','" + subList[i].HResult + "','" + subList[i].HQCRelvalue + "'" + "," + subList[i].HProCheckEmp + "" + ") "); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } /// ///删除功能 ///产品入库检验单 /// /// [Route("QC_LastPieceCheckBill/DeltetLastPieceCheckBill")] [HttpGet] public object DeltetLastPieceCheckBill(string HInterID,string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBill_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); oCN.RunProc("Delete From QC_LastPieceCheckBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From QC_LastPieceCheckBillSub where HInterID = " + HInterID); oCN.RunProc("Delete From QC_LastPieceCheckBillSub_ValueGrid where HInterID = " + HInterID); oCN.RunProc("Delete From QC_LastPieceCheckBillSub_Result where HInterID = " + HInterID); 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.ToString(); objJsonResult.data = null; return objJsonResult; } } /// /// 返回产品入库检验单列表 ///参数：string sql。 ///返回值：object。 /// [Route("QC_LastPieceCheckBill/GetLastPieceCheckBillList")] [HttpGet] public object GetLastPieceCheckBillList(string sWhere,string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_LastPieceCheckBillList", 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_QC_LastPieceCheckBillListDetail order by hmainid desc ", "h_v_QC_LastPieceCheckBillListDetail"); } else { string sql1 = "select * from h_v_QC_LastPieceCheckBillListDetail where 1 = 1 "; string sql = sql1 + sWhere+ " order by hmainid desc "; ds = oCN.RunProcReturn(sql, "h_v_QC_LastPieceCheckBillListDetail"); } //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) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } // #endregion } }