| | |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[1].ToString(); |
| | | string msg2 = sArray[0].ToString();//ä¿åæ°æ® |
| | | string user = sArray[1].ToString();//ç¨æ·å |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | |
| | | ////夿æ¯å¦æç¼è¾æé |
| | | //if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Edit", 1, false, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ æéç¼è¾!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2); |
| | |
| | | /// <returns></returns> |
| | | [Route("Cg_POInStockBill/DeltetPOInStockBill")] |
| | | [HttpGet] |
| | | public object DeltetPOInStockBill(string HInterID) |
| | | public object DeltetPOInStockBill(string HInterID,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå é¤çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Drop", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿é!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //å
å é¤ éè¶æ°æ® |
| | | objJsonResult = DeleteKingDee(HInterID); |
| | | if (objJsonResult.code == "0") |
| | |
| | | #region éå®éè´§åæ¥è¯¢ |
| | | [Route("Kf_ICStockBillMain/GetCStockBillList")] |
| | | [HttpGet] |
| | | public object GetCStockBillList(string sWhere) |
| | | public object GetCStockBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_ICStockBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_Kf_ICStockBillMain where 1=1", "h_v_IF_Kf_ICStockBillMain"); |
| | |
| | | [HttpGet] |
| | | public object AuditProcessReportList(int HInterID, int IsAudit, string CurUserName) |
| | | { |
| | | //IsAudit=1 å®¡æ ¸ï¼ IsAudit=2 åå®¡æ ¸ |
| | | //ç¼è¾æé |
| | | //if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdMoveBill_Check", 1, false, CurUserName)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ å®¡æ ¸æéï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | try |
| | | { |
| | | //IsAudit=1 å®¡æ ¸ï¼ IsAudit=2 åå®¡æ ¸ |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_ICStockBill_Check", 1, false, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å®¡æ ¸æéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(HInterID); |
| | | if (lngBillKey == 0) |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProductionReturnBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | public object list(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢çæé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_ProductionReturnBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ProductionReturnList where 1=1 order by æ¥æ desc", "h_v_IF_ProductionReturnList"); |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_SellOutBill/GetSellOutBillList")] |
| | | [HttpGet] |
| | | public object GetSellOutBillList(string sWhere) |
| | | public object GetSellOutBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = Sc_GetSellOutBillList(sWhere); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_OtherOutBill/GetOtherOutBillList")] |
| | | [HttpGet] |
| | | public object GetOtherOutBillList(string sWhere) |
| | | public object GetOtherOutBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_OtherOutBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_OtherOutBillList where 1=1 order by æ¥æ desc", "h_v_Kf_OtherOutBillList"); |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_ProductInBill/GetProductInBill")] |
| | | [HttpGet] |
| | | public object GetProductInBill(string sWhere) |
| | | public object GetProductInBill(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_ProductInBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_OtherInBill/GetOtherInBill")] |
| | | [HttpGet] |
| | | public object GetOtherInBill(string sWhere) |
| | | public object GetOtherInBill(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_OtherInBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_EntrustInBill/GetEntrustInBill")] |
| | | [HttpGet] |
| | | public object GetEntrustInBill(string sWhere) |
| | | public object GetEntrustInBill(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (DBUtility.ClsPub.Security_Log("Kf_EntrustInBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Kf_EntrustInBillList where 1=1", "h_v_Kf_EntrustInBillList"); |
| | |
| | | /// </summary> |
| | | [Route("Xs_SeOrderBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | public object list(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList " + sWhere, "h_v_IF_SeOrderBillList"); |
| | |
| | | /// </summary> |
| | | [Route("Xs_SeOutStockBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | public object list(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOutStockBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList " + sWhere, "h_v_IF_SeOutStockBillList"); |
| | |
| | | |
| | | [Route("WW_PPBomBillController/Get_WW_PPBomBillList")] |
| | | [HttpGet] |
| | | public object Get_WW_PPBomBillList(string sWhere) |
| | | public object Get_WW_PPBomBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | |
| | | if (!DBUtility.ClsPub.Security_Log("", 1, false, user)) |
| | | { |
| | | |
| | | } |
| | | |
| | | ds = WW_PPBomBillList(sWhere); |
| | | if (ds == null) |
| | | { |
| | |
| | | |
| | | public static DataSet WW_PPBomBillList(string sWhere) |
| | | { |
| | | string sql1 = string.Format(@"select * from h_v_WW_PPBomBillList"); |
| | | string sql1 = string.Format(@"select * from h_v_WW_PPBomBillList where 1=1 "); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + "order by æ¥æ desc", "h_v_WW_PPBomBillList"); |
| | |
| | | |
| | | [Route("Kf_MateOutBackBill/GetMateOutBillList")] |
| | | [HttpGet] |
| | | public object GetMateOutBillList(string sWhere) |
| | | public object GetMateOutBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_MateOutBackBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBackBillList order by æ¥æ desc", "h_v_IF_MateOutBackBillList"); |
| | |
| | | public object set_DeleteBill(string HInterID,string user) |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_MateOutBackBill_Delete", 1, false, user)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_EntrustOutBill_Drop", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | |
| | | [Route("Kf_MateOutBill/GetMateOutBillList")] |
| | | [HttpGet] |
| | | public object GetMateOutBillList(string sWhere) |
| | | public object GetMateOutBillList(string sWhere,string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_MateOutBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBillList " + sWhere + " order by æ¥æ desc", "h_v_IF_MateOutBillList"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | try |
| | | { |
| | | //夿æé(ç¥) |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_MoveStockStepOutBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = string.Format("select * from h_v_Kf_MoveStockStepOutBillList where (è°å
¥ç»ç»='" + Organization + "')"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | |
| | | |
| | | [Route("Kf_EntrustOutBackBill/GetEntrustOutBackBillList")] |
| | | [HttpGet] |
| | | public object GetEntrustOutBackBillList(string sWhere) |
| | | public object GetEntrustOutBackBillList(string sWhere,string user) |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Kf_EntrustOutBillQuery", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_Kf_EntrustOutBillList " + sWhere + " order by æ¥æ desc", "h_v_Kf_EntrustOutBillList"); |
| | |
| | | { |
| | | try |
| | | { |
| | | //夿æé(ç¥) |
| | | |
| | | //夿æ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Fb_StepFoldinBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = string.Format("select * from h_v_Kf_MoveStockStepInBillList where (è°å
¥ç»ç»='" + Organization + "')"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | |
| | | "from Sc_ICMOBillStatus_Tmp where HSourceBillNo='"+omodel.HSourceBillNo.ToString()+"'" + |
| | | " and HSourceInterID='"+omodel.HSourceInterID+"' and HSourceEntryID='"+omodel.HMainSourceEntryID.ToString()+"'" + |
| | | " and HSourceID='"+omodel.HSourceID.ToString()+"' and HProcID='"+omodel.HProcID.ToString()+"'"); |
| | | oCn.RunProc(sql); |
| | | oCn.RunProc(sql1); |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |