New file |
| | |
| | | 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_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å¤å±è·å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å
屿£éªç»æä¸ä¼ æ¥å£ |
| | | [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å¤å±è·å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 * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode + "' " + |
| | | //"union " + |
| | | "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode + "'"; |
| | | 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 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 |
| | | { |
| | | string sql = "" + |
| | | //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode + "' " + |
| | | //"union " + |
| | | "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode + "'"; |
| | | 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"]); |
| | | } |
| | | |
| | | //æ ¹æ®setæ¡ç ç¼å·ï¼è·åsetå·ãï¼setæ¡ç ç¼å·è§åï¼y+ww+äºä½PNLæµæ°´å·+两ä½setå·ï¼ |
| | | string HSetNo = HBarCode.Substring(HBarCode.Length-2,2); |
| | | |
| | | //æ ¹æ®PNLæ¡ç ç¼å·ãsetå·ï¼ä»PNLæ£éªä¿¡æ¯è¡¨ä¸è·åset对åºçæ£éªä¿¡æ¯ |
| | | string sql = "" + |
| | | //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " + |
| | | //"union " + |
| | | "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' "; |
| | | 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"]); |
| | | } |
| | | |
| | | //æ ¹æ®setæ¡ç ç¼å·ï¼è·åsetå·ãï¼setæ¡ç ç¼å·è§åï¼y+ww+äºä½PNLæµæ°´å·+两ä½setå·ï¼ |
| | | string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2); |
| | | |
| | | //æ ¹æ®PNLæ¡ç ç¼å·ãsetå·ï¼ä»PNLæ£éªä¿¡æ¯è¡¨ä¸è·åset对åºçæ£éªä¿¡æ¯ |
| | | string sql = "" + |
| | | //"select * from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " + |
| | | //"union " + |
| | | "select * from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' "; |
| | | 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 |
| | | } |
| | | } |