private void cap_nhat_gridview()
{
C1.Win.C1FlexGrid.CellStyle v_cell_style_err = this.m_fg.Styles.Add("RowColorErr");
v_cell_style_err.BackColor = Color.Red;
US_V_GD_DON_DAT_HANG_DETAIL v_us_v_don_dat_hang_de = new US_V_GD_DON_DAT_HANG_DETAIL();
DS_V_GD_DON_DAT_HANG_DETAIL v_ds_v_don_dat_hang_de = new DS_V_GD_DON_DAT_HANG_DETAIL();
int v_i_row_fg = 0;
int v_i_m_ds = 0;
for (v_i_row_fg = 1, v_i_m_ds=0 ; v_i_row_fg < m_fg.Rows.Count; v_i_row_fg++, v_i_m_ds++)
{
m_lbl_loading.Visible = true;
progressBar1.Visible = true;
progressBar1.Minimum = 0;
progressBar1.Maximum = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count;
progressBar1.Value = v_i_row_fg;
v_us_v_don_dat_hang_de.So_sanh_hoa_don_theo_ma_NCC(v_ds_v_don_dat_hang_de, m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_m_ds][(int)e_col_Number.MA_PHIEU].ToString(), m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_m_ds][(int)e_col_Number.TEN_VPP].ToString());
if (v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows.Count > 0)
{
decimal test = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.SO_LUONG]);
decimal don_gia = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.GIA_BAN]);
decimal doanh_thu = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.DOANH_THU]);
if (CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.SO_LUONG]) == CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"]) && CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.GIA_BAN]) == CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) && CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.DOANH_THU]) == (CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) * CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"])))
{
m_fg.RemoveItem(v_i_row_fg);
v_i_row_fg--;
}
}
v_ds_v_don_dat_hang_de.Clear();
}
m_lbl_loading.Visible = false;
progressBar1.Visible = false;
m_lbl_thong_bao_cap_nhat.Visible = true;
}
public US_V_GD_DON_DAT_HANG_DETAIL(decimal i_dbID)
{
pm_objDS = new DS_V_GD_DON_DAT_HANG_DETAIL();
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]);
}
private void load_don_dat_hang_de(string ip_v_ma_phieu)
{
US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL();
DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL();
v_us.FillDataset(v_ds, "Where MA_DON_HANG =" + "'"+ip_v_ma_phieu+"' order by NGAY_DAT_HANG DESC");
m_fg_don_dat_hang_de.Redraw = false;
CGridUtils.Dataset2C1Grid(v_ds, m_fg_don_dat_hang_de, m_obj_trans_de);
m_fg_don_dat_hang_de.Redraw = true;
}
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
this.ResumeLayout(false);
}
private void insert_v_gd_don_dat_hang_detail()
{
// f534_TRA_CUU_DON_HANG_DE_DE v_fDE = new f534_TRA_CUU_DON_HANG_DE_DE();
// v_fDE.display();
private void load_data_2_grid_detail(decimal ip_dc_id_don_hang)
{
US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL();
DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL();
v_us.FillDataset(v_ds, "where id_don_dat_hang=" + ip_dc_id_don_hang);
m_grv_detail.DataSource = v_ds.V_GD_DON_DAT_HANG_DETAIL;
m_grv_detail.DataBind();
string v_str_thong_tin = "Danh sách Có " + v_ds.V_GD_DON_DAT_HANG_DETAIL.Rows.Count + " mặt hàng";
m_lbl_grv_detail.Text = v_str_thong_tin;
view_detail_grv(true);
}
public void So_sanh_hoa_don_theo_ma_NCC(DS_V_GD_DON_DAT_HANG_DETAIL v_ds_v_don_dat_hang_de, string ip_ma_don_hang_NCC, string ip_ma_ten_vpp)
{
CStoredProc v_stored_proc = new CStoredProc("pr_So_sanh_chi_phi_NCC");
v_stored_proc.addNVarcharInputParam("@MA_HD_NCC", ip_ma_don_hang_NCC);
v_stored_proc.addNVarcharInputParam("@MA_TEN_VPP", ip_ma_ten_vpp);
v_stored_proc.fillDataSetByCommand(this, v_ds_v_don_dat_hang_de);
}
public void FillDatasetSearch_phapnhan(DS_V_GD_DON_DAT_HANG_DETAIL ip_ds, DateTime ip_dat_thang, decimal ip_dc_id_phap_nhan, decimal ip_id_trang_thai, decimal ip_dc_id_trung_tam)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_DON_DAT_HANG_DETAIL_Search_Phapnhan");
v_stored_proc.addDecimalInputParam("@ID_PHONG_BAN", ip_dc_id_trung_tam);
v_stored_proc.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", ip_id_trang_thai);
v_stored_proc.addDatetimeInputParam("@NGAY", ip_dat_thang);
v_stored_proc.fillDataSetByCommand(this, ip_ds);
}
public void FillDatasetSearch_hdchitiet(DS_V_GD_DON_DAT_HANG_DETAIL ip_ds, decimal ip_dc_id_hoa_don)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_DON_DAT_HANG_DETAIL_Search_hd_detail");
v_stored_proc.addDecimalInputParam("@ID_DON_HANG", ip_dc_id_hoa_don);
v_stored_proc.fillDataSetByCommand(this, ip_ds);
}
public void FillDatasetSearch(DS_V_GD_DON_DAT_HANG_DETAIL ip_ds, DateTime ip_dat_thang, decimal ip_dc_id_trung_tam, string ip_str_tu_khoa)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_DON_DAT_HANG_DETAIL_Search");
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_stored_proc.addDecimalInputParam("@ID_PHONG_BAN", ip_dc_id_trung_tam);
v_stored_proc.addDatetimeInputParam("@NGAY", ip_dat_thang);
v_stored_proc.fillDataSetByCommand(this, ip_ds);
}
public US_V_GD_DON_DAT_HANG_DETAIL()
{
pm_objDS = new DS_V_GD_DON_DAT_HANG_DETAIL();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDataset(DS_V_GD_DON_DAT_HANG_DETAIL ip_v_ds, string v_ma_don_hang, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
{
CStoredProc v_stored_proc = new CStoredProc("pr_BC_TINH_HINH_SU_DUNG_VPP_DETAIL_WEB");
v_stored_proc.addNVarcharInputParam("@MA_DON_HANG", v_ma_don_hang);
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
private void so_sanh_chi_phi_voi_don_hang()
{
US_V_GD_DON_DAT_HANG_DETAIL v_us_v_don_dat_hang_de = new US_V_GD_DON_DAT_HANG_DETAIL();
DS_V_GD_DON_DAT_HANG_DETAIL v_ds_v_don_dat_hang_de = new DS_V_GD_DON_DAT_HANG_DETAIL();
int v_i_row_fg = 0;
int v_i_ds = 0;
//set Style cell
C1.Win.C1FlexGrid.CellStyle v_cell_style_err = this.m_fg.Styles.Add("RowColorErr");
v_cell_style_err.BackColor = Color.Red;
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_PHIEU trong cơ sở dữ liệu
for (v_i_row_fg = 1, v_i_ds = 0; v_i_ds < m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; v_i_row_fg++, v_i_ds++)
{
m_lbl_loading.Visible = true;
progressBar1.Visible = true;
progressBar1.Minimum = 0;
progressBar1.Maximum = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count;
progressBar1.Value = v_i_row_fg;
v_us_v_don_dat_hang_de.So_sanh_hoa_don_theo_ma_NCC(v_ds_v_don_dat_hang_de, m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.MA_PHIEU].ToString(), m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.TEN_VPP].ToString());
if (v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows.Count > 0)
{
if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.SO_LUONG]) != CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"]))
{
m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.SO_LUONG, v_cell_style_err2);
}
if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.GIA_BAN]) != CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]))
{
m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.GIA_BAN, v_cell_style_err2);
}
if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.DOANH_THU]) != (CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) * CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"])))
{
m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.DOANH_THU, v_cell_style_err2);
}
}
else
{
m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.TEN_VPP, v_cell_style_err);
//m_fg.Rows[v_i_row_fg].StyleDisplay.ForeColor = Color.White;
}
v_ds_v_don_dat_hang_de.Clear();
}
m_lbl_loading.Visible = false;
progressBar1.Visible = false;
}
m_cbo_trung_tam.DataSource = v_ds.v_DM_PHONG_BAN_PHAP_NHAN;
m_cbo_trung_tam.ValueMember = V_DM_PHONG_BAN_PHAP_NHAN.ID_PHONG_BAN;
m_cbo_trung_tam.DisplayMember = V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHONG_BAN;
DataRow v_dr = v_ds.v_DM_PHONG_BAN_PHAP_NHAN.NewRow();
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID_PHAP_NHAN] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.ID_PHONG_BAN] = -1;
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.MA_PHAP_NHAN] = "";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHAP_NHAN] = "Tất cả";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TEN_PHONG_BAN] = "Tất cả";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.MA_PHONG_BAN] = "";
v_dr[V_DM_PHONG_BAN_PHAP_NHAN.TY_TRONG] = 100;
v_ds.v_DM_PHONG_BAN_PHAP_NHAN.Rows.InsertAt(v_dr, 0);
m_cbo_trung_tam.SelectedIndex = 0;
}
private void load_data_2_grid()
{
decimal v_dc_id_phap_nhan = CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue);
decimal v_dc_id_trung_tam = CIPConvert.ToDecimal(m_cbo_trung_tam.SelectedValue);
DateTime temp = CIPConvert.ToDatetime("01/"+m_dtp_thang.Text);
{
// f331_V_GD_DON_DAT_HANG_DETAIL_DE v_fDE = new f331_V_GD_DON_DAT_HANG_DETAIL_DE();
// v_fDE.display();
load_data_2_grid();
}
private void load_data_2_cbo_trung_tam()
{
US_DM_PHONG_BAN v_us = new US_DM_PHONG_BAN();
DS_DM_PHONG_BAN v_ds = new DS_DM_PHONG_BAN();
v_us.FillDataset(v_ds, "order by ten_phong_ban");
m_cbo_trung_tam.DataSource = v_ds.DM_PHONG_BAN;
m_cbo_trung_tam.ValueMember = DM_PHONG_BAN.ID;
m_cbo_trung_tam.DisplayMember = DM_PHONG_BAN.TEN_PHONG_BAN;
DataRow v_dr = v_ds.DM_PHONG_BAN.NewRow();
v_dr[DM_PHONG_BAN.ID] = -1;
v_dr[DM_PHONG_BAN.MA_PHONG_BAN] = "";
v_dr[DM_PHONG_BAN.TEN_PHONG_BAN] = "------------Tất cả------------";
v_ds.DM_PHONG_BAN.Rows.InsertAt(v_dr, 0);
m_cbo_trung_tam.SelectedIndex = 0;
}
private void load_data_2_grid()
{
DateTime temp = m_dtp_thang.Value.Date;
private void display_pop_up_detail(string v_ma_don_hang)
{
m_lbl_ten_detail.Text = "Mã phiếu: " + v_ma_don_hang.ToString();
US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL();
DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL();
v_us.FillDataset(v_ds, v_ma_don_hang, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text));
m_grv_detail.DataSource = v_ds.V_GD_DON_DAT_HANG_DETAIL;
string v_str_thong_tin = "Danh sách Có " + v_ds.V_GD_DON_DAT_HANG_DETAIL.Rows.Count + " vật tư";
m_lbl_grv_detail.Text = v_str_thong_tin;
m_grv_detail.DataBind();
}
