File was renamed from WebAPI/Controllers/²Ö´æ¹ÜÀí/Kf_MateOutBillController.cs |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBillList order by æ¥æ desc", "h_v_IF_MateOutBillList"); |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBillList " + sWhere + " order by æ¥æ desc", "h_v_IF_MateOutBillList"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | |
| | | /// çäº§é¢æåå é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Sc_MouldProdInBill/set_DeleteBill")] |
| | | [Route("Kf_MateOutBill/set_DeleteBill")] |
| | | [HttpGet] |
| | | public object set_DeleteBill(string HInterID,string user) |
| | | public object set_DeleteBill(string HInterID, string user) |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Delete", 1, true, user)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_MateOutBill_Delete", 1, true, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | DLL.ClsSc_MouldProdInBill oBill = new DLL.ClsSc_MouldProdInBill(); |
| | | DLL.ClsKf_MateOutBill oBill = new DLL.ClsKf_MateOutBill(); |
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HBillStatus > 1) |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker !=null) |
| | | if (oBill.omodel.HChecker != "" && oBill.omodel.HChecker != null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | /// <param name="HInterID">忮ID</param> |
| | | /// <param name="CurUserName">å®¡æ ¸äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Sc_MouldProdInBill/set_CheckBill")] |
| | | [Route("Kf_MateOutBill/set_CheckBill")] |
| | | [HttpGet] |
| | | public object set_CheckBill(int HInterID, string CurUserName) |
| | | { |
| | | string ModRightNameCheck = "Sc_MouldProdInBill_Check"; |
| | | string ModRightNameCheck = "Kf_MateOutBill_Check"; |
| | | DBUtility.ClsPub.CurUserName = CurUserName; |
| | | DLL.ClsSc_MouldProdInBill oBill = new DLL.ClsSc_MouldProdInBill(); |
| | | DLL.ClsKf_MateOutBill oBill = new DLL.ClsKf_MateOutBill(); |
| | | try |
| | | { |
| | | //å®¡æ ¸æé |
| | |
| | | /// <param name="HInterID">忮ID</param> |
| | | /// <param name="CurUserName">å®¡æ ¸äºº</param> |
| | | /// <returns></returns> |
| | | [Route("Sc_MouldProdInBill/set_AbandonCheck")] |
| | | [Route("Kf_MateOutBill/set_AbandonCheck")] |
| | | [HttpGet] |
| | | public object set_AbandonCheck(int HInterID, string CurUserName) |
| | | { |
| | | string ModRightNameCheck = "Sc_MouldProdInBill_Check"; |
| | | string ModRightNameCheck = "Kf_MateOutBill_Check"; |
| | | DBUtility.ClsPub.CurUserName = CurUserName; |
| | | DLL.ClsSc_MouldProdInBill oBill = new DLL.ClsSc_MouldProdInBill(); |
| | | DLL.ClsKf_MateOutBill oBill = new DLL.ClsKf_MateOutBill(); |
| | | try |
| | | { |
| | | //å®¡æ ¸æé |
| | |
| | | { |
| | | ds = oCN.RunProcReturn(string.Format(@"select HMaterID ,ç©æä»£ç HMaterCode ,ç©æåç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,计éåä½ä»£ç HUnitCode,计éåä½ HUnitName,åºæ¶æ°é HQtyMust,宿¶æ°é HQty,åä»· HPrice,éé¢ HMoney,HWHID,颿ä»åºä»£ç HWHCode,颿ä»åº HWHName,表ä½å¤æ³¨ HRemark |
| | | from h_v_IF_MateOutBillList"), "H_V_IF_MATEOUTBILLLIST"); |
| | | |
| | | |
| | | } |
| | | else |
| | | { |
| | |
| | | try |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Edit", 1, true, msg4)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_MateOutBill_Edit", 1, true, msg4)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | List<Models.ClsKf_MateOutBillMain> lsmain = new List<Models.ClsKf_MateOutBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Kf_ICStockBillMain(msg2); |
| | | lsmain = oListModels.getObjectByJson_Kf_MateOutBillMain(msg2); |
| | | foreach (Models.ClsKf_MateOutBillMain oItem in lsmain) |
| | | { |
| | | if (refSav == "Add") |
| | |
| | | } |
| | | //oItem.HMaker = ""; |
| | | UserName = oItem.HMaker; //å¶å人 |
| | | oItem.HBillType = "3801"; |
| | | oItem.HBillSubType = "3801"; |
| | | oItem.HBillType = "1204"; |
| | | oItem.HBillSubType = "1204"; |
| | | //oItem.HBillNo = ""; //åæ®å· |
| | | //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ |
| | | //oItem.HInnerBillNo = ""; // --å
é¨åæ®å· |
| | |
| | | { |
| | | //flag=1 å®¡æ ¸ï¼ flag=2 åå®¡æ ¸ |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBill_Check", 1, true, user)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_MateOutBill_Check", 1, true, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |