public MenuInfo Load(string string_2) { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat("select * from ", this.string_0, " where MenuID=", string_2)); MenuInfo menuInfo = null; if (dataTable.Rows.Count > 0) { DataRow item = dataTable.Rows[0]; menuInfo = new MenuInfo() { MenuID = Convert.ToString(item["MenuID"]) }; object obj = item["NAME"]; menuInfo.NAME = Convert.ToString(item["NAME"]); menuInfo.ORDERBY = new int?((!(item["ORDERBY"] is DBNull) ? Convert.ToInt32(item["ORDERBY"]) : -1)); menuInfo.PROGID = Convert.ToString(item["PROGID"]); menuInfo.SHORTCUT = Convert.ToString(item["SHORTCUT"]); menuInfo.SUBTYPE = new int?((!(item["SUBTYPE"] is DBNull) ? Convert.ToInt32(item["SUBTYPE"]) : -1)); menuInfo.VISIBLE = new bool?((!(item["VISIBLE"] is DBNull) ? Convert.ToInt32(item["VISIBLE"]) == 1 : true)); menuInfo.ItemCol = new int?((!(item["ItemCol"] is DBNull) ? Convert.ToInt32(item["ItemCol"]) : -1)); menuInfo.ISPOPMENUITEM = new bool?((!(item["ISPOPMENUITEM"] is DBNull) ? Convert.ToInt32(item["ISPOPMENUITEM"]) == 1 : false)); menuInfo.COMPONENTDLLNAME = Convert.ToString(item["COMPONENTDLLNAME"]); menuInfo.CLASSNAME = Convert.ToString(item["CLASSNAME"]); menuInfo.BEGINGROUP = new bool?((!(item["BEGINGROUP"] is DBNull) ? Convert.ToInt32(item["BEGINGROUP"]) == 1 : false)); menuInfo.CAPTION = Convert.ToString(item["CAPTION"]); menuInfo.PARENTIDS = Convert.ToString(item["PARENTIDS"]); } dataAccessLayer.Close(); return(menuInfo); }
public bool HasExist(string string2) { bool count = false; DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString); dataAccessLayer.Open(); string[] string0 = new string[] { "select * from ", this._tableName, " where id='", string2, "'" }; DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat(string0)); count = dataTable.Rows.Count > 0; dataAccessLayer.Close(); return(count); }
public bool IsExist(MenuInfo menuInfo_0) { string str = ""; str = (!string.IsNullOrEmpty(menuInfo_0.PROGID) ? string.Format("select * from {0} where PROGID='{1}' ", this.string_0, menuInfo_0.PROGID) : string.Format("select * from {0} where COMPONENTDLLNAME='{1}' and CLASSNAME='{2}'", this.string_0, menuInfo_0.COMPONENTDLLNAME, menuInfo_0.CLASSNAME)); DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable dataTable = dataAccessLayer.ExecuteDataTable(str); dataAccessLayer.Close(); return(dataTable.Rows.Count > 0); }
public bool ValidePassword(string string2, string string3) { bool flag; DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString); dataAccessLayer.Open(); string str = Regedit.EncryptTextNet(string3); string[] string0 = new string[] { "select * from ", this._tableName, " where ID='", string2, "' and PASSWORD = '******'" }; DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat(string0)); dataAccessLayer.Close(); flag = (dataTable.Rows.Count != 0 ? true : false); return(flag); }
public List <string> GetStaffIDs(string string_2) { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); string[] string0 = new string[] { "select * from ", this.string_0, " where ROLEID='", string_2, "'" }; DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat(string0)); List <string> strs = new List <string>(); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow item = dataTable.Rows[i]; ORGRole oRGRole = new ORGRole(); strs.Add(Convert.ToString(item["STAFFID"])); } dataAccessLayer.Close(); return(strs); }
public List <MenuInfo> Load() { List <MenuInfo> menuInfos = new List <MenuInfo>(); try { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat("select * from ", this.string_0)); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow item = dataTable.Rows[i]; MenuInfo menuInfo = new MenuInfo() { MenuID = Convert.ToString(item["MenuID"]), NAME = Convert.ToString(item["NAME"]) }; object obj = item["ORDERBY"]; menuInfo.ORDERBY = new int?((!(item["ORDERBY"] is DBNull) ? Convert.ToInt32(item["ORDERBY"]) : -1)); menuInfo.PROGID = Convert.ToString(item["PROGID"]); menuInfo.SHORTCUT = Convert.ToString(item["SHORTCUT"]); menuInfo.SUBTYPE = new int?((!(item["SUBTYPE"] is DBNull) ? Convert.ToInt32(item["SUBTYPE"]) : -1)); menuInfo.VISIBLE = new bool?((!(item["VISIBLE"] is DBNull) ? Convert.ToInt32(item["VISIBLE"]) == 1 : true)); menuInfo.ItemCol = new int?((!(item["ItemCol"] is DBNull) ? Convert.ToInt32(item["ItemCol"]) : -1)); menuInfo.ISPOPMENUITEM = new bool?((!(item["ISPOPMENUITEM"] is DBNull) ? Convert.ToInt32(item["ISPOPMENUITEM"]) == 1 : false)); menuInfo.COMPONENTDLLNAME = Convert.ToString(item["COMPONENTDLLNAME"]); menuInfo.CLASSNAME = Convert.ToString(item["CLASSNAME"]); menuInfo.PARENTIDS = Convert.ToString(item["PARENTIDS"]); menuInfo.BEGINGROUP = new bool?((!(item["BEGINGROUP"] is DBNull) ? Convert.ToInt32(item["BEGINGROUP"]) == 1 : false)); menuInfo.CAPTION = Convert.ToString(item["CAPTION"]); menuInfos.Add(menuInfo); } dataAccessLayer.Close(); } catch { } return(menuInfos); }
public List <ORGRole> Load() { List <ORGRole> oRGRoles = new List <ORGRole>(); DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat("select * from ", this.string_0)); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow item = dataTable.Rows[i]; ORGRole oRGRole = new ORGRole() { RoleID = Convert.ToString(item["ROLEID"]), RoleName = Convert.ToString(item["ROLENAME"]), DESCRIPT = Convert.ToString(item["DESCRIPT"]) }; oRGRoles.Add(oRGRole); } dataAccessLayer.Close(); return(oRGRoles); }
public Staff Load(string string2) { DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString); dataAccessLayer.Open(); string[] string0 = new string[] { "select * from ", this._tableName, " where ID='", string2, "'" }; DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat(string0)); Staff staff = null; if (dataTable.Rows.Count > 0) { DataRow item = dataTable.Rows[0]; staff = new Staff() { StaffID = Convert.ToString(item["ID"]), LoginName = Convert.ToString(item["ID"]), RealName = Convert.ToString(item["NAME"]), Password = Regedit.DecryptTextNet(Convert.ToString(item["PASSWORD"])) }; } dataAccessLayer.Close(); return(staff); }
public List <Staff> Load() { List <Staff> staffs = new List <Staff>(); DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString); dataAccessLayer.Open(); DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat("select * from ", this._tableName)); for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow item = dataTable.Rows[i]; Staff staff = new Staff() { StaffID = Convert.ToString(item["ID"]), LoginName = Convert.ToString(item["ID"]), RealName = Convert.ToString(item["NAME"]), Password = Regedit.DecryptTextNet(Convert.ToString(item["PASSWORD"])) }; staffs.Add(staff); } dataAccessLayer.Close(); return(staffs); }
public ORGRole GetRole(string string_2) { ORGRole oRGRole = null; List <ORGRole> oRGRoles = new List <ORGRole>(); DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); string[] string0 = new string[] { "select * from ", this.string_0, " where ROLEID='", string_2, "'" }; DataTable dataTable = dataAccessLayer.ExecuteDataTable(string.Concat(string0)); if (dataTable.Rows.Count > 0) { DataRow item = dataTable.Rows[0]; oRGRole = new ORGRole() { RoleID = Convert.ToString(item["ROLEID"]), RoleName = Convert.ToString(item["ROLENAME"]), DESCRIPT = Convert.ToString(item["DESCRIPT"]) }; } dataAccessLayer.Close(); return(oRGRole); }