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 QC_POStockInCheckBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); public DataSet ds = new DataSet(); public WebServer webserver = new WebServer(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //DataSet ds; /// /// 返回列表 /// 来料入库检验单 ///参数:string sql。 ///返回值:object。 /// [Route("QC_POStockInCheckBill/GetPOStockInCheckBill")] [HttpGet] public object GetPOStockInCheckBill(string sWhere,string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_POStockInCheckBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查看权限!"; objJsonResult.data = null; return objJsonResult; } ds = QC_POStockInCheckBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功!"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录!" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } public static DataSet QC_POStockInCheckBill(string sWhere) { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_QC_Edit_POStockInCheckBillList order by hmainid desc", "h_v_QC_Edit_POStockInCheckBillList"); } else { string sql1 = "select * from h_v_QC_Edit_POStockInCheckBillList where 1 = 1 "; string sql = sql1 + sWhere + "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_QC_Edit_POStockInCheckBillList"); } } #region[编辑时获取表头数据] [Route("QC_POStockInCheckBill/QC_POStockInCheckBillListCheckDetail")] [HttpGet] public ApiResult QC_POStockInCheckBillListCheckDetail(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_Edit_POStockInCheckBillList where hmainid= " + HID + " ", "h_v_QC_Edit_POStockInCheckBillList"); 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_POStockInCheckBill/QC_POStockInCheckBillListProjectDetai")] [HttpGet] public object QC_POStockInCheckBillListProjectDetai(string sqlWhere) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql1 = "SELECT 日期,单据号,表头备注, 供应商名称,供应商代码,产品内码" + ", 产品名称, 产品型号, 检验员代码, 检验员名称, 制单人, 制单日期, 审核人" + ", 审核日期, 修改人, 修改日期, 关闭人, 关闭日期 FROM h_v_QC_Edit_POStockInCheckBillList where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_QC_Edit_POStockInCheckBillList"); 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_POStockInCheckBill/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 = "新增单据成功!"; objJsonResult.data = null; return objJsonResult; } public json AddBillMain(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_POStockInCheckBill_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); int HYear = 2021; double HPeriod = 1; string HBillType = "7503"; string HBillSubType = "7503"; long HInterID = mainList[0].HInterID;//递入type得到的单据ID DateTime HDate = mainList[0].HDate;//日期 string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 long HBillStatus = mainList[0].HBillStatus; 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; long HSupID = mainList[0].HSupID; long HMaterID = mainList[0].HMaterID; decimal HInStockQty = mainList[0].HInStockQty; decimal HCheckQty = mainList[0].HCheckQty; decimal HRightQty = mainList[0].HRightQty; decimal HBadQty = mainList[0].HBadQty; long HFirstCheckEmp = mainList[0].HFirstCheckEmp; string HCheckerResult = mainList[0].HCheckerResult; string HSteelStoveNo = mainList[0].HSteelStoveNo; string HSteelCompReport = mainList[0].HSteelCompReport; string HAspect = mainList[0].HAspect; string HSize = mainList[0].HSize; //主表 oCN.RunProc("Insert Into QC_POStockInCheckBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + ",HYear,HPeriod,HRemark" + ",HSupID,HMaterID,HInStockQty,HCheckQty,HRightQty" + ",HBadQty,HFirstCheckEmp,HCheckerResult" + ",HSteelStoveNo,HSteelCompReport,HAspect,HSize" + ") " + " values('" + HBillType + "','" + HBillSubType + "'," + HInterID.ToString() + ",'" + HBillNo + "'," + HBillStatus.ToString() + ",'" + HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + "," + HYear.ToString() + "," + HPeriod.ToString() + ",'" + HRemark + "'" + "," + HSupID.ToString() + "," + HMaterID.ToString() + "," + HInStockQty.ToString() + "," + HCheckQty.ToString() + "," + HRightQty.ToString() + "," + HBadQty.ToString() + "," + HFirstCheckEmp.ToString() + ",'" + HCheckerResult + "'" + ",'" + HSteelStoveNo + "','" + HSteelCompReport + "','" + HAspect + "','" + HSize + "'" + ") "); //保存子表 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++) { string HBillNo_bak = subList[0].HBillNo_bak; long HEntryID = subList[0].HEntryID;//工段ID string HCloseMan = subList[0].HCloseMan; long HCloseType = subList[0].HCloseType; string HRemark = subList[0].HRemark; long HSourceInterID = subList[0].HSourceInterID; long HSourceEntryID = subList[0].HSourceEntryID; string HSourceBillNo = subList[0].HSourceBillNo; string HSourceBillType = subList[0].HSourceBillType; decimal HRelationQty = subList[0].HRelationQty; decimal HRelationMoney = subList[0].HRelationMoney; long HQCCheckClassID = subList[0].HQCCheckClassID; long HQCCheckItemID = subList[0].HQCCheckItemID; string HQCStd = subList[0].HQCStd; string HResult = subList[0].HResult; string HQCRelValue = subList[0].HQCRelValue; long HProcCheckEmp = subList[0].HProcCheckEmp; DateTime HProcCheckTime = subList[0].HProcCheckTime; string sql = "Insert into QC_POStockInCheckBillSub " + " (HInterID,HBillNo_bak,HEntryID,HCloseMan" + ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HQCCheckClassID,HQCCheckItemID,HQCStd,HResult" + ",HQCRelValue,HProcCheckEmp,HProcCheckTime" + ") values(" + HInterID.ToString() + ",'" + HBillNo_bak + "'," + HEntryID.ToString() + ",'" + HCloseMan + "'" + ",getdate()," + HCloseType + ",'" + HRemark + "'," + HSourceInterID.ToString() + "," +HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty.ToString() + "," + HRelationMoney.ToString() + "," + HQCCheckClassID.ToString() + "," + HQCCheckItemID.ToString() + ",'" + HQCStd + "','" + HResult + "'" + ",'" + HQCRelValue + "'," + HProcCheckEmp.ToString() + ",'" + HProcCheckTime + "'" + ") "; oCN.RunProc(sql); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } /// ///删除功能 /// /// [Route("QC_POStockInCheckBill/DeltetPOStockInCheckBill")] [HttpGet] public object DeltetPOStockInCheckBill(string HInterID,string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_POStockInCheckBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); oCN.RunProc("Delete From QC_POStockInCheckBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From QC_POStockInCheckBillSub 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; } } // } }