public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> psi_purchase </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> psi_purchaseGoods </table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>"); var service = new psi_purchaseService(); var result = service.Edit(formWrapper, listWrapper, data); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as SupplierName,case when A.AuditState='passed' then 'true' else 'false' end as IsEffect </select> <from> psi_purchase A left join psi_supplier B on B.Id = A.Supplier </from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='PurchasePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='PurchaseDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var PurchaseService = new psi_purchaseService(); var pQuery = query.ToParamQuery(); pQuery.AndWhere("AuditState", query["IsEffect"], x => x.Value == "true"?"AuditState='passed'":"isnull(AuditState,'') <> 'passed'"); var result = PurchaseService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo", id) .LoadSettingXmlString(@" <settings defaultOrderBy='RowId'> <select> A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit </select> <from> psi_purchaseGoods A left join psi_goods B on B.Id = A.GoodNo </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var PurchaseService = new psi_purchaseService(); var result = PurchaseService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic GetEditMaster(string id) { dynamic result = new ExpandoObject(); var masterService = new psi_purchaseService(); result.form = masterService.GetDynamic(ParamQuery.Instance().Select("*,cast((case when AuditState='passed' then 'true' else 'false' end) as bit) as IsEffect ").AndWhere("BillNo", id)); if (result.form != null) { result.form.BillNo = id; //如果没有数据,返回一条空数据,BillNo=id; 对应新增的情况 } result.scrollKeys = masterService.ScrollKeys("BillNo", id); return(result); }
public void Delete(string id) { var service = new psi_purchaseService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); if (result <= 0) { throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("采购单删除失败{BillNo=" + id + "},请重试或联系管理员!") }); } }
public void Audit(string id, dynamic data) { var service = new psi_purchaseService(); var result = service.Update(ParamUpdate.Instance() .Column("AuditState", data.status) .Column("AuditReason", data.comment) .Column("AuditPerson", FormsAuth.GetUserData().UserName) .Column("AuditDate", DateTime.Now) .AndWhere("BillNo", id)); if (result <= 0) { throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("审核采购单失败{BillNo=" + id + "},请重试或联系管理员!") }); } }
public string GetNewBillNo() { var service = new psi_purchaseService(); return(service.GetNewKey("BillNo", "dateplus")); }
public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo", id) .LoadSettingXmlString(@" <settings defaultOrderBy='RowId'> <select> A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit </select> <from> psi_purchaseGoods A left join psi_goods B on B.Id = A.GoodNo </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var PurchaseService = new psi_purchaseService(); var result = PurchaseService.GetDynamicListWithPaging(pQuery); return result; }
public dynamic GetEditMaster(string id) { dynamic result = new ExpandoObject(); var masterService = new psi_purchaseService(); result.form = masterService.GetDynamic(ParamQuery.Instance().Select("*,cast((case when AuditState='passed' then 'true' else 'false' end) as bit) as IsEffect ").AndWhere("BillNo", id)); if (result.form!=null) result.form.BillNo = id; //如果没有数据,返回一条空数据,BillNo=id; 对应新增的情况 result.scrollKeys = masterService.ScrollKeys("BillNo", id); return result; }
public void Audit(string id, dynamic data) { var service = new psi_purchaseService(); var result = service.Update(ParamUpdate.Instance() .Column("AuditState", data.status) .Column("AuditReason", data.comment) .Column("AuditPerson", FormsAuth.GetUserData().UserName) .Column("AuditDate", DateTime.Now) .AndWhere("BillNo", id)); if (result <= 0) throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("审核采购单失败{BillNo=" + id + "},请重试或联系管理员!") }); }
public void Delete(string id) { var service = new psi_purchaseService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); if (result <= 0) throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("采购单删除失败{BillNo=" + id + "},请重试或联系管理员!") }); }
public string GetNewBillNo() { var service = new psi_purchaseService(); return service.GetNewKey("BillNo", "dateplus"); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as SupplierName,case when A.AuditState='passed' then 'true' else 'false' end as IsEffect </select> <from> psi_purchase A left join psi_supplier B on B.Id = A.Supplier </from> <where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='PurchasePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='PurchaseDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var PurchaseService = new psi_purchaseService(); var pQuery = query.ToParamQuery(); pQuery.AndWhere("AuditState", query["IsEffect"], x => x.Value == "true"?"AuditState='passed'":"isnull(AuditState,'') <> 'passed'"); var result = PurchaseService.GetDynamicListWithPaging(pQuery); return result; }