| | |
| | | /// <param name="pa"></param> |
| | | /// <returns></returns> |
| | | public IEnumerable<OA_Fukuanshenqing> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd, |
| | | string Creater, string SupplierName,string shifoufukuan) |
| | | string Creater, string SupplierName,string shifoufukuan,string selFukuanyongtu) |
| | | { |
| | | string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 "; |
| | | |
| | |
| | | Condition += " and ok.SupplierName like '%" + SupplierName + "%' "; |
| | | if (!string.IsNullOrEmpty(shifoufukuan)) |
| | | Condition += " and ok.FukuanStatus = '" + shifoufukuan + "'"; |
| | | if (!string.IsNullOrEmpty(selFukuanyongtu)) |
| | | Condition += " and ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'"; |
| | | |
| | | Query query = new Query(); |
| | | IList<Criterion> criterias = new List<Criterion>() |
| | |
| | | /// <param name="pa"></param> |
| | | /// <returns></returns> |
| | | public IEnumerable<OA_Fukuanshenqing> SelectModelPageweikaipiao(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd, |
| | | string Creater, string SupplierName, string shifoufukuan) |
| | | string Creater, string SupplierName, string shifoufukuan, string selFukuanyongtu) |
| | | { |
| | | string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 and ok.Youwufapiao !=2 and ok.FukuanStatus = 2 "; |
| | | |
| | |
| | | Condition += " and ok.SupplierName like '%" + SupplierName + "%' "; |
| | | if (!string.IsNullOrEmpty(shifoufukuan)) |
| | | Condition += " and ok.FukuanStatus = '" + shifoufukuan + "'"; |
| | | if (!string.IsNullOrEmpty(selFukuanyongtu)) |
| | | Condition += " and ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'"; |
| | | |
| | | Query query = new Query(); |
| | | IList<Criterion> criterias = new List<Criterion>() |