public void DeleteByRoleID(string string_2)
{
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, string.Format("delete from {0} where ROLEID='{1}'", this.string_0, string_2));
dataAccessLayer.Close();
}
public void Update(MenuInfo menuInfo_0)
{
string str = string.Format("update {0} set PARENTIDS='{1}' where MenuID={2}", this.string_0, (string.IsNullOrEmpty(menuInfo_0.PARENTIDS) ? "NULL" : string.Concat("'", menuInfo_0.PARENTIDS, "'")), menuInfo_0.MenuID);
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, str);
dataAccessLayer.Close();
}
public void Add(string string_2, string string_3)
{
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1);
dataAccessLayer.Open();
string str = string.Format("insert into ORGSTAFFROLES(STAFFID,ROLEID) values('{0}', '{1}')", string_3, string_2);
dataAccessLayer.ExecuteNonQuery(CommandType.Text, str);
dataAccessLayer.Close();
}
public void Delete(string string2)
{
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, string.Format("delete from {0} where ID='{1}'", this._tableName, string2));
ORGStaffRoleHelper.DeleteByStaffID(dataAccessLayer, string2);
SysGrants.DeleteByStaffID(dataAccessLayer, string2);
dataAccessLayer.Close();
}
public void Add(Staff staff)
{
object[] string0 = new object[] { this._tableName, staff.StaffID, staff.RealName, Regedit.EncryptTextNet(staff.Password) };
string str = string.Format("insert into {0}([ID],[NAME],[PASSWORD]) values('{1}','{2}','{3}')", string0);
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, str);
dataAccessLayer.Close();
}
public void Update(Staff staff)
{
object[] string0 = new object[] { this._tableName, staff.RealName, Regedit.EncryptTextNet(staff.Password), staff.StaffID };
string str = string.Format("UPDATE {0} set [NAME]='{1}',[PASSWORD]='{2}' where ID='{3}'", string0);
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this._dataProviderType, this._connectionString);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, str);
dataAccessLayer.Close();
}
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 void ClearAll()
{
try
{
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(string.Concat("delete from ", this.string_0), new object[0]);
dataAccessLayer.Close();
}
catch
{
}
}
public static void DeleteByRoleID(DataAccessLayerBaseClass dataAccessLayerBaseClass_0, string string_2)
{
dataAccessLayerBaseClass_0.ExecuteNonQuery(CommandType.Text, string.Format("delete from ORGSTAFFROLES where ROLEID='{0}'", string_2));
}
public int Add(MenuInfo menuInfo_0)
{
int num;
int value;
object str;
object obj;
object obj1;
object str1;
object obj2;
object obj3;
if (!this.IsExist(menuInfo_0))
{
object[] string0 = new object[14];
string0[0] = this.string_0;
string0[1] = (string.IsNullOrEmpty(menuInfo_0.NAME) ? "NULL" : string.Concat("'", menuInfo_0.NAME, "'"));
string0[2] = (string.IsNullOrEmpty(menuInfo_0.PARENTIDS) ? "NULL" : string.Concat("'", menuInfo_0.PARENTIDS, "'"));
object[] objArray = string0;
if (menuInfo_0.ORDERBY.HasValue)
{
value = menuInfo_0.ORDERBY.Value;
str = value.ToString();
}
else
{
str = "NULL";
}
objArray[3] = str;
string0[4] = (string.IsNullOrEmpty(menuInfo_0.PROGID) ? "NULL" : string.Concat("'", menuInfo_0.PROGID, "'"));
string0[5] = (string.IsNullOrEmpty(menuInfo_0.SHORTCUT) ? "NULL" : string.Concat("'", menuInfo_0.SHORTCUT, "'"));
object[] objArray1 = string0;
if (menuInfo_0.SUBTYPE.HasValue)
{
value = menuInfo_0.SUBTYPE.Value;
obj = value.ToString();
}
else
{
obj = "NULL";
}
objArray1[6] = obj;
object[] objArray2 = string0;
if (menuInfo_0.VISIBLE.HasValue)
{
obj1 = (menuInfo_0.VISIBLE.Value ? "1" : "0");
}
else
{
obj1 = "NULL";
}
objArray2[7] = obj1;
object[] objArray3 = string0;
if (menuInfo_0.ItemCol.HasValue)
{
value = menuInfo_0.ItemCol.Value;
str1 = value.ToString();
}
else
{
str1 = "NULL";
}
objArray3[8] = str1;
object[] objArray4 = string0;
if (menuInfo_0.ISPOPMENUITEM.HasValue)
{
obj2 = (menuInfo_0.ISPOPMENUITEM.Value ? "1" : "0");
}
else
{
obj2 = "NULL";
}
objArray4[9] = obj2;
string0[10] = (string.IsNullOrEmpty(menuInfo_0.COMPONENTDLLNAME) ? "NULL" : string.Concat("'", menuInfo_0.COMPONENTDLLNAME, "'"));
string0[11] = (string.IsNullOrEmpty(menuInfo_0.CLASSNAME) ? "NULL" : string.Concat("'", menuInfo_0.CLASSNAME, "'"));
object[] objArray5 = string0;
if (menuInfo_0.BEGINGROUP.HasValue)
{
obj3 = (menuInfo_0.BEGINGROUP.Value ? "1" : "0");
}
else
{
obj3 = "NULL";
}
objArray5[12] = obj3;
string0[13] = (string.IsNullOrEmpty(menuInfo_0.CAPTION) ? "NULL" : string.Concat("'", menuInfo_0.CAPTION, "'"));
string str2 = string.Format("insert into {0}([NAME],PARENTIDS,ORDERBY,[PROGID],[SHORTCUT],SUBTYPE,VISIBLE,ItemCol,ISPOPMENUITEM,COMPONENTDLLNAME,CLASSNAME,BEGINGROUP,CAPTION) values({1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13})", string0);
DataAccessLayerBaseClass dataAccessLayer = DataAccessLayerFactory.GetDataAccessLayer(this.dataProviderType_0, this.string_1);
dataAccessLayer.Open();
dataAccessLayer.ExecuteNonQuery(CommandType.Text, str2);
dataAccessLayer.Close();
num = 0;
}
else
{
num = 0;
}
return(num);
}
