public int deleteByUser(int userid) { AbstractCommonData entity = new LetterItemsPermissionEntity(); string delQuery = "DELETE FROM " + entity.TableName + " WHERE " + LetterItemsPermissionEntity.FIELD_USER_ID + "=" + provider.getSQLString(userid); return(provider.delete(delQuery)); }
public LetterItemsPermissionEntity getByUser(int userid) { LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity(); string cond = LetterItemsPermissionEntity.FIELD_USER_ID + "=" + provider.getSQLString(userid); provider.loadToDataSet(entity, cond); return(entity); }
public LetterItemsPermissionEntity getByTableindex(int tableindex) { LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity(); string cond = LetterItemsPermissionEntity.FIELD_ID + "=" + provider.getSQLString(tableindex); provider.loadToDataSet(entity, cond); return(entity); }
private void btnSave_Click(object sender, EventArgs e) { LetterItemsPermissionEntity entity = new LetterItemsPermissionEntity(); DataRow dr = entity.Tables[entity.TableName].NewRow(); if (_userid > 0) { dr[LetterItemsPermissionEntity.FIELD_USER_ID] = _userid; dr[LetterItemsPermissionEntity.FIELD_ID] = _tableIndex; dr[LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER] = cbRecievedLetterNumber.Checked; dr[LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERDATE] = cbRecievedLetterDate.Checked; dr[LetterItemsPermissionEntity.FIELD_INPUT_REGISTER_NUMBER] = cbInputRegisterNumber.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_SEARCH] = cbBtnSearch.Checked; dr[LetterItemsPermissionEntity.FIELD_LETTER_SUBJECT] = cbLetterSubject.Checked; dr[LetterItemsPermissionEntity.FIELD_LETTER_SUMMARY] = cbSummary.Checked; dr[LetterItemsPermissionEntity.FIELD_COMPANY_ID] = cbCmbCompanyId.Checked; dr[LetterItemsPermissionEntity.FIELD_INSURANCE_TYPE_ID] = cbCmbInsuranceType.Checked; dr[LetterItemsPermissionEntity.FIELD_MANAGEMENT_ACTION] = cbCmbManagemtAction.Checked; dr[LetterItemsPermissionEntity.FIELD_INSURANCE_DATE] = cbInsuranceDate.Checked; dr[LetterItemsPermissionEntity.FIELD_INSURANCE_NUMBER] = cbCmbInsuranceNumber.Checked; dr[LetterItemsPermissionEntity.FIELD_LETTER_STATE_ID] = cbCmbLetterStateId.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_LETTER_STATE] = cbBtnLetterState.Checked; dr[LetterItemsPermissionEntity.FIELD_REFERENCED_USER_ID] = cbCmbReferenceUserId.Checked; dr[LetterItemsPermissionEntity.FIELD_ARCHIVE] = cbCbArchive.Checked; dr[LetterItemsPermissionEntity.FIELD_FINAL_CONFIRM] = cbCbFinalConfirm.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_USERS_REPLIES] = cbBtnUsersReplies.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_REFER_TO_MASTER] = cbRefertoMaster.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_SHOW_REFFRENCES] = cbShowReffrences.Checked; dr[LetterItemsPermissionEntity.FIELD_ALARM_STARTDATE] = cbAlarmStartDate.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_AGENT] = cbAgent.Checked; dr[LetterItemsPermissionEntity.FIELD_DELETE_LETTER] = cbDeleteLetter.Checked; dr[LetterItemsPermissionEntity.FIELD_FASTACTION] = cbCbFastAction.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_RECIEVE] = cbDoChainingToRecieve.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_SEND] = cbDoChainingToSend.Checked; dr[LetterItemsPermissionEntity.FIELD_BTN_SEPERATE_CHANING] = cbSeperateFromChain.Checked; dr[LetterItemsPermissionEntity.FIELD_INSURANCE_COMPANY] = cbInsuranceCompany.Checked; entity.Tables[entity.TableName].Rows.Add(dr); if (_tableIndex < 0) { _tableIndex = _letterItemPermBL.addPermission(entity); } else { _letterItemPermBL.update(entity); } lblMsg.Text = "تغییرات ثبت گردید"; } }
private void doPermision() { //permision if (UsersBS.ADMIN.ToString().Equals(UsersBS.loginedUser.get(UsersEntity.FIELD_USER_TYPE).ToString())) { return; } int userid = int.Parse(UsersBS.loginedUser.get(UsersEntity.FIELD_ID).ToString()); LetterItemsPermissionBL letItemPerm = new LetterItemsPermissionBL(); LetterItemsPermissionEntity entity = letItemPerm.getByUser(userid); doPerm(btnDelete, entity.get(LetterItemsPermissionEntity.FIELD_DELETE_LETTER)); }
public void load() { _letterItemPermBL = new LetterItemsPermissionBL(); LetterItemsPermissionEntity entity = _letterItemPermBL.getByUser(_userid); if (entity.Tables[entity.FilledTableName].Rows.Count <= 0) { setAllUnchecked(); return; } _tableIndex = int.Parse(entity.get(LetterItemsPermissionEntity.FIELD_ID).ToString()); doItem(entity, LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER, txtRecievedLetterNumber); doItem(entity, LetterItemsPermissionEntity.FIELD_RECIEVEDLETTERNUMBER, txtRecievedLetterDate); doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_SUBJECT, txtLetterSubject); doItem(entity, LetterItemsPermissionEntity.FIELD_INPUT_REGISTER_NUMBER, txtInputRegisterNumber); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SEARCH, btnSearch); doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_SUMMARY, txtSummary); doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_TYPE_ID, cmbInsuranceType); doItem(entity, LetterItemsPermissionEntity.FIELD_MANAGEMENT_ACTION, cmbManagemtAction); doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_DATE, txtInsuranceDate); doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_NUMBER, txtInsuranceNumber); doItem(entity, LetterItemsPermissionEntity.FIELD_COMPANY_ID, cmbCompanyId); doItem(entity, LetterItemsPermissionEntity.FIELD_LETTER_STATE_ID, cmbLetterStateId); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_LETTER_STATE, btnLetterState); doItem(entity, LetterItemsPermissionEntity.FIELD_REFERENCED_USER_ID, cmbReferenceUserId); doItem(entity, LetterItemsPermissionEntity.FIELD_ARCHIVE, cbCbArchive); doItem(entity, LetterItemsPermissionEntity.FIELD_FINAL_CONFIRM, cbCbFinalConfirm); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_USERS_REPLIES, btnUsersReplies); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_REFER_TO_MASTER, btnReferToMasterUSer); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SHOW_REFFRENCES, btnShowRefrences); doItem(entity, LetterItemsPermissionEntity.FIELD_ALARM_STARTDATE, txtRefferDate); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_AGENT, btnAgent); doItem(entity, LetterItemsPermissionEntity.FIELD_DELETE_LETTER, btnDelete); doItem(entity, LetterItemsPermissionEntity.FIELD_FASTACTION, cbCbFastAction); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_RECIEVE, btnDoChainingToRecive); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_DO_CHANING_TO_SEND, btnDoChainingToSend); doItem(entity, LetterItemsPermissionEntity.FIELD_BTN_SEPERATE_CHANING, btnSeperateFromChain); doItem(entity, LetterItemsPermissionEntity.FIELD_INSURANCE_COMPANY, cmbInsuranceCompany); }
private void doItem(LetterItemsPermissionEntity entity, string fld, Control item) { bool b = false; if (entity.get(fld).ToString().Length <= 0) { b = false; } else { b = bool.Parse(entity.get(fld).ToString()); } if (b) { checkItem(item); } else { UncheckItem(item); } }
public int update(LetterItemsPermissionEntity entity) { return(provider.update(entity)); }
public int addPermission(LetterItemsPermissionEntity entity) { return(provider.add(entity)); }
public int update(LetterItemsPermissionEntity entity) { return(((LetterItemsPermissionDA)_abstractDA).update(entity)); }
public int addPermission(LetterItemsPermissionEntity entity) { return(((LetterItemsPermissionDA)_abstractDA).addPermission(entity)); }