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(); }