public bool UpdateData(string UserID, SupplierData supData)
{
Boolean ret = true;
SupplierDAL oDAL = new SupplierDAL();
oDAL.OnDB = false;
oDAL.GetDataByLOID(Convert.ToDouble(supData.LOID == "" ? "0" : supData.LOID), null);
SetDataToDAL(oDAL, supData);
if (oDAL.OnDB)
{
ret = oDAL.UpdateCurrentData(UserID, null);
}
else
{
ret = oDAL.InsertCurrentData(UserID, null);
}
if (ret == false)
_error = oDAL.ErrorMessage;
return ret;
}
private void SetDataToDAL(SupplierDAL oDAL, SupplierData supData)
{
oDAL.ACTIVE = supData.ACTIVE;
//-------------------- к╫ш═║├╘╔╤╖/╝┘щи╙╦╣ш╥┬ ---------------------------------------
oDAL.CODE = supData.CODE;
oDAL.SUPPLIERNAME = supData.SUPPLIERNAME;
oDAL.TAXID = supData.TAXID;
//-------------------- ╖╒ш═┬┘ш║├╘╔╤╖/╝┘щи╙╦╣ш╥┬ ---------------------------------------
oDAL.ADDRESS = supData.ADDRESS;
oDAL.ROAD = supData.ROAD;
oDAL.PROVINCE = supData.PROVINCE;
oDAL.AMPHUR = supData.AMPHUR;
oDAL.TAMBOL = supData.TAMBOL;
oDAL.ZIPCODE = supData.ZIPCODE;
oDAL.TEL = supData.TEL;
oDAL.FAX = supData.FAX;
oDAL.EMAIL = supData.EMAIL;
//-------------------- к╫ш═╝┘щ╡╘┤╡ш═ ---------------------------------------
oDAL.CTITLE = supData.CTITLE;
oDAL.CNAME = supData.CNAME;
oDAL.CLASTNAME = supData.CLASTNAME;
oDAL.CTEL = supData.CTEL;
oDAL.CMOBILE = supData.CMOBILE;
oDAL.CEMAIL = supData.CEMAIL;
oDAL.CADDRESS = supData.CADDRESS;
oDAL.CROAD = supData.CROAD;
oDAL.CPROVINCE = supData.CPROVINCE;
oDAL.CAMPHUR = supData.CAMPHUR;
oDAL.CTAMBOL = supData.CTAMBOL;
oDAL.CZIPCODE = supData.CZIPCODE;
//-------------------- ╦┴╥┬р╦╡╪ ---------------------------------------
oDAL.REMARK = supData.REMARK;
}
private void GetData(SupplierData supData)
{
//-------------------- ª×èͺÃÔÉÑ·/¼Ùé¨Ó˹èÒ ---------------------------------------
supData.LOID = txtLOID.Text;
supData.CODE = txtCode.Text.Trim();
supData.TAXID = txtTaxNumber.Text.Trim();
supData.SUPPLIERNAME = txtSupplierName.Text.Trim();
supData.ACTIVE = (chkActive.Checked ? Constz.ActiveStatus.Active : Constz.ActiveStatus.InActive);
//-------------------- ·ÕèÍÂÙèºÃÔÉÑ·/¼Ùé¨Ó˹èÒ ---------------------------------------
supData.ADDRESS = txtSupAddress.Text.Trim();
supData.ROAD = txtSupRoad.Text.Trim();
supData.PROVINCE = Convert.ToDouble(cmbSupProvince.SelectedItem.Value);
supData.AMPHUR = Convert.ToDouble(cmbSupAmphur.SelectedItem.Value);
supData.TAMBOL = Convert.ToDouble(cmbSupDistrict.SelectedItem.Value);
supData.ZIPCODE = txtSupZipCode.Text.Trim();
supData.TEL = txtSupTel.Text.Trim();
supData.FAX = txtSupFax.Text.Trim();
supData.EMAIL = txtSupEmail.Text.Trim();
//-------------------- ª×èͼÙéµÔ´µèÍ ---------------------------------------
supData.CTITLE = Convert.ToDouble(cmbCTitle.SelectedItem.Value);
supData.CNAME = txtContactFirstname.Text.Trim();
supData.CLASTNAME = txtContactLastname.Text.Trim();
supData.CTEL = txtContactTel.Text.Trim();
supData.CMOBILE = txtContactMobile.Text.Trim();
supData.CEMAIL = txtContactEmail.Text.Trim();
supData.CADDRESS = txtContactAddress.Text.Trim();
supData.CROAD = txtContactRoad.Text.Trim();
supData.CPROVINCE = Convert.ToDouble(cmbContactProvince.SelectedItem.Value);
supData.CAMPHUR = Convert.ToDouble(cmbContactAmphur.SelectedItem.Value);
supData.CTAMBOL = Convert.ToDouble(cmbContactDistrict.SelectedItem.Value);
supData.CZIPCODE = txtContactZipCode.Text.Trim();
//-------------------- ËÁÒÂà赯 ---------------------------------------
supData.REMARK = txtRemark.Text.Trim();
}
//public bool NewRequisition(string userID, ProductReturnData data)
//{
// bool ret = true;
// OracleDBObj obj = new OracleDBObj();
// obj.CreateConnection();
// obj.CreateTransaction();
// try
// {
// DALObj.CODE = data.CODE;
// DALObj.DELIVERYDATE = data.DELIVERYDATE;
// DALObj.TYPE = data.TYPE;
// DALObj.CARNO = data.CARNO;
// DALObj.DELIVERYNAME = data.DELIVERYNAME;
// ret = DALObj.InsertCurrentData(userID, obj.zTrans);
// _LOID = DALObj.LOID;
// if (!ret)
// {
// throw new ApplicationException(DALObj.ErrorMessage);
// }
// obj.zTrans.Commit();
// obj.CloseConnection();
// }
// catch (Exception ex)
// {
// obj.zTrans.Rollback();
// obj.CloseConnection();
// ret = false;
// _error = ex.Message;
// }
// return ret;
//}
public SupplierData GetSupplierData(double supplier)
{
SupplierDAL sDAL = new SupplierDAL();
sDAL.GetDataByLOID(supplier, null);
SupplierData data = new SupplierData();
data.SUPPLIERNAME = sDAL.SUPPLIERNAME;
data.CNAME = sDAL.CNAME;
data.CLASTNAME = sDAL.CLASTNAME;
data.CADDRESS = sDAL.CADDRESS;
data.CTEL = sDAL.CTEL;
data.CFAX = sDAL.CFAX;
//return DALObj.GetSupplierData(supplier);
return data;
}
private void UpdateData()
{
bool ret = true;
SupplierFlow supFlow = new SupplierFlow();
SupplierData supData = new SupplierData();
GetData(supData);
ret = supFlow.UpdateData(Authz.CurrentUserInfo.UserID, supData);
if (ret == false)
Appz.ClientAlert(Page, supFlow.ErrorMessage);
else
{
Appz.ClientAlert(Page, "·Ó¡ÒèѴà¡çº¢éÍÁÙżÙé¨Ó˹èÒÂàÃÕºÃéÍÂ");
txtLOID.Text = supFlow.GetLOIDbyCODE(supData.CODE).ToString();
}
}