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