public US_RPT_GD_DON_DAT_HANG_DINH_MUC(decimal i_dbID) { pm_objDS = new DS_RPT_GD_DON_DAT_HANG_DINH_MUC(); 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_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(); 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); 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Đ)"; }
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"; }
private void load_data_to_grid_don_hang() { //load grid đơn hàng: //US_GD_DON_DAT_HANG v_us_don_hang = new US_GD_DON_DAT_HANG(); //DS_GD_DON_DAT_HANG v_ds_don_hang = new DS_GD_DON_DAT_HANG(); decimal v_id_phong_ban = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value); 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_grv_don_hang_nhap.DataSource = v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC; m_grv_don_hang_nhap.DataBind(); //string v_str_thong_tin_don_hang = " (Có " + v_ds_don_hang.RPT_GD_DON_DAT_HANG_DINH_MUC.Rows.Count + " đơn hàng)"; //m_lbl_thong_tin_don_hang.Text = v_str_thong_tin_don_hang; }
public US_RPT_GD_DON_DAT_HANG_DINH_MUC() { pm_objDS = new DS_RPT_GD_DON_DAT_HANG_DINH_MUC(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void FillDS_don_hang_dinh_muc(DS_RPT_GD_DON_DAT_HANG_DINH_MUC v_ds_don_hang, decimal ip_v_id_phong_ban) { CStoredProc v_store_proc = new CStoredProc("pr_DON_DAT_HANG_DINH_MUC"); v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM ", ip_v_id_phong_ban); v_store_proc.fillDataSetByCommand(this, v_ds_don_hang); }