| | |
| | | |
| | | /// <summary> |
| | | /// 返回列表 |
| | | /// 来料入库检验单 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("QC_POStockInCheckBill/GetPOStockInCheckBill")] |
| | | [Route("QC_POStockInCheckBill/GetPOStockInCheckBill")] |
| | | [HttpGet] |
| | | public object GetPOStockInCheckBill(string sWhere) |
| | | public object GetPOStockInCheckBill(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | { |
| | | //查看权限 |
| | | if (!DBUtility.ClsPub.Security_Log("QC_POStockInCheckBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "无查看权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = QC_POStockInCheckBill(sWhere); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "返回记录成功!"; |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string user = sArray[2].ToString(); |
| | | try |
| | | { |
| | | //判断权限 |
| | | if (!DBUtility.ClsPub.Security_Log("QC_POStockInCheckBill_Edit", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "无保存权限"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<QC_POStockInCheckBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<QC_POStockInCheckBill>>(msg2); |
| | | int HYear = 2021; |
| | |
| | | /// <returns></returns> |
| | | [Route("QC_POStockInCheckBill/DeltetPOStockInCheckBill")] |
| | | [HttpGet] |
| | | public object DeltetPOStockInCheckBill(string HInterID) |
| | | public object DeltetPOStockInCheckBill(string HInterID,string user) |
| | | { |
| | | try |
| | | { |
| | | //查看权限 |
| | | if (!DBUtility.ClsPub.Security_Log("QC_POStockInCheckBill_Delete", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "无删除权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Delete From QC_POStockInCheckBillMain where HInterID = " + HInterID); |
| | | oCN.RunProc("Delete From QC_POStockInCheckBillSub where HInterID = " + HInterID); |