private void delete_v_dm_vpp()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_V_DM_VPP v_us = new US_V_DM_VPP();
grid2us_object(v_us, m_fg.Row);
US_DM_VPP v_us_dm = new US_DM_VPP();
v_us_dm.dcID = v_us.dcID_VPP;
try
{
v_us_dm.BeginTransaction();
v_us_dm.Delete();
v_us_dm.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us_dm.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void load_m_cbo_tim_kiem()
{
US_DM_VPP v_us = new US_DM_VPP();
DS_DM_VPP v_ds = new DS_DM_VPP();
v_us.FillDataset(v_ds);
m_cbo_tim_kiem.DataSource = v_ds.DM_VPP;
m_cbo_tim_kiem.DataValueField = DM_VPP.ID;
m_cbo_tim_kiem.DataTextField = DM_VPP.TEN;
DataRow v_dr = v_ds.DM_VPP.NewRow();
v_dr[DM_VPP.ID] = -1;
v_dr[DM_VPP.TEN] = "------------Tất cả----------";
v_dr[DM_VPP.ID_NHA_CUNG_CAP] = -1;
v_dr[DM_VPP.DON_VI_TINH] = "";
v_dr[DM_VPP.MA] = "10001";
//v_dr[DM_VPP.DON_GIA_CHUA_VAT] = 0;
//v_dr[DM_VPP.DON_GIA_GOM_VAT] = 0;
v_ds.DM_VPP.Rows.InsertAt(v_dr, 0);
m_cbo_tim_kiem.SelectedIndex = 0;
m_cbo_tim_kiem.DataBind();
}
private void cap_nhat_danh_sach_vpp()
{
// dm_vpp to List
DS_V_DM_VPP v_ds_v_dm_vpp = new DS_V_DM_VPP();
m_us.FillDataset(v_ds_v_dm_vpp, "where id_nha_cung_cap=" + m_cbo_nha_cung_cap.SelectedValue.ToString());
// datatable to list, nhiem vu: tim id vpp
List<VanPhongPham> v_lst_vpp = new List<VanPhongPham>();
foreach (DataRow v_dr in v_ds_v_dm_vpp.Tables[0].Rows)
{
var vpp = new VanPhongPham();
vpp.ID = CIPConvert.ToDecimal(v_dr[V_DM_VPP.ID_VPP]);
vpp.ID_NHA_CUNG_CAP = CIPConvert.ToDecimal(m_cbo_nha_cung_cap.SelectedValue.ToString());
vpp.MA = v_dr[V_DM_VPP.MA].ToString();
vpp.TEN = v_dr[V_DM_VPP.TEN_VPP].ToString();
vpp.DON_VI_TINH = v_dr[V_DM_VPP.DON_VI_TINH].ToString();
vpp.GIA_TRI_CHUA_VAT = CIPConvert.ToDecimal(v_dr[V_DM_VPP.DON_GIA_CHUA_VAT].ToString());
vpp.GIA_TRI_GOM_VAT = CIPConvert.ToDecimal(v_dr[V_DM_VPP.DON_GIA_GOM_VAT].ToString());
vpp.GIOI_HAN_VPP = v_dr[V_DM_VPP.GIOI_HAN_VPP].ToString();
//add item to list
v_lst_vpp.Add(vpp);
}
// cap nhat danh sach vpp
for (int v_i_row_fg = 1; v_i_row_fg < m_fg.Rows.Count; v_i_row_fg++)
{
VanPhongPham v_dm_vpp = new VanPhongPham();
grid2vpp_object(v_dm_vpp, v_i_row_fg);
List<VanPhongPham> v_lst_find_match = new List<VanPhongPham>();
v_lst_find_match = v_lst_vpp.FindAll(x => /*x.MA == v_dm_vpp.MA ||*/x.TEN == v_dm_vpp.TEN);
if (v_lst_find_match.Count == 0)// khi chua co vpp
{
US_DM_VPP v_us_dm_vpp = new US_DM_VPP();
v_us_dm_vpp.dcID_NHA_CUNG_CAP = CIPConvert.ToDecimal(m_cbo_nha_cung_cap.SelectedValue.ToString());
v_us_dm_vpp.dcDON_GIA_CHUA_VAT = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][5].ToString());
v_us_dm_vpp.dcDON_GIA_GOM_VAT = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][6].ToString());
v_us_dm_vpp.strMA = m_fg.Rows[v_i_row_fg][2].ToString();
v_us_dm_vpp.strTEN = m_fg.Rows[v_i_row_fg][3].ToString();
v_us_dm_vpp.strDON_VI_TINH = m_fg.Rows[v_i_row_fg][4].ToString();
v_us_dm_vpp.strGIOI_HAN_VPP = m_fg.Rows[v_i_row_fg][7].ToString();
v_us_dm_vpp.Insert();
}
else //cap nhat don gia
{
US_DM_VPP v_us_dm_vpp = new US_DM_VPP(v_lst_find_match[0].ID);
v_us_dm_vpp.dcDON_GIA_CHUA_VAT = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][5].ToString());
v_us_dm_vpp.dcDON_GIA_GOM_VAT = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][6].ToString());
//v_us_dm_vpp.strGIOI_HAN_VPP = m_fg.Rows[v_i_row_fg][7].ToString();
v_us_dm_vpp.Update();
}
}
BaseMessages.MsgBox_Infor("Cập nhật thành công");
}
