private void load_data_to_col_tong_ke_hoach(US_GD_CHI_TIET_GIAO_VON ip_us
, DataSet ip_ds
, DataTable ip_dt
, String ip_str_tu_ngay
, String ip_str_den_ngay)
{
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_giao_kh_qbt"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, c_configuration.TAT_CA
, c_configuration.TAT_CA);
for (int i = 0; i < ip_ds.Tables[0].Columns.Count; i++)
{
ip_dt.Columns.Add(ip_ds.Tables[0].Columns[i].ColumnName);
}
for (int i = 0; i < ip_ds.Tables[0].Rows.Count; i++)
{
var row = ip_dt.NewRow();
for (int j = 0; j < ip_ds.Tables[0].Columns.Count; j++)
{
row[j] = ip_ds.Tables[0].Rows[i][j];
}
ip_dt.Rows.Add(row);
}
}
private void load_data_to_col_so_du_nam_truoc_chuyen_sang(US_GD_CHI_TIET_GIAO_VON ip_us
, DataSet ip_ds
, DataTable ip_dt
, String ip_str_tu_ngay
, String ip_str_den_ngay)
{
ip_ds.Clear();
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_nam_truoc_chuyen_sang"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, c_configuration.TAT_CA);
GhepThemCot(ip_dt, ip_ds.Tables[0], "SoDu");
}
private void load_data_to_col_tong_giao_von_and_giao_von_theo_quyet_dinh(
US_GD_CHI_TIET_GIAO_VON ip_us
, DataSet ip_ds
, DataTable ip_dt
, String ip_str_tu_ngay
, String ip_str_den_ngay)
{
ip_ds.Clear();
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_giao_von_qbt"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, c_configuration.TAT_CA);
GhepThemCot(ip_dt, ip_ds.Tables[0], "TongVon");
m_lst_ds_qd = getDanhSachQDGiaoVon();
foreach (var item in m_lst_ds_qd)
{
ip_ds.Clear();
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_giao_von_qbt"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, item);
GhepThemCot(ip_dt, ip_ds.Tables[0], "QD" + item.ToString());
}
}
private void load_data_to_col_ke_hoach_chinh_thuc_or_bo_sung(US_GD_CHI_TIET_GIAO_VON ip_us
, DataSet ip_ds
, DataTable ip_dt
, String ip_str_tu_ngay
, String ip_str_den_ngay)
{
ip_ds.Clear();
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_giao_von_qbt"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, c_configuration.TAT_CA
, c_configuration.GIAO_DAU_NAM);
GhepThemCot(ip_dt, ip_ds.Tables[0], "ChinhThuc");
List<decimal> v_lst_ds_qd = getDanhSachQDBS();
foreach (var item in v_lst_ds_qd)
{
ip_ds.Clear();
ip_us.FillDatasetWithProcedure(
"pr_F520_lay_tong_tien_nam_truoc_chuyen_sang"
, ip_ds
, CIPConvert.ToDatetime(ip_str_tu_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(ip_str_den_ngay, c_configuration.DEFAULT_DATETIME_FORMAT)
, item
, c_configuration.GIAO_BO_SUNG);
GhepThemCot(ip_dt, ip_ds.Tables[0], "QD" + item.ToString());
}
}
