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