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);
}
