public int PROVIDER_PAYMENT_DETAIL_Insert(PROVIDER_PAYMENT_DETAIL obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "PROVIDER_PAYMENT_DETAIL_Insert",
obj.ID,
obj.PaymentID,
obj.RefOrgNo,
obj.CurrencyID,
obj.ExchangeRate,
obj.Quantity,
obj.Amount,
obj.Debit,
obj.Payment,
obj.DiscountPercent,
obj.Discount,
obj.FAmount,
obj.FDebit,
obj.FPayment,
obj.FDiscount,
obj.Description,
obj.Sorted
));
}
catch
{
//throw ex;
return(-1);
}
}
public List <PROVIDER_PAYMENT_DETAIL> PROVIDER_PAYMENT_DETAIL_Search(PROVIDER_PAYMENT_DETAIL obj)
{
DataTable dt = new DataTable();
try
{
DataProvider.FillDataTable(DataProvider.ConnectionString, dt, "PROVIDER_PAYMENT_DETAIL_Search",
obj.RefOrgNo,
obj.ExchangeRate,
obj.Quantity,
obj.Amount,
obj.Debit,
obj.Payment,
obj.DiscountPercent,
obj.Discount,
obj.FAmount,
obj.FDebit,
obj.FPayment,
obj.FDiscount,
obj.Description
);
return(MapPROVIDER_PAYMENT_DETAIL(dt));
}
catch (Exception ex)
{
throw ex;
}
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rs_PROVIDER_PAYMENT, rs_PROVIDER_PAYMENT_detail;
rs_PROVIDER_PAYMENT = -1;
rs_PROVIDER_PAYMENT_detail = -1;
PROVIDER_PAYMENT _PROVIDER_PAYMENT = new PROVIDER_PAYMENT();
PROVIDER_PAYMENT_DETAIL _PROVIDER_PAYMENT_detail = new PROVIDER_PAYMENT_DETAIL();
if (MessageBox.Show("Bạn Muốn Xóa Phiếu Chi Này?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (gridView1.RowCount > 0)
{
string id = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[0]).ToString();
_PROVIDER_PAYMENT = new PROVIDER_PAYMENTController().PROVIDER_PAYMENT_GetbyRefID(id.Trim());
_PROVIDER_PAYMENT_detail = new PROVIDER_PAYMENT_DETAILController().PROVIDER_PAYMENT_DETAIL_GetbyPaymentID(_PROVIDER_PAYMENT.ID);
rs_PROVIDER_PAYMENT = new PROVIDER_PAYMENTController().PROVIDER_PAYMENT_Delete2011(_PROVIDER_PAYMENT.ID, _PROVIDER_PAYMENT.RefOrgNo);
rs_PROVIDER_PAYMENT_detail = new PROVIDER_PAYMENT_DETAILController().PROVIDER_PAYMENT_DETAIL_Delete(_PROVIDER_PAYMENT_detail.ID);
if ((rs_PROVIDER_PAYMENT > -1) && (rs_PROVIDER_PAYMENT_detail > -1))
{
MessageBox.Show("Phiếu Chi đã được xóa", "Thông báo");
}
else
{
MessageBox.Show("Phiếu Chi không được xóa", "Thông báo");
}
gridControl1.DataSource = new PROVIDER_PAYMENTController().PROVIDER_PAYMENT_GetList();
}
}
}
private List <PROVIDER_PAYMENT_DETAIL> MapPROVIDER_PAYMENT_DETAIL(DataTable dt)
{
List <PROVIDER_PAYMENT_DETAIL> rs = new List <PROVIDER_PAYMENT_DETAIL>();
for (int i = 0; i < dt.Rows.Count; i++)
{
PROVIDER_PAYMENT_DETAIL obj = new PROVIDER_PAYMENT_DETAIL();
if (dt.Columns.Contains("ID"))
{
obj.ID = new Guid(dt.Rows[i]["ID"].ToString());
}
if (dt.Columns.Contains("PaymentID"))
{
obj.PaymentID = new Guid(dt.Rows[i]["PaymentID"].ToString());
}
if (dt.Columns.Contains("RefOrgNo"))
{
obj.RefOrgNo = new Guid(dt.Rows[i]["RefOrgNo"].ToString());
}
if (dt.Columns.Contains("CurrencyID"))
{
obj.CurrencyID = dt.Rows[i]["CurrencyID"].ToString();
}
if (dt.Columns.Contains("ExchangeRate"))
{
obj.ExchangeRate = double.Parse(dt.Rows[i]["ExchangeRate"].ToString());
}
if (dt.Columns.Contains("Quantity"))
{
obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString());
}
if (dt.Columns.Contains("Amount"))
{
obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString());
}
if (dt.Columns.Contains("Debit"))
{
obj.Debit = double.Parse(dt.Rows[i]["Debit"].ToString());
}
if (dt.Columns.Contains("Payment"))
{
obj.Payment = double.Parse(dt.Rows[i]["Payment"].ToString());
}
if (dt.Columns.Contains("DiscountPercent"))
{
obj.DiscountPercent = double.Parse(dt.Rows[i]["DiscountPercent"].ToString());
}
if (dt.Columns.Contains("Discount"))
{
obj.Discount = double.Parse(dt.Rows[i]["Discount"].ToString());
}
if (dt.Columns.Contains("FAmount"))
{
obj.FAmount = double.Parse(dt.Rows[i]["FAmount"].ToString());
}
if (dt.Columns.Contains("FDebit"))
{
obj.FDebit = double.Parse(dt.Rows[i]["FDebit"].ToString());
}
if (dt.Columns.Contains("FPayment"))
{
obj.FPayment = double.Parse(dt.Rows[i]["FPayment"].ToString());
}
if (dt.Columns.Contains("FDiscount"))
{
obj.FDiscount = double.Parse(dt.Rows[i]["FDiscount"].ToString());
}
if (dt.Columns.Contains("Description"))
{
obj.Description = dt.Rows[i]["Description"].ToString();
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
rs.Add(obj);
}
return(rs);
}
