public ChequeReplyEntity get(string cond)
{
ChequeReplyEntity entity = new ChequeReplyEntity();
provider.loadToDataSet(entity, cond);
return(entity);
}
public int delete(int id)
{
AbstractCommonData entity = new ChequeReplyEntity();
string delQuery = "DELETE FROM " + entity.TableName + " where " + entity.IndexFieldName + "=" + provider.getSQLString(id);
return(provider.delete(delQuery));
}
public ChequeReplyEntity get(int id)
{
ChequeReplyEntity entity = new ChequeReplyEntity();
string cond = ChequeReplyEntity.FIELD_ID + "=" + provider.getSQLString(id);
provider.loadToDataSet(entity, cond);
return(entity);
}
public ChequeReplyEntity get()
{
ChequeReplyEntity entity = new ChequeReplyEntity();
//string cond = ChequeReplyEntity.FIELD_LETTER_TYPE + "=" + provider.getSQLString(letterType);
provider.loadToDataSet(entity);
return(entity);
}
public ChequeReplyEntity getByCheque(int chequeid, string cond)
{
ChequeReplyEntity entity = new ChequeReplyEntity();
if (cond == null || cond.Length == 0)
{
cond = ChequeReplyEntity.FIELD_CHEQUEID + "=" + provider.getSQLString(chequeid);
}
else
{
cond += " AND " + ChequeReplyEntity.FIELD_CHEQUEID + "=" + provider.getSQLString(chequeid);
}
provider.loadToDataSet(entity, cond);
return(entity);
}
private void checkColorOFCheque()
{
ChequeReplyEntity en = _chequeReplyBL.getByCheque(_id, "");
if (en.Tables[en.FilledTableName].Rows.Count > 0)
{
_chequeBL.updateColor(_id, "");
}
else
{
ApplicationPropertiesBL appPropertiesBL = new ApplicationPropertiesBL();
string color = appPropertiesBL.getValue(ApplicationPropertiesBL.CHEQUE_WITHNO_REPLY);
_chequeBL.updateColor(_id, color);
}
}
private void fillGrid(string cond)
{
ChequeReplyEntity entity = null;
entity = _chequeReplyBL.getByCheque(_id, cond);
int count = entity.RowCount();
tblReply.Height = 70 + count * 20;
System.Collections.Hashtable hash = new Hashtable();
if (_gridTools == null)
{
_gridTools = new GridTools();
}
_gridTools.bindDataToGrid(dataGridView1, entity, null, hash);
}
public void initForm()
{
if (_id > 0)
{
ChequeReplyEntity entity = _chequeReplyBL.get(_id);
DateConverter converter = new DateConverter();
txtRecieptBillNumber.Text = entity.get(ChequeReplyEntity.FIELD_RECIEPTBILLNUMBER).ToString();
txtIssueDate.Text = converter.valueToString(entity.get(ChequeReplyEntity.FIELD_ISSUEDATE));
txtPrice.Text = entity.get(ChequeReplyEntity.FIELD_PRICE).ToString();
txtDescription.Text = entity.get(ChequeReplyEntity.FIELD_DESCRIPTION).ToString();
}
if (_id < 0)
{
linkAttachment.Visible = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!BeforSave())
{
return;
}
DateConverter dateconverter = new DateConverter();
ChequeReplyEntity entity = new ChequeReplyEntity();
DataRow dr = entity.Tables[entity.TableName].NewRow();
if (_id > 0)
{
dr[ChequeReplyEntity.FIELD_ID] = _id;
}
dr[ChequeReplyEntity.FIELD_RECIEPTBILLNUMBER] = txtRecieptBillNumber.Text;
dr[ChequeReplyEntity.FIELD_ISSUEDATE] = dateconverter.stringToValue(txtIssueDate.Text);
dr[ChequeReplyEntity.FIELD_CHEQUEID] = _chequeId;
dr[ChequeReplyEntity.FIELD_PRICE] = txtPrice.Text;
dr[ChequeReplyEntity.FIELD_DESCRIPTION] = txtDescription.Text;
entity.Tables[entity.TableName].Rows.Add(dr);
if (_id < 0)
{
_id = _chequeReplyBL.add(entity);
lblMsg.Text = "دخیره شده ";
}
else
{
_chequeReplyBL.update(entity);
lblMsg.Text = "به روز رسانی گردید.";
}
this.Close();
}
public int update(ChequeReplyEntity entity)
{
return(((ChequeReplyDA)_abstractDA).update(entity));
}
public int add(ChequeReplyEntity entity)
{
return(((ChequeReplyDA)_abstractDA).add(entity));
}
public int update(ChequeReplyEntity entity)
{
return(provider.update(entity));
}
public int add(ChequeReplyEntity entity)
{
return(provider.add(entity));
}
