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