public int delete(int id) { AbstractCommonData entity = new LetterStateEntity(); string delQuery = "DELETE FROM " + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(id); return(provider.delete(delQuery)); }
private void loadData() { _entity = _letterStateBL.get(_letterid); if (_entity == null) { return; } txtCompany.Text = CompanyName1; if (_entity.RowCount() > 0) { _mode = Constants.EDIT_MODE; txtDate.Text = RMX_TOOLS.date.DateXFormer.gregorianToPersianString((DateTime)_entity.get(LetterStateEntity.FIELD_DATE)); txtNumber.Text = _entity.get(LetterStateEntity.FIELD_NUMBER).ToString(); txtDescription.Text = _entity.get(LetterStateEntity.FIELD_DESCRIPTION).ToString(); } else { _mode = Constants.ADD_MODE; //_entity = null; } // txtCompany.Tag = 0; // if (_entity.get(LetterEntity.FIELD_COMPANY_ID).ToString().Length > 0) // { // txtCompany.Tag = (int)_entity.get(LetterEntity.FIELD_COMPANY_ID); // txtCompany.Text = CompanyBL.getCompanyName((int)txtCompany.Tag); // } }
public LetterStateEntity get(int letterId) { LetterStateEntity entity = new LetterStateEntity(); string cond = LetterStateEntity.FIELD_LETTERID + "=" + provider.getSQLString(letterId); provider.loadToDataSet(entity, cond); return(entity); }
private void btnSave_Click(object sender, EventArgs e) { if (!BeforSave()) { return; } DataRow dr; if (_mode.Equals(Constants.ADD_MODE)) { _entity = new LetterStateEntity(); dr = _entity.Tables[_entity.TableName].NewRow(); } else { if (_entity.FilledTableName == "") { _entity.FilledTableName = _entity.TableName; } dr = _entity.Tables[_entity.FilledTableName].Rows[0]; } DateConverter dateConverter = new DateConverter(); dr[LetterStateEntity.FIELD_USERID] = _userid; dr[LetterStateEntity.FIELD_LETTERID] = _letterid; dr[LetterStateEntity.FIELD_DATE] = dateConverter.stringToValue(txtDate.Text); dr[LetterStateEntity.FIELD_NUMBER] = txtNumber.Text; dr[LetterStateEntity.FIELD_DESCRIPTION] = txtDescription.Text; //dr[LetterStateEntity.FIELD_COMPANYID] = txtCompany.Tag; if (_mode.Equals(Constants.ADD_MODE)) { _entity.Tables[_entity.TableName].Rows.Add(dr); _letterStateBL.add(_entity); lblMsg.Text = "دخیره گردید"; _mode = Constants.EDIT_MODE; } else { _letterStateBL.update(_entity); lblMsg.Text = "تغییرات به روز رسانی گردید"; } }
public int update(LetterStateEntity entity) { return(provider.update(entity)); }
public int add(LetterStateEntity entity) { return(provider.add(entity)); }
public int update(LetterStateEntity entity) { return(((LetterStateDA)_abstractDA).update(entity)); }
public int add(LetterStateEntity entity) { return(((LetterStateDA)_abstractDA).add(entity)); }