public US_V_GD_DE_XUAT(decimal i_dbID)
{
pm_objDS = new DS_V_GD_DE_XUAT();
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_data_2_grid()
{
DateTime v_dat_thang = CIPConvert.ToDatetime("01/" + m_dtp_thang.Text, "dd/MM/yyyy");
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);
decimal v_dc_id_loai_de_xuat = CIPConvert.ToDecimal(m_cbo_loai_de_xuat.SelectedValue);
m_ds_v_gd_de_xuat = new DS_V_GD_DE_XUAT();
m_us_v_gd_de_xuat.FillDatasetSearch(m_ds_v_gd_de_xuat, v_dat_thang, v_dc_id_phap_nhan, v_dc_id_trung_tam, v_dc_id_loai_de_xuat);
m_grv_de_xuat.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_v_gd_de_xuat, m_grv_de_xuat, m_obj_trans);
CGridUtils.MakeSoTT(0, m_grv_de_xuat);
m_grv_de_xuat.AllowResizing = AllowResizingEnum.Both;
//create_button_upload_file_2_grid(m_ds_v_gd_de_xuat);
m_grv_de_xuat.Redraw = true;
}
private void create_button_upload_file_2_grid(DS_V_GD_DE_XUAT ip_ds_v_gd_de_xuat)
{
//Column c = m_grv_de_xuat.Cols[6];
//c.DataType = typeof(Color);
//c.ComboList = "Up load file";
int v_i_rows;
Button v_btn_up_load_file = new Button();
v_btn_up_load_file.BackColor = SystemColors.ButtonHighlight;
v_btn_up_load_file.Text = "Up load file";
v_btn_up_load_file.Tag = "Up load file";
for (v_i_rows = 0; v_i_rows < m_grv_de_xuat.Rows.Count -1 ; v_i_rows++)
m_list_button.Add(new HostedControl(m_grv_de_xuat, v_btn_up_load_file, v_i_rows, (int)e_col_Number.LINK));
// draw button
}
private void load_ma_don_hang_title()
{
US_GD_DON_DAT_HANG v_us = new US_GD_DON_DAT_HANG();
DS_GD_DON_DAT_HANG v_ds = new DS_GD_DON_DAT_HANG();
US_V_GD_DE_XUAT v_us_de_xuat = new US_V_GD_DE_XUAT();
DS_V_GD_DE_XUAT v_ds_de_xuat = new DS_V_GD_DE_XUAT();
update_tong_tien_don_hang(CIPConvert.ToDecimal(m_hdf_id_don_hang.Value));
v_us.FillDataset(v_ds, "where id=" + CIPConvert.ToDecimal(m_hdf_id_don_hang.Value));
m_lbl_title_ma_don_hang.Text = "Nhập chi tiết đơn hàng ";
m_lbl_ma_don_hang_de.Text = v_ds.Tables[0].Rows[0]["MA"].ToString();
m_lbl_ma_don_hang_de.Visible = true;
m_lbl_MP.Visible = true;
decimal v_id_phong_ban = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value);
decimal v_ti_le_vuot;
decimal tien_de_xuat;
decimal tong_tien;
decimal dinh_muc;
US_RPT_GD_DON_DAT_HANG_DINH_MUC v_us_don_hang = new US_RPT_GD_DON_DAT_HANG_DINH_MUC();
DS_RPT_GD_DON_DAT_HANG_DINH_MUC v_ds_don_hang = new DS_RPT_GD_DON_DAT_HANG_DINH_MUC();
v_us_don_hang.FillDS_don_hang_dinh_muc(v_ds_don_hang, v_id_phong_ban);
m_lbl_pop_lan.Text = CIPConvert.ToStr(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["LAN"],"#,###");
DateTime v_dat_ngay = (DateTime)v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["NGAY_DAT_HANG"];
m_lbl_pop_ngay.Text = v_dat_ngay.ToString("dd/MM/yyyy");
m_lbl_pop_tong_tien.Text = CIPConvert.ToStr(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["GIA_TRI_DA_VAT"],"#,###") + " (VNĐ)";
m_lbl_pop_dinh_muc.Text = CIPConvert.ToStr(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["DINH_MUC"], "#,###") + " (VNĐ)";
// tính tỉ lệ vượt
v_us_de_xuat.FillDSLayDeXuat(v_ds_de_xuat, v_dat_ngay, v_id_phong_ban);
if(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["GIA_TRI_DA_VAT"] != "" || v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["GIA_TRI_DA_VAT"] != null)
tong_tien = CIPConvert.ToDecimal(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["GIA_TRI_DA_VAT"]);
else tong_tien = 0;
if(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["DINH_MUC"] != "" || v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["DINH_MUC"] != null)
dinh_muc = CIPConvert.ToDecimal(v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows[0]["DINH_MUC"]);
else dinh_muc = 0;
if(dinh_muc > 0)
{
if (v_ds_de_xuat.Tables[0].Rows.Count > 0)
{
tien_de_xuat = CIPConvert.ToDecimal(v_ds_de_xuat.Tables[0].Rows[0]["SO_TIEN"]);
v_ti_le_vuot = ((tong_tien - tien_de_xuat - dinh_muc) / dinh_muc)*100;
if (v_ti_le_vuot > 0)
m_lbl_pop_ti_le_vuot.Text = CIPConvert.ToStr(v_ti_le_vuot,".#") + " (%)";
else m_lbl_pop_ti_le_vuot.Text = "0 (%)";
}
else
{
v_ti_le_vuot = ((tong_tien - dinh_muc) / dinh_muc)*100;
if(v_ti_le_vuot > 0)
m_lbl_pop_ti_le_vuot.Text = CIPConvert.ToStr(v_ti_le_vuot, ".#") + " (%)";
else m_lbl_pop_ti_le_vuot.Text = "0 (%)";
}
}
else m_lbl_pop_ti_le_vuot.Text = "Chưa có định mức";
}
public US_V_GD_DE_XUAT()
{
pm_objDS = new DS_V_GD_DE_XUAT();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDSLayDeXuat(DS_V_GD_DE_XUAT v_ds_de_xuat, DateTime v_dat_ngay, decimal v_id_phong_ban)
{
CStoredProc v_strore_proc = new CStoredProc("pr_get_de_xuat_trung_tam");
v_strore_proc.addDatetimeInputParam("@NGAY_DAT_HANG", v_dat_ngay);
v_strore_proc.addDecimalInputParam("@ID_TRUNG_TAM", v_id_phong_ban);
v_strore_proc.fillDataSetByCommand(this,v_ds_de_xuat);
}
public void FillDatasetSearch(DS_V_GD_DE_XUAT ip_ds, DateTime ip_dat_thang, decimal ip_dc_id_phap_nhan, decimal ip_dc_id_trung_tam, decimal ip_dc_id_de_xuat)
{
CStoredProc v_store_proc = new CStoredProc("pr_V_GD_DE_XUAT_Search");
v_store_proc.addDatetimeInputParam("@THANG", ip_dat_thang);
v_store_proc.addDecimalInputParam("@ID_PHONG_BAN", ip_dc_id_trung_tam);
v_store_proc.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_id_phap_nhan);
v_store_proc.addDecimalInputParam("@ID_DE_XUAT", ip_dc_id_de_xuat);
v_store_proc.fillDataSetByCommand(this, ip_ds);
}
