public void Add(ORGRole orgrole_0) { object[] string0 = new object[] { this.string_0, orgrole_0.RoleID, orgrole_0.RoleName, orgrole_0.DESCRIPT }; string str = string.Format("insert into {0}([RoleID],[RoleName],[DESCRIPT],ROLETYPE) values('{1}','{2}','{3}','100')", string0); DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1); dataAccessLayer.Open(); dataAccessLayer.ExecuteNonQuery(CommandType.Text, str); dataAccessLayer.Close(); }
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 <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 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); }