| | |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("VRSInner/VRSInner_getBarCodeBill_PNL")] |
|---|
| | | [HttpGet] |
|---|
| | | public object VRSInner_getBarCodeBill_PNL(string HLayOutName, string HMaker) |
|---|
| | | public object VRSInner_getBarCodeBill_PNL(string HLayOutName, string HMaker, string HBatchNo) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_PNL_Temp_Insert '" + HLayOutName + "','" + HMaker + "'", "h_p_Gy_BarCodeBill_PNL_Temp_Insert"); |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_PNL_Temp_Insert '" + HLayOutName + "','" + HMaker + "','" + HBatchNo + "'" , "h_p_Gy_BarCodeBill_PNL_Temp_Insert"); |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | |
|---|
| | | string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2); |
|---|
| | | |
|---|
| | | //æ ¹æ®PNLæ¡ç ç¼å·ãsetå·ï¼ä»PNLæ£éªä¿¡æ¯è¡¨ä¸è·åset对åºçæ£éªä¿¡æ¯ |
|---|
| | | //string sql = "exec h_p_Gy_GetMappingData_JiGuangGe '" + HBarCode_PNL + "','" + HSetNo + "'"; |
|---|
| | | //ds = oCN.RunProcReturn(sql, "h_p_Gy_GetMappingData_JiGuangGe"); |
|---|
| | | string sql = "" + |
|---|
| | | "select distinct * from (" + |
|---|
| | | //"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " + |
|---|
