public SenVietReportObject(HttpRequestBase request) { this.InitObject(); this._db = new Models.WebAppAccEntities(Services.GlobalVariant.GetConnection()); this._request = request; this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname); this._currentsession = HttpContext.Current.Session; this._sessionkeys = string.Format("{0}.Model", this._businesscode); this._sessionparamskeys = string.Format("{0}.Params", this._businesscode); appajaxoption.ajaxoption.Add("ajaxupdateid", string.Format("{0}_container", this._metaname.ToLower())); appajaxoption.ajaxoption.Add("businesscode", this._businesscode); appajaxoption.ajaxoption.Add("metaname", this._metaname); appajaxoption.ajaxoption.Add("keyfield", this._keyfield); appajaxoption.ajaxoption.Add("action-return", this._request["action_return"]); this.sysreports = this._db.SysReports.Where(m => m.BusinessCode == this._businesscode).OrderBy(m => m.IsDefault).ToList(); this.sysbusiness = this._db.SysBusinesses.Where(m => m.BusinessCode == this._businesscode).SingleOrDefault(); int roleid = Services.GlobalVariant.GetAppUser().RoleID; this.sysbusinessrole = this._db.SysBusinessRoles.Where(m => m.BusinessCode == this._businesscode & m.RoleID == roleid).SingleOrDefault(); }
public SenVietVoucherObject(HttpRequestBase request) { this.InitObject(); this._db = new Models.WebAppAccEntities(Services.GlobalVariant.GetConnection());; this._request = request; this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname); this._paramnamemasteroutput = this._keyfieldmaster; this._paramnamemasterupdate = string.Format("Original_{0}", this._keyfieldmaster); this._paramnamelineoutput = this._keyfieldline; this._paramnamelineupdate = string.Format("Original_{0}", this._keyfieldline); this._paramnamevatoutput = this._keyfieldvat; this._paramnamevatupdate = string.Format("Original_{0}", this._keyfieldvat); appajaxoption.ajaxoption.Add("ajaxupdateid", string.Format("{0}_container", this._metaname.ToLower())); appajaxoption.ajaxoption.Add("businesscode", this._businesscode); appajaxoption.ajaxoption.Add("metaname", this._metaname); appajaxoption.ajaxoption.Add("keyfield", this._keyfieldmaster); appajaxoption.ajaxoption.Add("action-return", this._request["action_return"]); this.sysbusiness = this._db.SysBusinesses.Where(m => m.BusinessCode == this._businesscode).SingleOrDefault(); int roleid = Services.GlobalVariant.GetAppUser().RoleID; this.sysbusinessrole = this._db.SysBusinessRoles.Where(m => m.BusinessCode == this._businesscode & m.RoleID == roleid).SingleOrDefault(); }
public SenVietListObject(HttpRequestBase request) { this.InitObject(); this._db = new Models.AdminContext(); this._request = request; this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname); this._paramnameoutput = this._keyfield; this._paramnameupdate = string.Format("Original_{0}", this._keyfield); appajaxoption.ajaxoption.Add("ajaxupdateid", string.Format("{0}_container", this._metaname.ToLower())); appajaxoption.ajaxoption.Add("businesscode", this._businesscode); appajaxoption.ajaxoption.Add("metaname", this._metaname); appajaxoption.ajaxoption.Add("keyfield", this._keyfield); appajaxoption.ajaxoption.Add("action-return", this._request["action_return"]); //this.sysbusiness = this._db.SysBusinesses.Where(m => m.BusinessCode == this._businesscode).SingleOrDefault(); //int roleid = Services.GlobalVariant.GetAppUser().RoleID; //this.sysbusinessrole = this._db.SysBusinessRoles.Where(m => m.BusinessCode == this._businesscode & m.RoleID == roleid).SingleOrDefault(); }
public static List <SqlParameter> Data2SqlParam(dynamic data, Models.MetaObject metaobject, string outputparaname, SqlParameter parameter) { List <SqlParameter> parameterlist = new List <SqlParameter>(); outputparaname = string.Format("@{0}", outputparaname); foreach (var item in metaobject.MetaTable) { SqlParameter para = ExConvert.ParseSqlParam(data, item); if (outputparaname == para.ParameterName) { //tạm thời sử dụng 1 output para.Direction = ParameterDirection.Output; } parameterlist.Add(para); } if (parameter != null) { parameterlist.Add(parameter); } return(parameterlist); }
//public static Dictionary<string, List<SenViet.Areas.SysAdmin.Models.SysTableDetailView>> MetaData = new Dictionary<string, List<SenViet.Areas.SysAdmin.Models.SysTableDetailView>>(); //public static Dictionary<string,SenViet.Models.MetaObject> MetaObjects = new Dictionary<string,Models.MetaObject>(); public static void SetMetaObject(string tablename) { //Dictionary<string, SenViet.Models.MetaObject> MetaObjects = null; Dictionary <string, Models.MetaObject> MetaObjects = null; if (HttpContext.Current.Session[CacheKey.GlobalMetaKeys] == null) { MetaObjects = new Dictionary <string, Models.MetaObject>(); HttpContext.Current.Session[CacheKey.GlobalMetaKeys] = MetaObjects; } else { MetaObjects = (Dictionary <string, Models.MetaObject>)HttpContext.Current.Session[CacheKey.GlobalMetaKeys]; } if (!MetaObjects.ContainsKey(tablename)) { var MetaObject = new Models.MetaObject(); Models.WebAppAccEntities db = new Models.WebAppAccEntities(Services.GlobalVariant.GetConnection()); MetaObject.MetaTable = db.SysTableDetailViews.Where(m => m.TableName == tablename).ToList(); MetaObject.Paging = new Models.Paging(); MetaObjects.Add(tablename, MetaObject); } //else // dành cho phát triển sau này phải bỏ //{ // var MetaObject = new SenViet.Models.MetaObject(); // SenViet.Areas.SysAdmin.Models.SysAdminEntities _slmeta = new SenViet.Areas.SysAdmin.Models.SysAdminEntities(); // var _result = _slmeta.SysTableDetailViews.Where(m => m.TableName == tablename).ToList(); // MetaObject.MetaTable = _result; // MetaObject.Paging = new Models.Paging(); // MetaObjects.Remove(tablename); // MetaObjects.Add(tablename, MetaObject); //} }
public static List <SqlParameter> Data2SqlParam(dynamic data, Models.MetaObject metaobject, SqlParameter parameter) { return(Data2SqlParam(data, metaobject, "", parameter)); }
public static List <SqlParameter> Data2SqlParam(dynamic data, Models.MetaObject metaobject, string outputparaname) { return(Data2SqlParam(data, metaobject, outputparaname, null)); }
public AppVoucherTable(HttpRequestBase request) { this._db = new Models.WebAppAccEntities(Services.GlobalVariant.GetConnection());; this._request = request; this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname); }