public int delete(int id)
{
AbstractCommonData entity = new LetterNumberPatternEntity();
string delQuery = "delete from " + entity.TableName + " where " + LetterEntity.indexField + "=" + provider.getSQLString(id);
return(provider.delete(delQuery));
}
private void fillCombo()
{
UsersEntity entity = _usersBs.getMasterUsers();
//کاربران اصلی را در کاکبو لیست می کند
for (int i = 0; i < entity.Tables[entity.FilledTableName].Rows.Count; i++)
{
string name = entity.get(i, UsersEntity.FIELD_NAME).ToString() + " " +
entity.get(i, UsersEntity.FIELD_FAMILY).ToString() + "(" + entity.get(i, UsersEntity.FIELD_USERNAME).ToString() + ")";
int masterUserId = int.Parse(entity.get(i, UsersEntity.FIELD_ID).ToString());
ComboBoxItem item = new ComboBoxItem();
item.Text = name;
item.Value = masterUserId.ToString();
}
//الگو ها را لیست می کند
LetterNumberPatternBL letPatt = new LetterNumberPatternBL();
LetterNumberPatternEntity pEntity = letPatt.get();
for (int i = 0; i < pEntity.Tables[pEntity.FilledTableName].Rows.Count; i++)
{
string name = pEntity.get(i, LetterNumberPatternEntity.FIELD_PATTERN_NAME).ToString();
string id = pEntity.get(i, LetterNumberPatternEntity.FIELD_ID).ToString();
ComboBoxItem item = new ComboBoxItem();
item.Text = name;
item.Value = id;
cmbLetterPattern.Items.Add(item);
}
}
public LetterNumberPatternEntity get()
{
LetterNumberPatternEntity entity = new LetterNumberPatternEntity();
provider.loadToDataSet(entity, "");
return(entity);
}
public LetterNumberPatternEntity getOralPattern()
{
LetterNumberPatternEntity entity = new LetterNumberPatternEntity();
string cond = LetterNumberPatternEntity.FIELD_SYSTEMNAME + "=" + "'oral'";
provider.loadToDataSet(entity, cond);
return(entity);
}
public LetterNumberPatternEntity getById(int id)
{
LetterNumberPatternEntity entity = new LetterNumberPatternEntity();
string cond = LetterNumberPatternEntity.FIELD_ID + "=" + provider.getSQLString(id);
provider.loadToDataSet(entity, cond);
return(entity);
}
private void fillGrid()
{
LetterNumberPatternEntity entity = null;
entity = _letterNumberPatternBL.get();
System.Collections.Hashtable hash = new Hashtable();
_gridTools.bindDataToGrid(dataGridView1, entity, null, hash);
}
public string[] GenerateOralSendLetterNumber()
{
LetterNumberPatternEntity entity = getOralPattern();
if (entity.Tables[entity.FilledTableName].Rows.Count <= 0)
{
throw new Exception("الگوی نامه شفاهی تعریف نشده است ، لطفا مسئول سیستم تماس بگیرید");
}
String pattern = entity.get(LetterNumberPatternEntity.FIELD_SEND_PATTERN).ToString();
string lastNum = entity.get(LetterNumberPatternEntity.FIELD_LASTNUMBER_SEND).ToString();
DateTime registerDate = (DateTime)entity.get(LetterNumberPatternEntity.FIELD_REGISTER_DATE);
int resetBy = (int)entity.get(LetterNumberPatternEntity.FIELD_RESETBY);
return(GenerateLetterNumber(pattern, lastNum, registerDate, resetBy));
}
private void loadLastPattern()
{
_entity = _letterNumberPatternBL.getById(_id);
int count = _entity.Tables[_entity.FilledTableName].Rows.Count;
if (count > 0)
{
txtRecievePattern.Text = _entity.get(0, LetterNumberPatternEntity.FIELD_RECIEVE_PATTERN).ToString();
txtSendPattern.Text = _entity.get(0, LetterNumberPatternEntity.FIELD_SEND_PATTERN).ToString();
setReset((int)_entity.get(0, LetterNumberPatternEntity.FIELD_RESETBY));
txtLastNumbeRecieve.Text = _entity.get(0, LetterNumberPatternEntity.FIELD_LASTNUMBER_RECIEVE).ToString();
txtLastNumbeSend.Text = _entity.get(0, LetterNumberPatternEntity.FIELD_LASTNUMBER_SEND).ToString();
txtPatternName.Text = _entity.get(0, LetterNumberPatternEntity.FIELD_PATTERN_NAME).ToString();
}
else
{
_entity = null;
rdoBtnNone.Checked = true;
txtLastNumbeRecieve.Text = "0";
}
}
public string[] GenerateNewRecieveLetterNumber()
{
string pId = UsersBS.loginedUser.get(UsersEntity.FIELD_LETTER_PATTERN_ID).ToString();
if (pId == null || pId.Equals("") || pId.Length <= 0)
{
throw new Exception("برای این کاربر الگوی تولید شماره نامه تعیین نشده است");
}
LetterNumberPatternEntity entity = getById(int.Parse(pId));
if (entity.Tables[entity.FilledTableName].Rows.Count <= 0)
{
throw new Exception("الگویی برای شماره نامه تعریف نشده است! \n بدون شماره نامه امکان ثبت نامه وجود ندارد");
}
String pattern = entity.get(LetterNumberPatternEntity.FIELD_RECIEVE_PATTERN).ToString();
string lastNum = entity.get(LetterNumberPatternEntity.FIELD_LASTNUMBER_RECIEVE).ToString();
DateTime registerDate = (DateTime)entity.get(LetterNumberPatternEntity.FIELD_REGISTER_DATE);
int resetBy = (int)entity.get(LetterNumberPatternEntity.FIELD_RESETBY);
return(GenerateLetterNumber(pattern, lastNum, registerDate, resetBy));
}
public int update(LetterNumberPatternEntity entity)
{
return(provider.update(entity));
}
public int add(LetterNumberPatternEntity entity)
{
return(provider.add(entity));
}
private void btnSave_Click(object sender, EventArgs e)
{
bool b = checkData();
if (!b)
{
return;
}
DataRow dr = null;
bool newRow = false;
LetterNumberPatternEntity entity = new LetterNumberPatternEntity();
dr = entity.Tables[entity.TableName].NewRow();
if (_id < 0)
{
newRow = true;
}
dr[LetterNumberPatternEntity.FIELD_RECIEVE_PATTERN] = txtRecievePattern.Text;
dr[LetterNumberPatternEntity.FIELD_SEND_PATTERN] = txtSendPattern.Text;
dr[LetterNumberPatternEntity.FIELD_REGISTER_DATE] = DateTime.Now;
dr[LetterNumberPatternEntity.FIELD_RESETBY] = resetByRadionBtn();
dr[LetterNumberPatternEntity.FIELD_LASTNUMBER_RECIEVE] = txtLastNumbeRecieve.Text;
dr[LetterNumberPatternEntity.FIELD_LASTNUMBER_SEND] = txtLastNumbeSend.Text;
dr[LetterNumberPatternEntity.FIELD_PATTERN_NAME] = txtPatternName.Text;
if (_entity == null)
{
dr[LetterNumberPatternEntity.FIELD_CANSET] = true;
}
else
{
object canset = _entity.get(LetterNumberPatternEntity.FIELD_CANSET);
if (canset != null && canset.ToString().Length > 0)
{
dr[LetterNumberPatternEntity.FIELD_CANSET] = _entity.get(LetterNumberPatternEntity.FIELD_CANSET);
}
else
{
dr[LetterNumberPatternEntity.FIELD_CANSET] = true;
}
object systemName = _entity.get(LetterNumberPatternEntity.FIELD_SYSTEMNAME);
if (systemName != null && systemName.ToString().Length > 0)
{
dr[LetterNumberPatternEntity.FIELD_SYSTEMNAME] = _entity.get(LetterNumberPatternEntity.FIELD_SYSTEMNAME);
}
}
if (!newRow)
{
dr[LetterNumberPatternEntity.FIELD_ID] = _entity.get(LetterNumberPatternEntity.FIELD_ID);
}
entity.Tables[entity.TableName].Rows.Add(dr);
if (newRow)
{
lblMsg.Text = "دخیره شده";
_id = _letterNumberPatternBL.add(entity);
_entity = _letterNumberPatternBL.get();
}
else
{
_letterNumberPatternBL.update(entity);
lblMsg.Text = "به روز گردید";
}
this.Close();
}
public int update(LetterNumberPatternEntity entity)
{
return(((LetterNumberPatternDA)_abstractDA).update(entity));
}
public int add(LetterNumberPatternEntity entity)
{
return(((LetterNumberPatternDA)_abstractDA).add(entity));
}
