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.Net;
|
using System.Web.Http;
|
using System.Windows.Forms;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers
|
{
|
#region 华远请求基础资料
|
|
#region 炬森VRS内层提取上传二维码位置接口 相关模型类
|
public class VRSInner_savePNLBarCodePosition_RequestParams
|
{
|
public string HBarCode_PNL; //PNL条码编号
|
public string HPosition_x; //二维码x坐标
|
public string HPosition_y; //二维码y坐标
|
}
|
|
public class VRSInner_savePNLBarCodePosition_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region 炬森VRS内层获取PNL二维码位置信息接口 相关模型类
|
public class VRSInner_getPNLBarCodePosition_RequestParams
|
{
|
public string HBarCode_PNL; //PNL条码编号
|
}
|
|
public class VRSInner_getPNLBarCodePosition_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<VRSInner_getPNLBarCodePosition_RequestResult_data> data;
|
}
|
public class VRSInner_getPNLBarCodePosition_RequestResult_data
|
{
|
public string HBarCode_PNL; //PNL条码号
|
public double HPosition_x; //二维码x坐标
|
public double HPosition_y; //二维码y坐标
|
}
|
|
#endregion
|
|
#region 炬森VRS内层检验结果上传接口 相关模型类
|
public class VRSInner_saveCheckNote_RequestParams
|
{
|
public string HMaker; //制单人
|
public List<VRSInner_saveCheckNote_RequestParams_data> param;
|
}
|
|
public class VRSInner_saveCheckNote_RequestParams_data
|
{
|
public string HBarCode; //PNL条码编号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS所在行的索引
|
public int HPosition_y; //PCS所在列的索引
|
public int HPageIndex; //正反面(0:正面,1:反面)
|
public string HBadReason; //不良原因
|
}
|
|
public class VRSInner_saveCheckNote_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region 炬森VRS外层提取上传二维码位置接口 相关模型类
|
public class VRSOuter_saveSetBarCodePosition_RequestParams
|
{
|
public string HBarCode_Set; //Set条码编号
|
public string HPosition_x; //二维码x坐标
|
public string HPosition_y; //二维码y坐标
|
}
|
|
public class VRSOuter_saveSetBarCodePosition_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region 炬森VRS外层获取set二维码位置信息接口 相关模型类
|
public class VRSOuter_getSetBarCodePosition_RequestParams
|
{
|
public string HBarCode_Set; //set条码编号
|
}
|
|
public class VRSOuter_getSetBarCodePosition_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<VRSOuter_getSetBarCodePosition_RequestResult_data> data;
|
}
|
public class VRSOuter_getSetBarCodePosition_RequestResult_data
|
{
|
public string HBarCode_Set; //Set条码号
|
public double HPosition_x; //二维码x坐标
|
public double HPosition_y; //二维码y坐标
|
}
|
|
#endregion
|
|
#region 炬森VRS外层获取datamapping接口 相关模型类
|
public class VRSOuter_getDataMapping_RequestParams
|
{
|
public string HBarCode; //PNL条码编号
|
}
|
|
public class VRSOuter_getDataMapping_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<VRSOuter_getDataMapping_RequestResult_data> data;
|
}
|
public class VRSOuter_getDataMapping_RequestResult_data
|
{
|
public string HBarCode; //PNL条码号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS的行索引
|
public int HPosition_y; //PCS的列索引
|
}
|
|
#endregion
|
|
#region 炬森VRS外层检验结果上传接口 相关模型类
|
public class VRSOuter_saveCheckNote_RequestParams
|
{
|
public string HMaker; //制单人
|
public List<VRSOuter_saveCheckNote_RequestParams_data> param;
|
}
|
|
public class VRSOuter_saveCheckNote_RequestParams_data
|
{
|
public string HBarCode; //PNL条码编号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS所在行的索引
|
public int HPosition_y; //PCS所在列的索引
|
public int HPageIndex; //正反面(0:正面,1:反面)
|
public string HBadReason; //不良原因
|
}
|
|
public class VRSOuter_saveCheckNote_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region AVI获取datamapping接口 相关模型类
|
public class AVI_getDataMapping_RequestParams
|
{
|
public string HBarCode; //PNL条码编号
|
}
|
|
public class AVI_getDataMapping_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<AVI_getDataMapping_RequestResult_data> data;
|
}
|
public class AVI_getDataMapping_RequestResult_data
|
{
|
public string HBarCode; //PNL条码号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS的行索引
|
public int HPosition_y; //PCS的列索引
|
}
|
|
#endregion
|
|
#region AVI检验结果上传接口 相关模型类
|
public class AVI_saveCheckNote_RequestParams
|
{
|
public string HMaker; //制单人
|
public List<AVI_saveCheckNote_RequestParams_data> param;
|
}
|
|
public class AVI_saveCheckNote_RequestParams_data
|
{
|
public string HBarCode; //PNL条码编号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS所在行的索引
|
public int HPosition_y; //PCS所在列的索引
|
public int HPageIndex; //正反面(0:正面,1:反面)
|
public string HBadReason; //不良原因
|
}
|
|
public class AVI_saveCheckNote_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region 电测获取datamapping接口 相关模型类
|
public class DC_getDataMapping_RequestParams
|
{
|
public string HBarCode; //set条码编号
|
}
|
|
public class DC_getDataMapping_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<DC_getDataMapping_RequestResult_data> data;
|
}
|
public class DC_getDataMapping_RequestResult_data
|
{
|
public string HBarCode; //PNL条码号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS的行索引
|
public int HPosition_y; //PCS的列索引
|
}
|
|
#endregion
|
|
#region 电测检验结果上传接口 相关模型类
|
public class DC_saveCheckNote_RequestParams
|
{
|
public string HMaker; //制单人
|
public List<DC_saveCheckNote_RequestParams_data> param;
|
}
|
|
public class DC_saveCheckNote_RequestParams_data
|
{
|
public string HBarCode; //set条码编号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS所在行的索引
|
public int HPosition_y; //PCS所在列的索引
|
public int HPageIndex; //正反面(0:正面,1:反面)
|
public string HBadReason; //不良原因
|
}
|
|
public class DC_saveCheckNote_RequestResult
|
{
|
public string code;
|
public string msg;
|
}
|
#endregion
|
|
#region 激光割获取datamapping接口 相关模型类
|
public class JGG_getDataMapping_RequestParams
|
{
|
public string HBarCode; //set条码编号
|
}
|
|
public class JGG_getDataMapping_RequestResult
|
{
|
public string code;
|
public string msg;
|
public List<JGG_getDataMapping_RequestResult_data> data;
|
}
|
public class JGG_getDataMapping_RequestResult_data
|
{
|
public string HBarCode; //PNL条码号
|
public string HPCSNo; //PCS号
|
public int HPosition_x; //PCS的行索引
|
public int HPosition_y; //PCS的列索引
|
}
|
|
#endregion
|
#endregion
|
|
|
public class HY_DataMappingController : ApiController
|
{
|
//获取系统参数
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
|
#region 炬森VRS内层提取上传PNL二维码位置 接口
|
[Route("VRSInner/VRSInner_savePNLBarCodePosition")]
|
[HttpGet]
|
public VRSInner_savePNLBarCodePosition_RequestResult VRSInner_savePNLBarCodePosition(string HBarCode_PNL,double HPNLPosition_x,double HPNLPosition_y)
|
{
|
VRSInner_savePNLBarCodePosition_RequestResult result = new VRSInner_savePNLBarCodePosition_RequestResult();
|
try
|
{
|
string HLayOutName = ""; //PNL条码编号对应的PNL布局名称
|
|
string sql = @"
|
select b.HLayOutName
|
from Gy_BarCodeBill_PNL_Temp as a
|
inner join Gy_PNLInfo as b on a.HLayOutName = b.HLayOutName
|
where a.HBarCode = '" + HBarCode_PNL + "'";
|
ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill_PNL_Temp");
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
result.code = "0";
|
result.msg = "上传失败！！料号信息不存在！！";
|
return result;
|
}
|
else
|
{
|
HLayOutName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HLayOutName"]);
|
}
|
|
string sql_save = "" +
|
"update Gy_PNLInfo set HPNLPosition_x = " + HPNLPosition_x + ",HPNLPosition_y = " + HPNLPosition_y + " where HLayOutName = '" + HLayOutName + "'";
|
oCN.RunProc(sql_save);
|
|
result.code = "1";
|
result.msg = "上传成功";
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS内层获取PNL二维码位置信息 接口
|
[Route("VRSInner/VRSInner_getPNLBarCodePosition")]
|
[HttpGet]
|
public VRSInner_getPNLBarCodePosition_RequestResult VRSInner_getPNLBarCodePosition(string HBarCode_PNL)
|
{
|
VRSInner_getPNLBarCodePosition_RequestResult result = new VRSInner_getPNLBarCodePosition_RequestResult();
|
List<VRSInner_getPNLBarCodePosition_RequestResult_data> dataList = new List<VRSInner_getPNLBarCodePosition_RequestResult_data>();
|
try
|
{
|
string sql = @"
|
select top(1) b.*
|
from Gy_BarCodeBill_PNL_Temp as a
|
inner join Gy_PNLInfo as b on a.HLayOutName = b.HLayOutName
|
where a.HBarCode = '" + HBarCode_PNL + "'";
|
ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill_PNL_Temp");
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
result.code = "0";
|
result.msg = "PNL二维码烧蚀位置信息获取失败！！当前PNL二维码对应料号未设置默认烧蚀位置！！";
|
result.data = null;
|
return result;
|
}
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
VRSInner_getPNLBarCodePosition_RequestResult_data data = new VRSInner_getPNLBarCodePosition_RequestResult_data();
|
data.HBarCode_PNL = HBarCode_PNL;
|
data.HPosition_x = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["HPNLPosition_x"]);
|
data.HPosition_y = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["HPNLPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS内层检验结果上传接口
|
[Route("VRSInner/VRSInner_saveCheckNote")]
|
[HttpPost]
|
public VRSInner_saveCheckNote_RequestResult VRSInner_saveCheckNote([FromBody] JObject sMainSub)
|
{
|
VRSInner_saveCheckNote_RequestResult result = new VRSInner_saveCheckNote_RequestResult();
|
string msg_success = "";
|
try
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
string msg2 = "[" + msg1 + "]";
|
List<VRSInner_saveCheckNote_RequestParams> vRSInner_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<VRSInner_saveCheckNote_RequestParams>>(msg2);
|
|
oCN.BeginTran();
|
|
for (int i = 0; i < vRSInner_SaveCheckNote_RequestParams.Count; i++)
|
{
|
string HMaker = vRSInner_SaveCheckNote_RequestParams[i].HMaker;
|
for (int j = 0; j < vRSInner_SaveCheckNote_RequestParams[i].param.Count; j++)
|
{
|
string HBarCode = vRSInner_SaveCheckNote_RequestParams[i].param[j].HBarCode;
|
string HSetNo = "";
|
string HPCSNo = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
|
int HPosition_x = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
|
int HPosition_y = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
|
string HCheckProc = "炬森VRS内层";
|
int HPageIndex = vRSInner_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
|
string HBadReason = vRSInner_SaveCheckNote_RequestParams[i].param[j].HBadReason;
|
|
//根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
|
string sql_set = "" +
|
"select distinct " +
|
" b.HSetNo " +
|
"from Gy_PNLInfo as a " +
|
"inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
|
"where a.HLayOutName in " +
|
" ( " +
|
" select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
|
//" union " +
|
//" select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
|
" ) " +
|
"and b.HPCSNo = '" + HPCSNo + "' ";
|
ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
|
if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
|
}
|
|
string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
|
"values(" +
|
"'" + HBarCode + "'" +
|
",'" + HSetNo + "'" +
|
",'" + HPCSNo + "'" +
|
"," + HPosition_x + "" +
|
"," + HPosition_y + "" +
|
",'" + HCheckProc + "'" +
|
"," + HPageIndex + "" +
|
",'" + HBadReason + "'" +
|
",'" + HMaker + "'" +
|
",getdate() " +
|
")";
|
oCN.RunProc(sql);
|
|
msg_success += JsonConvert.SerializeObject(vRSInner_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
|
}
|
}
|
|
oCN.Commit();
|
result.code = "1";
|
result.msg = "上传成功！！" + msg_success;
|
return result;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
result.code = "0";
|
result.msg = "上传失败！！" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS外层提取上传set二维码位置 接口
|
[Route("VRSOuter/VRSOuter_saveSetBarCodePosition")]
|
[HttpGet]
|
public VRSOuter_saveSetBarCodePosition_RequestResult VRSOuter_saveSetBarCodePosition(string HBarCode_Set, double HSetPosition_x, double HSetPosition_y)
|
{
|
VRSOuter_saveSetBarCodePosition_RequestResult result = new VRSOuter_saveSetBarCodePosition_RequestResult();
|
try
|
{
|
string HLayOutName = ""; //Set条码编号对应的PNL布局名称
|
string HSetNo = ""; //set号
|
|
string sql = @"
|
select distinct
|
c.HLayOutName
|
,d.HSetNo
|
from Gy_BarCodeBill_Set_Temp as a
|
inner join Gy_BarCodeBill_PNL_Temp as b on a.HBarCode_PNL = b.HBarCode
|
inner join Gy_PNLInfo as c on b.HLayOutName = c.HLayOutName
|
inner join Gy_PNLInfoSub as d on c.HInterID = d.HInterID
|
where b.HBarCode + d.HSetNo = a.HBarCode
|
and a.HBarCode = '" + HBarCode_Set + "'";
|
ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill_Set_Temp");
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
result.code = "0";
|
result.msg = "上传失败！！料号信息不存在！！";
|
return result;
|
}
|
else
|
{
|
HLayOutName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HLayOutName"]);
|
HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
|
}
|
|
string sql_save = "" +
|
"update b set " +
|
"b.HSetPosition_x = " + HSetPosition_x + " " +
|
",b.HSetPosition_y = " + HSetPosition_y +" " +
|
"from Gy_PNLInfo as a " +
|
"inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
|
"where a.HLayOutName = '" + HLayOutName + "' " +
|
"and b.HSetNo = '" + HSetNo + "'";
|
oCN.RunProc(sql_save);
|
|
result.code = "1";
|
result.msg = "上传成功";
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS外层获取Set二维码位置信息 接口
|
[Route("VRSOuter/VRSOuter_getSetBarCodePosition")]
|
[HttpGet]
|
public VRSOuter_getSetBarCodePosition_RequestResult VRSOuter_getSetBarCodePosition(string HBarCode_Set)
|
{
|
VRSOuter_getSetBarCodePosition_RequestResult result = new VRSOuter_getSetBarCodePosition_RequestResult();
|
List<VRSOuter_getSetBarCodePosition_RequestResult_data> dataList = new List<VRSOuter_getSetBarCodePosition_RequestResult_data>();
|
try
|
{
|
string sql = @"
|
select distinct
|
d.HSetNo
|
,d.HSetPosition_x
|
,d.HSetPosition_y
|
from Gy_BarCodeBill_Set_Temp as a
|
inner join Gy_BarCodeBill_PNL_Temp as b on a.HBarCode_PNL = b.HBarCode
|
inner join Gy_PNLInfo as c on b.HLayOutName = c.HLayOutName
|
inner join Gy_PNLInfoSub as d on c.HInterID = d.HInterID
|
where b.HBarCode + d.HSetNo = a.HBarCode
|
and a.HBarCode = '" + HBarCode_Set + "'";
|
ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill_PNL_Temp");
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
result.code = "0";
|
result.msg = "Set二维码烧蚀位置信息获取失败！！当前Set二维码对应料号未设置默认烧蚀位置！！";
|
result.data = null;
|
return result;
|
}
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
VRSOuter_getSetBarCodePosition_RequestResult_data data = new VRSOuter_getSetBarCodePosition_RequestResult_data();
|
data.HBarCode_Set = HBarCode_Set;
|
data.HPosition_x = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["HSetPosition_x"]);
|
data.HPosition_y = DBUtility.ClsPub.isDoule(ds.Tables[0].Rows[i]["HSetPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS内层申请PNL条码接口
|
|
/// <summary>
|
/// 申请PNL条码接口
|
/// </summary>
|
/// <returns></returns>
|
[Route("VRSInner/VRSInner_getBarCodeBill_PNL")]
|
[HttpGet]
|
public object VRSInner_getBarCodeBill_PNL(string HLayOutName, string HMaker)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_PNL_Temp_Insert '" + HLayOutName + "','" + HMaker + "'", "h_p_Gy_BarCodeBill_PNL_Temp_Insert");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "写入获取PNL条码时发生错误！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0; //失败！
|
objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1; //成功！
|
objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "申请PNL条码接口失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
#endregion
|
|
#region 炬森VRS外层获取datamapping数据 接口
|
[Route("VRSOuter/VRSOuter_getDataMapping")]
|
[HttpGet]
|
public VRSOuter_getDataMapping_RequestResult VRSOuter_getDataMapping(string HBarCode)
|
{
|
VRSOuter_getDataMapping_RequestResult result = new VRSOuter_getDataMapping_RequestResult();
|
List<VRSOuter_getDataMapping_RequestResult_data> dataList = new List<VRSOuter_getDataMapping_RequestResult_data>();
|
try
|
{
|
string sql = "" +
|
"select distinct * from (" +
|
//"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode + "' " +
|
//"union " +
|
"select HBarCode,HPCSNo from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode + "' " +
|
") as a";
|
ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
|
for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
VRSOuter_getDataMapping_RequestResult_data data = new VRSOuter_getDataMapping_RequestResult_data();
|
data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
|
data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
|
//data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
|
//data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS外层检验结果上传接口
|
[Route("VRSOuter/VRSOuter_saveCheckNote")]
|
[HttpPost]
|
public VRSOuter_saveCheckNote_RequestResult VRSOuter_saveCheckNote([FromBody] JObject sMainSub)
|
{
|
VRSOuter_saveCheckNote_RequestResult result = new VRSOuter_saveCheckNote_RequestResult();
|
string msg_success = "";
|
try
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
string msg2 = "[" + msg1 + "]";
|
List<VRSOuter_saveCheckNote_RequestParams> vRSOuter_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<VRSOuter_saveCheckNote_RequestParams>>(msg2);
|
|
oCN.BeginTran();
|
|
for (int i = 0; i < vRSOuter_SaveCheckNote_RequestParams.Count; i++)
|
{
|
string HMaker = vRSOuter_SaveCheckNote_RequestParams[i].HMaker;
|
for (int j = 0; j < vRSOuter_SaveCheckNote_RequestParams[i].param.Count; j++)
|
{
|
string HBarCode = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HBarCode;
|
string HSetNo = "";
|
string HPCSNo = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
|
int HPosition_x = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
|
int HPosition_y = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
|
string HCheckProc = "炬森VRS外层";
|
int HPageIndex = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
|
string HBadReason = vRSOuter_SaveCheckNote_RequestParams[i].param[j].HBadReason;
|
|
//根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
|
string sql_set = "" +
|
"select distinct " +
|
" b.HSetNo " +
|
"from Gy_PNLInfo as a " +
|
"inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
|
"where a.HLayOutName in " +
|
" ( " +
|
" select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
|
//" union " +
|
//" select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
|
" ) " +
|
"and b.HPCSNo = '" + HPCSNo + "' ";
|
ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
|
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
|
}
|
|
string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
|
"values(" +
|
"'" + HBarCode + "'" +
|
",'" + HSetNo + "'" +
|
",'" + HPCSNo + "'" +
|
"," + HPosition_x + "" +
|
"," + HPosition_y + "" +
|
",'" + HCheckProc + "'" +
|
"," + HPageIndex + "" +
|
",'" + HBadReason + "'" +
|
",'" + HMaker + "'" +
|
",getdate() " +
|
")";
|
oCN.RunProc(sql);
|
|
msg_success += JsonConvert.SerializeObject(vRSOuter_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
|
}
|
}
|
|
oCN.Commit();
|
result.code = "1";
|
result.msg = "上传成功！！" + msg_success;
|
return result;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
result.code = "0";
|
result.msg = "上传失败！！" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 炬森VRS外层申请set条码接口
|
|
/// <summary>
|
/// 申请set条码接口
|
/// </summary>
|
/// <returns></returns>
|
[Route("VRSOuter/VRSOuter_getBarCodeBill_SET")]
|
[HttpGet]
|
public object VRSOuter_getBarCodeBill_SET(string HBarCode_PNL, string HMaker)
|
{
|
try
|
{
|
ds = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_Set_Temp_Insert '" + HBarCode_PNL + "','" + HMaker + "'", "h_p_Gy_BarCodeBill_Set_Temp_Insert");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "写入获取SET条码时发生错误！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0; //失败！
|
objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1; //成功！
|
objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "申请SET条码接口失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
#endregion
|
|
#region AVI获取datamapping数据 接口
|
[Route("AVI/AVI_getDataMapping")]
|
[HttpGet]
|
public AVI_getDataMapping_RequestResult AVI_getDataMapping(string HBarCode)
|
{
|
AVI_getDataMapping_RequestResult result = new AVI_getDataMapping_RequestResult();
|
List<AVI_getDataMapping_RequestResult_data> dataList = new List<AVI_getDataMapping_RequestResult_data>();
|
try
|
{
|
//根据set条码编号，获取set所属的PNL条码编号
|
string HBarCode_PNL = "";
|
string sql_PNLBarCode = "" +
|
//"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
|
//"union " +
|
"select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
|
ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
|
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
|
}
|
else
|
{
|
result.code = "0";
|
result.msg = "mapping信息获取失败！！set条码不存在！！";
|
result.data = null;
|
return result;
|
}
|
|
//根据set条码编号，获取set号。（set条码编号规则：y+ww+五位PNL流水号+两位set号）
|
string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2);
|
|
//根据PNL条码编号、set号，从PNL检验信息表中获取set对应的检验信息
|
string sql = "" +
|
"select distinct * from (" +
|
//"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
//"union " +
|
"select HBarCode,HPCSNo from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
") as a";
|
ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
AVI_getDataMapping_RequestResult_data data = new AVI_getDataMapping_RequestResult_data();
|
data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
|
data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
|
//data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
|
//data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
|
#region AVI检验结果上传接口
|
[Route("AVI/AVI_saveCheckNote")]
|
[HttpPost]
|
public AVI_saveCheckNote_RequestResult AVI_saveCheckNote([FromBody] JObject sMainSub)
|
{
|
AVI_saveCheckNote_RequestResult result = new AVI_saveCheckNote_RequestResult();
|
string msg_success = "";
|
try
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
string msg2 = "[" + msg1 + "]";
|
List<AVI_saveCheckNote_RequestParams> aVI_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<AVI_saveCheckNote_RequestParams>>(msg2);
|
|
oCN.BeginTran();
|
|
for (int i = 0; i < aVI_SaveCheckNote_RequestParams.Count; i++)
|
{
|
string HMaker = aVI_SaveCheckNote_RequestParams[i].HMaker;
|
for (int j = 0; j < aVI_SaveCheckNote_RequestParams[i].param.Count; j++)
|
{
|
string HBarCode = aVI_SaveCheckNote_RequestParams[i].param[j].HBarCode;
|
string HSetNo = "";
|
string HPCSNo = aVI_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
|
int HPosition_x = aVI_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
|
int HPosition_y = aVI_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
|
string HCheckProc = "AVI";
|
int HPageIndex = aVI_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
|
string HBadReason = aVI_SaveCheckNote_RequestParams[i].param[j].HBadReason;
|
|
//根据PNL条码找到PNL对于的PNL布局信息。然后根据PCS号在PNL布局信息中找到PCS对应的set号
|
string sql_set = "" +
|
"select distinct " +
|
" b.HSetNo " +
|
"from Gy_PNLInfo as a " +
|
"inner join Gy_PNLInfoSub as b on a.HInterID = b.HInterID " +
|
"where a.HLayOutName in " +
|
" ( " +
|
" select HLayOutName from Gy_BarCodeBill_PNL_Temp where HBarCode = '" + HBarCode + "' " +
|
//" union " +
|
//" select HLayOutName from Gy_BarCodeBill_PNL_His where HBarCode = '" + HBarCode + "' " +
|
" ) " +
|
"and b.HPCSNo = '" + HPCSNo + "' ";
|
ds = oCN.RunProcReturn(sql_set, "Gy_PNLInfo");
|
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HSetNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSetNo"]);
|
}
|
|
string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
|
"values(" +
|
"'" + HBarCode + "'" +
|
",'" + HSetNo + "'" +
|
",'" + HPCSNo + "'" +
|
"," + HPosition_x + "" +
|
"," + HPosition_y + "" +
|
",'" + HCheckProc + "'" +
|
"," + HPageIndex + "" +
|
",'" + HBadReason + "'" +
|
",'" + HMaker + "'" +
|
",getdate() " +
|
")";
|
oCN.RunProc(sql);
|
|
msg_success += JsonConvert.SerializeObject(aVI_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
|
}
|
}
|
|
oCN.Commit();
|
result.code = "1";
|
result.msg = "上传成功！！" + msg_success;
|
return result;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
result.code = "0";
|
result.msg = "上传失败！！" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 电测获取datamapping数据 接口
|
[Route("DC/DC_getDataMapping")]
|
[HttpGet]
|
public DC_getDataMapping_RequestResult DC_getDataMapping(string HBarCode)
|
{
|
DC_getDataMapping_RequestResult result = new DC_getDataMapping_RequestResult();
|
List<DC_getDataMapping_RequestResult_data> dataList = new List<DC_getDataMapping_RequestResult_data>();
|
try
|
{
|
//根据set条码编号，获取set所属的PNL条码编号
|
string HBarCode_PNL = "";
|
string sql_PNLBarCode = "" +
|
//"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
|
//"union " +
|
"select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
|
ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
|
if(ds!=null && ds.Tables.Count>0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
|
}
|
else
|
{
|
result.code = "0";
|
result.msg = "mapping信息获取失败！！set条码不存在！！";
|
result.data = null;
|
return result;
|
}
|
|
//根据set条码编号，获取set号。（set条码编号规则：y+ww+五位PNL流水号+两位set号）
|
string HSetNo = HBarCode.Substring(HBarCode.Length-2,2);
|
|
//根据PNL条码编号、set号，从PNL检验信息表中获取set对应的检验信息
|
string sql = "" +
|
"select distinct * from (" +
|
//"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
//"union " +
|
"select HBarCode,HPCSNo from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
") as a";
|
ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
DC_getDataMapping_RequestResult_data data = new DC_getDataMapping_RequestResult_data();
|
data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
|
data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
|
//data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
|
//data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 电测检验结果上传接口
|
[Route("DC/DC_saveCheckNote")]
|
[HttpPost]
|
public DC_saveCheckNote_RequestResult DC_saveCheckNote([FromBody] JObject sMainSub)
|
{
|
DC_saveCheckNote_RequestResult result = new DC_saveCheckNote_RequestResult();
|
string msg_success = "";
|
try
|
{
|
var _value = sMainSub["sMainSub"].ToString();
|
string msg1 = _value.ToString();
|
string msg2 = "[" + msg1 + "]";
|
List<DC_saveCheckNote_RequestParams> dC_SaveCheckNote_RequestParams = Newtonsoft.Json.JsonConvert.DeserializeObject<List<DC_saveCheckNote_RequestParams>>(msg2);
|
|
oCN.BeginTran();
|
|
for (int i = 0; i < dC_SaveCheckNote_RequestParams.Count; i++)
|
{
|
string HMaker = dC_SaveCheckNote_RequestParams[i].HMaker;
|
for (int j = 0; j < dC_SaveCheckNote_RequestParams[i].param.Count; j++)
|
{
|
string HBarCode = dC_SaveCheckNote_RequestParams[i].param[j].HBarCode;
|
string HBarCode_PNL = "";
|
string HSetNo = HBarCode.Substring(HBarCode.Length-2,2);
|
string HPCSNo = dC_SaveCheckNote_RequestParams[i].param[j].HPCSNo;
|
int HPosition_x = dC_SaveCheckNote_RequestParams[i].param[j].HPosition_x;
|
int HPosition_y = dC_SaveCheckNote_RequestParams[i].param[j].HPosition_y;
|
string HCheckProc = "电测";
|
int HPageIndex = dC_SaveCheckNote_RequestParams[i].param[j].HPageIndex;
|
string HBadReason = dC_SaveCheckNote_RequestParams[i].param[j].HBadReason;
|
|
//根据set条码编号，获取set所属的PNL条码编号
|
string sql_PNLBarCode = "" +
|
//"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
|
//"union " +
|
"select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
|
ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
|
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
|
}
|
|
string sql = "insert into QC_CheckNote_PNL_Temp(HBarCode,HSetNo,HPCSNo,HPosition_x,HPosition_y,HCheckProc,HPageIndex,HBadReason,HMaker,HMakeDate) " +
|
"values(" +
|
"'" + HBarCode_PNL + "'" +
|
",'" + HSetNo + "'" +
|
",'" + HPCSNo + "'" +
|
"," + HPosition_x + "" +
|
"," + HPosition_y + "" +
|
",'" + HCheckProc + "'" +
|
"," + HPageIndex + "" +
|
",'" + HBadReason + "'" +
|
",'" + HMaker + "'" +
|
",getdate() " +
|
")";
|
oCN.RunProc(sql);
|
|
msg_success += JsonConvert.SerializeObject(dC_SaveCheckNote_RequestParams[i].param[j], Formatting.Indented);
|
}
|
}
|
|
oCN.Commit();
|
result.code = "1";
|
result.msg = "上传成功！！" + msg_success;
|
return result;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
result.code = "0";
|
result.msg = "上传失败！！" + e.Message;
|
return result;
|
}
|
}
|
#endregion
|
|
#region 激光割获取datamapping数据 接口
|
[Route("JGG/JGG_getDataMapping")]
|
[HttpGet]
|
public JGG_getDataMapping_RequestResult JGG_getDataMapping(string HBarCode)
|
{
|
JGG_getDataMapping_RequestResult result = new JGG_getDataMapping_RequestResult();
|
List<JGG_getDataMapping_RequestResult_data> dataList = new List<JGG_getDataMapping_RequestResult_data>();
|
try
|
{
|
//根据set条码编号，获取set所属的PNL条码编号
|
string HBarCode_PNL = "";
|
string sql_PNLBarCode = "" +
|
//"select * from Gy_BarCodeBill_Set_His where HBarCode = '" + HBarCode + "' " +
|
//"union " +
|
"select * from Gy_BarCodeBill_Set_Temp where HBarCode = '" + HBarCode + "' ";
|
ds = oCN.RunProcReturn(sql_PNLBarCode, "Gy_BarCodeBill_Set_Temp");
|
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
|
{
|
HBarCode_PNL = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBarCode_PNL"]);
|
}
|
else
|
{
|
result.code = "0";
|
result.msg = "mapping信息获取失败！！set条码不存在！！";
|
result.data = null;
|
return result;
|
}
|
|
//根据set条码编号，获取set号。（set条码编号规则：y+ww+五位PNL流水号+两位set号）
|
string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2);
|
|
//根据PNL条码编号、set号，从PNL检验信息表中获取set对应的检验信息
|
string sql = "" +
|
"select distinct * from (" +
|
//"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
//"union " +
|
"select HBarCode,HPCSNo from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
|
") as a";
|
ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
|
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
JGG_getDataMapping_RequestResult_data data = new JGG_getDataMapping_RequestResult_data();
|
data.HBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBarCode"]);
|
data.HPCSNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HPCSNo"]);
|
//data.HPosition_x = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_x"]);
|
//data.HPosition_y = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[i]["HPosition_y"]);
|
dataList.Add(data);
|
}
|
|
result.code = "1";
|
result.msg = "";
|
result.data = dataList;
|
return result;
|
}
|
catch (Exception e)
|
{
|
result.code = "0";
|
result.msg = "" + e.Message;
|
result.data = null;
|
return result;
|
}
|
}
|
#endregion
|
}
|
}
|
