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;
///
/// 新增单据-保存按钮
///参数: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(string msg1)
{
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString();
string msg3 = sArray[1].ToString();
try
{
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;
}
///
/// 返回产品入库检验单列表
///参数:string sql。
///返回值:object。
///
[Route("QC_LastPieceCheckBill/GetLastPieceCheckBillList")]
[HttpGet]
public object GetLastPieceCheckBillList(string sWhere)
{
try
{
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn("select * from [h_v_QC_LastPieceCheckBillList] " + sWhere, "[h_v_QC_LastPieceCheckBillList]");
}
else
{
string sql1 = "select * from [h_v_QC_LastPieceCheckBillList] where 1 = 1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "[h_v_QC_LastPieceCheckBillList]");
}
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;
}
}
//
}
}