public int GetCount(PanelContext data) { ModelDBHelper helper = ModelDBHelper.Create(data.ModelName); Criteria ct = CreateQueryCriteria(data.QueryFields, data); return(helper.Count(ct)); }
public System.Data.DataRow Get(PanelContext data) { ModelDBHelper helper = ModelDBHelper.Create(data.ModelName); DataTable dt = helper.Query(CreatePKCriteria(data.DataKey), CreateOrders(data.Orders), 0, 0); return(dt.Rows.Count > 0 ? dt.Rows[0] : dt.NewRow()); }
public bool Delete(PanelContext data) { ModelDBHelper helper = ModelDBHelper.Create(data.ModelName); helper.Delete(CreatePKCriteria(data.DataKey)); return(true); }
public bool Insert(PanelContext data) { ModelDBHelper helper = ModelDBHelper.Create(data.ModelName); if (data.Row.IndexByMapping("AccountID") == null) { data.Row["AccountID"] = Security.CurrentAccountID; } helper.Insert(data.Row); return(true); }
public System.Data.DataTable Query(PanelContext data, out int recordcount, ref int pageindex) { ModelDBHelper helper = ModelDBHelper.Create(data.ModelName); Criteria ct = CreateQueryCriteria(data.QueryFields, data); recordcount = helper.Count(ct); int startindex, itemscount; Utils.BuidlPagerParam(recordcount, data.PageSize, ref pageindex, out startindex, out itemscount); return(helper.Query(ct, CreateOrders(data.Orders), startindex, itemscount)); }
Criteria CreateQueryCriteria(QueryFieldCollection qfc, PanelContext data) { Criteria ct = new Criteria(CriteriaType.None); //if (data.Model.Type == ModelType.ARTICLE && !data.Model.AuthorityType && // Security.CurrentAccountID != We7Helper.EmptyGUID) ////if (!GeneralConfigs.GetConfig().ShowAllInfo && Security.CurrentAccountID != We7Helper.EmptyGUID && !String.IsNullOrEmpty(Security.CurrentAccountID)) //{ // ct.Add(CriteriaType.Equals, "AccountID", Security.CurrentAccountID); //} foreach (QueryField qf in qfc) { if (qf.Operator == OperationType.LIKE) { ct.Add(ModelDBHelper.ConvertOperationType(qf.Operator), qf.Column.Name, "%" + qf.Value + "%"); } else { ct.Add(ModelDBHelper.ConvertOperationType(qf.Operator), qf.Column.Name, qf.Value); } } return(ct); }