private DivisionData GetData()
{
DivisionData data = new DivisionData();
data.CODE = this.txtCode.Text.Trim();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.TNAME = this.txtName.Text.Trim();
data.EFDATE = this.ctlEFDate.DateValue;
data.ABBNAME = this.txtAbbName.Text.Trim();
data.DEPARTMENT = Convert.ToDouble(this.cmbDepartment.SelectedItem.Value);
return data;
}
private void SetData(DivisionData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.txtCode.Text = data.CODE.Trim();
this.txtName.Text = data.TNAME.Trim();
if (data.EFDATE.Year == 1)
this.ctlEFDate.DateValue = DateTime.Now.Date;
else
this.ctlEFDate.DateValue = data.EFDATE;
this.txtAbbName.Text = data.ABBNAME;
this.cmbDepartment.SelectedIndex = this.cmbDepartment.Items.IndexOf(this.cmbDepartment.Items.FindByValue(data.DEPARTMENT.ToString()));
}
public bool UpdateData(string userID, DivisionData data)
{
bool ret = true;
if (VeridateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
SearchDAL.GetDataByLOID(data.LOID, obj.zTrans);
SearchDAL.LOID = data.LOID;
SearchDAL.TNAME = data.TNAME.Trim();
SearchDAL.CODE = data.CODE.Trim();
SearchDAL.EFDATE = data.EFDATE;
SearchDAL.EPDATE = data.EPDATE;
SearchDAL.ABBNAME = data.ABBNAME;
SearchDAL.DEPARTMENT = data.DEPARTMENT;
if (SearchDAL.OnDB)
ret = SearchDAL.UpdateCurrentData(userID, obj.zTrans);
else
ret = SearchDAL.InsertCurrentData(userID, obj.zTrans);
_LOID = SearchDAL.LOID;
if (ret)
{
obj.zTrans.Commit();
obj.CloseConnection();
}
else
{
_error = SearchDAL.ErrorMessage;
}
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
throw new ApplicationException(ex.Message);
}
}
else
ret = false;
return ret;
}
public DivisionData GetData(double loid)
{
DivisionData data = new DivisionData();
if (SearchDAL.GetDataByLOID(loid, null))
{
data.LOID = SearchDAL.LOID;
data.CODE = SearchDAL.CODE;
data.TNAME = SearchDAL.TNAME;
data.EFDATE = SearchDAL.EFDATE;
data.EPDATE = SearchDAL.EPDATE;
data.ABBNAME = SearchDAL.ABBNAME;
data.DEPARTMENT = SearchDAL.DEPARTMENT;
}
return data;
}
private bool VeridateData(DivisionData data)
{
bool ret = true;
if (data.CODE.Trim() == "")
{
_error = "°√Ў≥“√–ЇЎ√Ћ— љи“¬";
ret = false;
}
else if (data.TNAME.Trim() == "")
{
_error = "°√Ў≥“√–ЇЎ™„иЌј“…“дЈ¬";
ret = false;
}
else if (SearchDAL.CheckCode(data.LOID, data.CODE.Trim()) == false)
{
_error = "√Ћ— љи“¬є’йЅ’Ќ¬ўиб≈й«";
ret = false;
}
else if (SearchDAL.CheckName(data.LOID, data.TNAME.Trim()) == false)
{
_error = "™„иЌј“…“дЈ¬љи“¬є’йЅ’Ќ¬ўиб≈й«";
ret = false;
}
else if (SearchDAL.CheckAbbName(data.LOID, data.ABBNAME.Trim()) == false)
{
_error = "™„荬荚蓬є’йЅ’Ќ¬ўиб≈й«";
ret = false;
}
return ret;
}