public US_V_DM_VPP(decimal i_dbID)
{
pm_objDS = new DS_V_DM_VPP();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
protected void m_cbo_vpp_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
m_lbl_thong_bao.Visible = false;
US_V_DM_VPP v_us = new US_V_DM_VPP();
DS_V_DM_VPP v_ds = new DS_V_DM_VPP();
v_us.FillDataset(v_ds, "where id_vpp=" + m_cbo_vpp.SelectedValue);
m_lbl_don_vi_tinh.Text = v_ds.Tables[0].Rows[0]["DON_VI_TINH"].ToString();
m_lbl_don_gia.Text = CIPConvert.ToStr(v_ds.Tables[0].Rows[0]["DON_GIA_GOM_VAT"], "#,###") + " (VNĐ)";
m_hdf_don_gia.Value = CIPConvert.ToStr(v_ds.Tables[0].Rows[0]["DON_GIA_CHUA_VAT"]);
//m_txt_so_luong.Focus();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public US_V_DM_VPP()
{
pm_objDS = new DS_V_DM_VPP();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetsearch(DS_V_DM_VPP ip_m_ds, decimal ip_v_id_ncc, decimal ip_v_dc_tu_khoa)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_DM_VPP_Search");
v_stored_proc.addDecimalInputParam("@ID_VPP", ip_v_dc_tu_khoa);
v_stored_proc.addDecimalInputParam("@ID_NCC", ip_v_id_ncc);
v_stored_proc.fillDataSetByCommand(this, ip_m_ds);
}
private void load_data_2_grid()
{
decimal v_dc_tu_khoa = CIPConvert.ToDecimal(m_cbo_tim_kiem.SelectedValue);
decimal v_id_nha_cc = CIPConvert.ToDecimal(m_cbo_nha_cc.SelectedValue);
DS_V_DM_VPP v_ds = new DS_V_DM_VPP();
US_V_DM_VPP v_us = new US_V_DM_VPP();
v_us.FillDatasetsearch(v_ds, v_id_nha_cc, v_dc_tu_khoa);
m_grv_dm_vpp.DataSource = v_ds.V_DM_VPP;
string v_str_thong_tin = " (Có " + v_ds.V_DM_VPP.Rows.Count + " mặt hàng)";
m_lbl_thong_tim_grv_dm_vpp.Text = v_str_thong_tin;
m_grv_dm_vpp.DataBind();
}
private void load_don_vi_tinh_don_gia()
{
US_V_DM_VPP v_us = new US_V_DM_VPP();
DS_V_DM_VPP v_ds = new DS_V_DM_VPP();
v_us.FillDataset(v_ds, "where id_vpp=" + m_cbo_vpp.SelectedValue);
m_lbl_don_vi_tinh.Text = v_ds.Tables[0].Rows[0]["DON_VI_TINH"].ToString();
m_lbl_don_gia.Text = CIPConvert.ToStr(v_ds.Tables[0].Rows[0]["DON_GIA_GOM_VAT"], "#,###") + " (VNĐ)";
m_hdf_don_gia.Value = CIPConvert.ToStr(v_ds.Tables[0].Rows[0]["DON_GIA_CHUA_VAT"]);
}
private void load_cbo_VPP()
{
US_V_DM_VPP v_us = new US_V_DM_VPP();
DS_V_DM_VPP v_ds = new DS_V_DM_VPP();
v_us.FillDataset(v_ds);
m_cbo_vpp.DataSource = v_ds.V_DM_VPP;
m_cbo_vpp.DataValueField = V_DM_VPP.ID_VPP;
m_cbo_vpp.DataTextField = V_DM_VPP.TEN_VPP;
m_cbo_vpp.DataBind();
}
private void us_object_to_form_don_hang_de()
{
US_GD_DON_DAT_HANG_DETAIL v_us_don_hang_de = new US_GD_DON_DAT_HANG_DETAIL(CIPConvert.ToDecimal(m_hdf_ID_GD_DON_DAT_HANG_DE.Value));
US_V_DM_VPP v_us = new US_V_DM_VPP();
DS_V_DM_VPP v_ds = new DS_V_DM_VPP();
v_us.FillDataset(v_ds, "where id_vpp =" + v_us_don_hang_de.dcID_VPP);
m_txt_so_luong.Text = v_us_don_hang_de.dcSO_LUONG.ToString();
m_cbo_vpp.DataTextField = v_ds.Tables[0].Rows[0]["TEN_VPP"].ToString();
m_lbl_don_gia.Text = CIPConvert.ToStr(v_ds.Tables[0].Rows[0]["DON_GIA_GOM_VAT"], "#,###") + " (VNĐ)";
if (v_us_don_hang_de.strMO_TA != null)
m_txt_mo_ta.Text = CIPConvert.ToStr(v_us_don_hang_de.strMO_TA);
else m_txt_mo_ta.Text = "";
}
private void load_data_2_grid()
{
m_ds = new DS_V_DM_VPP();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
private void load_data_2_grid()
{
m_ds = new DS_V_DM_VPP();
m_us.FillDataset(m_ds, "where id_nha_cung_cap=" + m_cbo_nha_cung_cap.SelectedValue.ToString());
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
private void check_update_data()
{
//lay du lieu bang vpp
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
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());
//add item to list
v_lst_vpp.Add(vpp);
}
C1.Win.C1FlexGrid.CellStyle v_cell_style_err = this.m_fg.Styles.Add("RowColorErr");
v_cell_style_err.BackColor = Color.LightCyan;
C1.Win.C1FlexGrid.CellStyle v_cell_style_err2 = this.m_fg.Styles.Add("RowColorErr2");
v_cell_style_err2.BackColor = Color.Yellow;
v_cell_style_err2.ForeColor = Color.DarkRed;
C1.Win.C1FlexGrid.CellStyle v_cell_style_ok = this.m_fg.Styles.Add("RowColorOk");
v_cell_style_ok.BackColor = Color.White;
C1.Win.C1FlexGrid.CellStyle v_cell_style_chu_ok = this.m_fg.Styles.Add("RowColor");
v_cell_style_chu_ok.BackColor = Color.Black;
C1.Win.C1FlexGrid.CellStyle v_cell_style_notOK_in_data = this.m_fg.Styles.Add("RowColorNotOk");
v_cell_style_notOK_in_data.BackColor = Color.Green;
//so sánh từng hóa đơn với MA_HD_NCC trong List 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)
{
if (v_dm_vpp.GIA_TRI_CHUA_VAT != v_lst_find_match[0].GIA_TRI_CHUA_VAT)
{
m_fg.SetCellStyle(v_i_row_fg, 5, v_cell_style_err2);
}
if (v_dm_vpp.GIA_TRI_GOM_VAT != v_lst_find_match[0].GIA_TRI_GOM_VAT)
{
m_fg.SetCellStyle(v_i_row_fg, 6, v_cell_style_err2);
}
}
else
{
m_fg.SetCellStyle(v_i_row_fg, 5, v_cell_style_err);
m_fg.SetCellStyle(v_i_row_fg, 6, v_cell_style_err);
}
}
}
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");
}
