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 Gy_RoutingBillController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
|
|
/// <summary>
|
/// 返回工艺路线列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("Gy_RoutingBill/list")]
|
[HttpGet]
|
public object list(string sWhere)
|
{
|
try
|
{
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList " + sWhere, "h_v_MES_StationEntrustOutBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_MES_StationEntrustOutBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustOutBillList");
|
}
|
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;
|
}
|
}
|
|
/// <summary>
|
/// 新增单据-保存按钮
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("Gy_RoutingBill/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 = ds.Tables[0];
|
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();
|
|
int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id
|
int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改
|
try
|
{
|
msg2 = "[" + msg2.ToString() + "]";
|
List<Gy_RoutingBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBill>>(msg2);
|
string BillType = "3301";
|
long HInterID = mainList[0].HInterID;//递入type得到的单据ID
|
string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
|
DateTime HDate = mainList[0].HDate;//日期
|
int HYear = DateTime.Now.Year;
|
double HPeriod = 1;
|
string HRemark = mainList[0].HRemark;//备注
|
string HMaker = mainList[0].HMaker;//制单人
|
long HMaterID = mainList[0].HMaterID;//产品ID
|
string HName = mainList[0].HName;//工艺路线名称
|
long HMaterTypeID = 0;
|
long HRoutingGroupID = mainList[0].HRoutingGroupID;//工艺路线大类ID
|
long HUnitID = mainList[0].HUnitID;//计量单位
|
string HMaterNumber = mainList[0].HMaterNumber;//产品代码
|
long HUnitNumber = mainList[0].HUnitID;//计量单位ID
|
bool HStandard = mainList[0].HStandard;//是否默认工艺
|
long HMainGroupID = mainList[0].HGroupID;//生产班组ID
|
long HMainProcID = mainList[0].HMainProcID;//工序ID
|
long HMainCenterID = mainList[0].HMainCenterID;//工作中心ID
|
string HMainTimeUnit = mainList[0].HMainTimeUnit;//运行时间单位
|
double HMainUnitTime = mainList[0].HMainUnitTime;//运行时间
|
double HMainWorkQty = mainList[0].HMainWorkQty;//加工数量
|
double HMainPrice = mainList[0].HMainPrice;//工价
|
double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数
|
double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量
|
double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量
|
int HPRDORGID = mainList[0].HPRDORGID; //组织
|
|
string HPicNumVer = mainList[0].HPicNumVer;//图号版本
|
string HPicNumAssemble = mainList[0].HPicNumAssemble;//总装图号
|
string HMaterTexture = mainList[0].HMaterTexture;//材质
|
string HProductNum = mainList[0].HProductNum;//成品编号
|
string HVerNum = mainList[0].HVerNum;//版本
|
|
if (OperationType == 1)//新增
|
{
|
//主表
|
oCN.RunProc("Insert Into Gy_RoutingBillMain " +
|
"(HBillType,HInterID,HBillNo,HDate" +
|
",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" +
|
",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" +
|
",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" +
|
",HMainPrice,HStdSourceQty,HAddSourceRate,HPRDORGID,HDelSourceRate" +
|
",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum) " + " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
|
"," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID +
|
"," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) +
|
"," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty +
|
"," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate +
|
",'"+ HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "') ");
|
}
|
else if (OperationType == 3)
|
{ //修改
|
oCN.RunProc("update Gy_RoutingBillMain set " +
|
"HDate='" + HDate +
|
"',HYear='" + HYear + "',HPeriod='" + HPeriod + "',HRemark='" + HRemark + "',HMaker='" + HMaker +
|
"',Hmakedate=getdate(),HMaterID='" + HMaterID + "',HName='" + HName + "',HMaterTypeID='" + HMaterTypeID +
|
"',HRoutingGroupID='" + HRoutingGroupID + "',HUnitID='" + HUnitID + "',HMaterNumber='" + HMaterNumber + "',HUnitNumber='" + HUnitNumber +
|
"',HStandard='" + Convert.ToString(HStandard ? 1 : 0) + "',HMainGroupID='" + HMainGroupID + "',HMainProcID='" + HMainProcID + "',HMainCenterID='" + HMainCenterID +
|
"',HMainTimeUnit='" + HMainTimeUnit + "',HMainUnitTime='" + HMainUnitTime + "',HMainWorkQty='" + HMainWorkQty + "',HMainPrice='" + HMainPrice +
|
"',HStdSourceQty='" + HStdSourceQty + "',HAddSourceRate='" + HAddSourceRate + "',HDelSourceRate='" + HDelSourceRate +
|
"',HPicNumVer='" + HPicNumVer + "',HPicNumAssemble='" + HPicNumAssemble + "',HMaterTexture='" + HMaterTexture + "'" +
|
",HProductNum='" + HProductNum + "',HVerNum='" + HVerNum + "' where HInterID='" + HInterID + "'");
|
|
//删除子表
|
oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "' and HEntryID='" + hentryid + "'");
|
}
|
//保存子表
|
objJsonResult = AddBillSub(msg3, HInterID, hentryid);
|
if (objJsonResult.code == "0")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = objJsonResult.Message;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID); //设置默认工艺路线
|
//判断是否重复工序号
|
ds = oCN.RunProcReturn("exec h_p_Gy_RoutingCtrl " + HInterID, "h_p_Gy_RoutingCtrl");
|
|
if (OperationType == 1)
|
{
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "判断重复工序号失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
if (ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "2")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = ClsPub.isStrNull(ds.Tables[0].Rows[0][1]);
|
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, int hentryid)
|
{
|
List<Gy_RoutingBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_RoutingBillSub>>(msg3);
|
int i = 0;
|
foreach (Gy_RoutingBillSub oSub in DetailColl)
|
{
|
i++;
|
if (oSub.HWorkQty <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "第" + i + "行，加工数量不能为0或者小于0";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
oCN.RunProc("Insert into Gy_RoutingBillSub " +
|
"(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" +
|
",HWorkQty,HCenterID,HTimeUnit,HUnitTime" +
|
",HReadyTime,HQueueTime,HMoveTime" +
|
",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" +
|
",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" +
|
",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" +
|
",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" +
|
",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" +
|
",HTechnologyParameter,HPicNum,HProcCheckNote" +
|
",HOverRate,HProcWorkNum" +
|
") values("
|
+ HInterID + "," + (hentryid==-1?i: hentryid) + "," + oSub.HProcID.ToString() + ",'" + (hentryid == -1 ? i : hentryid) + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
|
"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
|
"," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() +
|
",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) +
|
"," + oSub.HFixPrice.ToString() + "," + oSub.HProcPrice.ToString() + "," + oSub.HBadPrice.ToString() + "," + oSub.HWasterPrice.ToString() + "," + Convert.ToString(oSub.HStdFlag ? 1 : 0) + "," + oSub.HBeginDayQty.ToString() + "," + oSub.HBeginFixQty.ToString() +
|
"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + Convert.ToString(oSub.HAutoTrunFlag ? 1 : 0) +
|
"," + oSub.HFixWorkDays.ToString() + "," + oSub.HTrunWorkDays.ToString() + "," + oSub.HReadyTimes.ToString() + "," + oSub.HICMOReadyTimes.ToString() + "," + oSub.HSubStdEmpQty.ToString() + "," + oSub.HSubCanUseSourceQty.ToString() +
|
"," + oSub.HProcID_S.ToString() + "," + oSub.HCenterID_S.ToString() + "," + oSub.HWorkQty_S.ToString() + ", " + oSub.HSubStdEmpQty_S.ToString() + ",'" + oSub.HMouldNo + "'," + oSub.HChangeMould.ToString() +
|
",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() +
|
",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() +
|
"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'" +
|
") ");
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = null;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//
|
}
|
}
|
