using Newtonsoft.Json.Linq;
|
using Pub_Class;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Web.Http;
|
using WebAPI.Models;
|
namespace WebAPI.Controllers
|
{
|
public class LMESController : ApiController
|
{
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
|
private json objJsonResult = new json();
|
/// <summary>
|
/// 返回进站扫描列表|工序进站接收单列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_StationInBillList_Json")]
|
[HttpGet]
|
public object MES_StationInBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_MES_StationInBillList", "h_v_MES_StationInBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_MES_StationInBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_MES_StationInBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工序流转卡维护列表主表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_Sc_ProcessExchangeBillQuery_Json")]
|
[HttpGet]
|
public object MES_Sc_ProcessExchangeBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery", "h_v_Sc_ProcessExchangeBillQuery");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBillQuery");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工序流转卡维护列表从表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_Sc_ProcessExchangeBillQuerySub_Json")]
|
[HttpGet]
|
public object MES_Sc_ProcessExchangeBillSub_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
string sql = "select * from h_v_Sc_ProcessExchangeBillQuerySub where hmainid = ";
|
string sql1 = sql + sWhere;
|
ds = oCN.RunProcReturn(sql1, "h_v_Sc_ProcessExchangeBillQuerySub");
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工序出站汇报单列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_StationOutBillList_Json")]
|
[HttpGet]
|
public object MES_StationOutBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList ", "h_v_MES_StationInBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_MES_StationOutBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工序委外发出单列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_StationEntrustInBillList_Json")]
|
[HttpGet]
|
public object MES_StationEntrustInBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustInBillList ", "h_v_MES_StationEntrustInBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_MES_StationEntrustInBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_MES_StationEntrustInBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工艺路线列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_Gy_RoutingBillList_Json")]
|
[HttpGet]
|
public object MES_Gy_RoutingBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList ", "h_v_Gy_RoutingBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回生产任务单列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_IF_ICMOBillList_Json")]
|
[HttpGet]
|
public object MES_IF_ICMOBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList ", "h_v_IF_ICMOBillList");
|
}
|
else
|
{
|
string sql1 = "select * from h_v_IF_ICMOBillList where 1 = 1 ";
|
string sql = sql1 + sWhere;
|
ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回工序委外接收单列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_StationEntrustOutBillList_Json")]
|
[HttpGet]
|
public object MES_StationEntrustOutBillList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sWhere == null || sWhere.Equals(""))
|
{
|
ds = oCN.RunProcReturn("select * from h_v_MES_StationEntrustOutBillList ", "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");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
///<summary>
|
///封装状态码及返回信息的公用方法。
|
///参数：DataSet。
|
///返回值：json。
|
///</summary>
|
public object GetObjectJson(DataSet ds)
|
{
|
try
|
{
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
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;
|
}
|
}
|
|
///<summary>
|
///自定义错误信息方法。
|
///参数：string。
|
///返回值：object。
|
///</summary>
|
public object CustomError(string msg)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = msg;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
///<summary>
|
///统一正确信息方法。
|
///参数：string。
|
///返回值：object。
|
///</summary>
|
public object CustomCorrect(DataSet ds)
|
{
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 返回选择生产班组列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_GetProductionTeamList_Json")]
|
[HttpGet]
|
public object MES_GetProductionTeamList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ds = oCN.RunProcReturn("Select HItemID,HNumber 班组代码,HName 班组 from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 返回选择生产资源列表
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/MES_GetProductionResourcesList_Json")]
|
[HttpGet]
|
public object MES_GetProductionResourcesList_Json(string sWhere)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ds = oCN.RunProcReturn("Select HItemID,HNumber 生产资源代码,HName 生产资源 from Gy_Source where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Source");
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return GetObjectJson(ds);
|
}
|
|
/// <summary>
|
/// 扫条码方法(进站接收单、出站汇报单)
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/TxtHBarCode_KeyDown")]
|
[HttpGet]
|
public object TxtHBarCode_KeyDown(string sBillBarCode)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sBillBarCode == null || sBillBarCode.Equals(""))
|
{
|
return CustomError("未输入条形码！");
|
}
|
else
|
{
|
//拆分条形码
|
string[] NewBarCode;
|
if (sBillBarCode.CompareTo("#") > 0)
|
{
|
NewBarCode = sBillBarCode.Split(Convert.ToChar("#"));
|
sBillBarCode = NewBarCode[0];
|
}
|
string sBillNo = sBillBarCode;
|
ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
|
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return CustomCorrect(ds);
|
}
|
|
/// <summary>
|
/// 流水号回车方法(进站接收单、出站汇报单)
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/TxtHProcNo_KeyDown")]
|
[HttpGet]
|
public object TxtHProcNo_KeyDown(string sProcNo, string sBillNo)
|
{
|
DataSet ds;
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
if (sProcNo == null || sProcNo.Equals("") || sBillNo == null || sBillNo.Equals(""))
|
{
|
return CustomError("流水号或流转卡号为空！");
|
}
|
else
|
{
|
ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 单据号= '" + sBillNo + "' and 下道流转工序<>'转' and 委外标记=0 and 流转标记=1 and 工序号='" + sProcNo + "'", "h_v_Sc_ProcessExchangeBillList");
|
}
|
|
}
|
catch (Exception e)
|
{
|
ds = null;
|
}
|
return CustomCorrect(ds);
|
}
|
|
|
/// <summary>
|
/// 保存提交方法
|
///参数：string sql。
|
///返回值：object。
|
/// </summary>
|
[Route("LEMS/Sub_SaveBill_Json")]
|
[HttpPost]
|
public object Sub_SaveBill_Json([FromBody]JObject oMain)
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
try
|
{
|
List<Model.ClsSc_StationInBillSub> lsmain = new List<Model.ClsSc_StationInBillSub>();
|
//反序列化
|
msg1 = "[" + msg1.ToString() + "]";
|
List<Model.ClsSc_StationInBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_StationInBillSub>>(msg1);
|
|
DAL.ClsSc_StationInBill BillNew = new DAL.ClsSc_StationInBill();
|
DAL.ClsSc_StationInBill BillOld = new DAL.ClsSc_StationInBill();
|
bool bResult;
|
//赋值ID
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
|
BillNew.omodel.HInterID = BillOld.omodel.HInterID;
|
BillNew.omodel.HYear = 2011;
|
BillNew.omodel.HPeriod = 1;
|
//BillNew.omodel.HBillNo = DBUtility.ClsPub.isStrNull(list[0].HBillNo);
|
//BillNew.omodel.HICMOBillNo = this.txtHICMOBillNo.Text.Trim();
|
//BillNew.omodel.HICMOInterID = DBUtility.ClsPub.isLong(this.txtHICMOBillNo.Tag);
|
//BillNew.omodel.HProcExchInterID = lngBillKey;
|
//BillNew.omodel.HProcExchEntryID = lngBillSubKey;
|
//BillNew.omodel.HProcExchBillNo = this.txtHProcExchBillNo.Text.Trim();
|
//BillNew.omodel.HProcID = DBUtility.ClsPub.isLong(this.txtHProcID.Tag);
|
//BillNew.omodel.HMaterID = DBUtility.ClsPub.isLong(this.txtHMaterID.Tag);
|
//BillNew.omodel.HStationInTime = DBUtility.ClsPub.isDate(this.txtHStationInTime.Text);
|
//BillNew.omodel.HEmpID = DBUtility.ClsPub.isLong(this.txtHEmpID.Tag);
|
//BillNew.omodel.HSourceID = DBUtility.ClsPub.isLong(this.txtHSourceID.Tag);
|
//BillNew.omodel.HGroupID = DBUtility.ClsPub.isLong(this.txtHGroupID.Tag);
|
//BillNew.omodel.HICMOQty = DBUtility.ClsPub.isDoule(this.txtHICMOQty.Text);
|
//BillNew.omodel.HPlanQty = DBUtility.ClsPub.isDoule(this.txtHPlanQty.Text);
|
//BillNew.omodel.HQty = DBUtility.ClsPub.isDoule(this.txtHQty.Text);
|
//BillNew.omodel.HPieceQty = DBUtility.ClsPub.isDoule(this.txtHPieceQty.Text);
|
//BillNew.omodel.HSourceName = DBUtility.ClsPub.isStrNull(this.txtHSourceName.Text);
|
//BillNew.omodel.HCenterID = DBUtility.ClsPub.isLong(this.txtHCenterID.Tag);
|
|
//BillNew.omodel.HProcNo = DBUtility.ClsPub.isLong(this.txtHProcNo.Text);
|
//BillNew.omodel.HOrderProcNO = DBUtility.ClsPub.isStrNull(this.txtHOrderProcNO.Text);
|
|
//保存完毕后处理
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
|
}
|
else
|
{
|
bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
|
}
|
if (bResult == true)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "生成汇报单成功！单据号为：";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
//以下是工序出站汇报单单据方法-----------
|
|
|
//
|
}
|
}
|
