| | |
| | | List<Model.ClsKf_MateOutBillMain> lsmain = new List<Model.ClsKf_MateOutBillMain>(); |
| | | ListModels oListModels = new ListModels(); |
| | | lsmain = oListModels.getMateOutBillMainByJson(msg1); |
| | | lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | string sSourceBillType = lsmain[0].HBillType;//源单类型 |
| | | |
| | | WebAPI.WebS.ClsKf_MateOutBillMain websLsmain = new WebS.ClsKf_MateOutBillMain(); |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "生成领料单成功!单据号为:"; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功! |
| | | //objJsonResult.Message = "生成领料单成功!单据号为:"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "上传失败!" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败! |
| | | //objJsonResult.Message = "上传失败!" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "生成退料单成功!单据号为:"; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功! |
| | | //objJsonResult.Message = "生成退料单成功!单据号为:"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "上传失败!" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败! |
| | | //objJsonResult.Message = "上传失败!" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | MaterOutSumReport com = JsonConvert.DeserializeObject<MaterOutSumReport>(sWhere.ToString()); |
| | | |
| | | string sql = "" + |
| | | "( (染厂出站日期 between ''" + com.HBeginDate + "'' and ''" + com.HEndDate + "'') or (''" + com.HBeginDate + "'' = '''' and ''" + com.HEndDate + "''='''') ) " + |
| | | "( (生产订单日期 between ''" + com.HBeginDate + "'' and ''" + com.HEndDate + "'') or (''" + com.HBeginDate + "'' = '''' and ''" + com.HEndDate + "''='''') ) " + |
| | | "and (产品代码=''" + com.HMaterNumber + "'' or ''" + com.HMaterNumber + "''='''') " + |
| | | "and (生产订单号=''" + com.HBillNo + "'' or ''" + com.HBillNo + "''='''') " + |
| | | "and (产品名称=''" + com.HProductName + "'' or ''" + com.HProductName + "''='''') " + |