private void SetData(ProductTypeSearchData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.txtCode.Text = data.CODE.Trim();
this.chkActive.Checked = (data.ACTIVE == Constz.ActiveStatus.Active);
this.txtName.Text = data.NAME.Trim();
this.rbtIsType.SelectedValue = data.TYPE;
}
private ProductTypeSearchData GetData()
{
ProductTypeSearchData data = new ProductTypeSearchData();
data.ACTIVE = (this.chkActive.Checked ? Constz.ActiveStatus.Active : Constz.ActiveStatus.InActive);
data.CODE = this.txtCode.Text.Trim();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.NAME = this.txtName.Text.Trim();
data.TYPE = this.rbtIsType.SelectedItem.Value.Trim();
return data;
}
public ProductTypeSearchData GetData(double loid)
{
ProductTypeSearchData data = new ProductTypeSearchData();
if (DALObj.GetDataByLOID(loid, null))
{
data.ACTIVE = DALObj.ACTIVE;
data.CODE = DALObj.CODE;
data.LOID = DALObj.LOID;
data.NAME = DALObj.NAME;
data.TYPE = DALObj.TYPE;
}
return data;
}
private bool VeridateData(ProductTypeSearchData data)
{
bool ret = true;
if (data.CODE.Trim() == "")
{
ret = false;
_error = "¡ÃسÒÃкØÃËÑÊ»ÃÐàÀ·ÊÔ¹¤éÒ";
}
else if (data.NAME.Trim() == "")
{
ret = false;
_error = "¡ÃسÒÃкت×èÍ»ÃÐàÀ·ÊÔ¹¤éÒ";
}
return ret;
}
public bool UpdateData(string userID, ProductTypeSearchData data)
{
bool ret = true;
if (VeridateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
DALObj.LOID = data.LOID;
DALObj.NAME = data.NAME.Trim();
DALObj.ACTIVE = data.ACTIVE.Trim();
DALObj.CODE = data.CODE.Trim();
DALObj.TYPE = data.TYPE.Trim();
int check = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT( *) FROM PRODUCTTYPE WHERE CODE ='" + data.CODE.Trim() + "' AND LOID != " + data.LOID));
int check1 = Convert.ToInt32(OracleDB.ExecSingleCmd("SELECT COUNT( *) FROM PRODUCTTYPE WHERE NAME ='" + data.NAME.Trim() + "' AND LOID != " + data.LOID));
if (check > 0)
{
// «éÓ
ret = false;
_error = "ÃËÑÊ»ÃÐàÀ·ÊÔ¹¤éÒ«éÓ";
}
else if (check1 > 0)
{
ret = false;
_error = "ª×èÍ»ÃÐàÀ·ÊÔ¹¤éÒÁÕÍÂÙèáÅéÇ";
}
else
{
// äÁè«éÓ ·Ó¡Òà insert
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, obj.zTrans);
else
ret = DALObj.InsertCurrentData(userID, obj.zTrans);
_LOID = DALObj.LOID;
if (ret)
{
obj.zTrans.Commit();
obj.CloseConnection();
}
else
{
throw new ApplicationException(DALObj.ErrorMessage);
}
}
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
}
else ret = false;
return ret;
}
