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