public US_DM_NGUOI_DAT_HANG(decimal i_dbID)
 {
     pm_objDS = new DS_DM_NGUOI_DAT_HANG();
     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]);
 }
示例#2
0
        public US_DM_NGUOI_DAT_HANG(decimal i_dbID)
        {
            pm_objDS        = new DS_DM_NGUOI_DAT_HANG();
            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]);
        }
示例#3
0
        private AutoCompleteStringCollection load_thong_tin_nguoi_dat_hang()
        {
            US_DM_NGUOI_DAT_HANG         v_us_dm_nguoi_dat_hang = new US_DM_NGUOI_DAT_HANG();
            DS_DM_NGUOI_DAT_HANG         v_ds_dm_nguoi_dat_hang = new DS_DM_NGUOI_DAT_HANG();
            AutoCompleteStringCollection v_auto_complete_string_ten_nguoi_dat_hang = new AutoCompleteStringCollection();

            v_us_dm_nguoi_dat_hang.load_ds_nguoi_dat_hang(v_ds_dm_nguoi_dat_hang);
            if (v_ds_dm_nguoi_dat_hang.DM_NGUOI_DAT_HANG.Rows.Count > 0)
            {
                foreach (DataRow v_dr in v_ds_dm_nguoi_dat_hang.DM_NGUOI_DAT_HANG.Rows)
                {
                    v_auto_complete_string_ten_nguoi_dat_hang.Add(v_dr[DM_NGUOI_DAT_HANG.USER_TOPICA].ToString());
                }
            }
            return(v_auto_complete_string_ten_nguoi_dat_hang);
        }
示例#4
0
        private void load_thong_tin_nguoi_dat_hang_by_user()
        {
            string v_str_user_nv_dat_hang            = m_txt_nguoi_dat_hang.Text.Trim();
            US_DM_NGUOI_DAT_HANG v_us_dm_ng_dat_hang = new US_DM_NGUOI_DAT_HANG();
            DS_DM_NGUOI_DAT_HANG v_ds_dm_ng_dat_hang = new DS_DM_NGUOI_DAT_HANG();

            v_us_dm_ng_dat_hang.FillDataset(v_ds_dm_ng_dat_hang, " WHERE " + DM_NGUOI_DAT_HANG.USER_TOPICA + " = '" + v_str_user_nv_dat_hang + "'");

            if (v_ds_dm_ng_dat_hang.DM_NGUOI_DAT_HANG.Rows.Count == 1)
            {
                if (v_ds_dm_ng_dat_hang.DM_NGUOI_DAT_HANG.Rows[0][DM_NGUOI_DAT_HANG.SO_DIEN_THOAI] != null)
                {
                    m_txt_dien_thoai.Text = v_ds_dm_ng_dat_hang.DM_NGUOI_DAT_HANG.Rows[0][DM_NGUOI_DAT_HANG.SO_DIEN_THOAI].ToString();
                }
                m_txt_ho_ten.Text             = v_ds_dm_ng_dat_hang.DM_NGUOI_DAT_HANG.Rows[0][DM_NGUOI_DAT_HANG.HO_TEN].ToString();
                m_cbo_dv_don_vi.SelectedValue = v_ds_dm_ng_dat_hang.DM_NGUOI_DAT_HANG.Rows[0][DM_NGUOI_DAT_HANG.ID_DON_VI];
            }
        }
示例#5
0
        public void load_ds_nguoi_dat_hang(DS_DM_NGUOI_DAT_HANG op_ds)
        {
            CStoredProc v_cstore = new CStoredProc("pr_DM_NGUOI_DAT_HANG_load_ds_nguoi_dat_hang");

            v_cstore.fillDataSetByCommand(this, op_ds);
        }
示例#6
0
 public US_DM_NGUOI_DAT_HANG()
 {
     pm_objDS        = new DS_DM_NGUOI_DAT_HANG();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }
 public US_DM_NGUOI_DAT_HANG()
 {
     pm_objDS = new DS_DM_NGUOI_DAT_HANG();
     pm_strTableName = c_TableName;
     pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
 }
 public void load_ds_nguoi_dat_hang(DS_DM_NGUOI_DAT_HANG op_ds)
 {
     CStoredProc v_cstore = new CStoredProc("pr_DM_NGUOI_DAT_HANG_load_ds_nguoi_dat_hang");
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
示例#9
0
 private AutoCompleteStringCollection load_thong_tin_nguoi_dat_hang()
 {
     US_DM_NGUOI_DAT_HANG v_us_dm_nguoi_dat_hang = new US_DM_NGUOI_DAT_HANG();
     DS_DM_NGUOI_DAT_HANG v_ds_dm_nguoi_dat_hang = new DS_DM_NGUOI_DAT_HANG();
     AutoCompleteStringCollection v_auto_complete_string_ten_nguoi_dat_hang = new AutoCompleteStringCollection();
     v_us_dm_nguoi_dat_hang.load_ds_nguoi_dat_hang(v_ds_dm_nguoi_dat_hang);
     if (v_ds_dm_nguoi_dat_hang.DM_NGUOI_DAT_HANG.Rows.Count > 0)
     {
         foreach (DataRow v_dr in v_ds_dm_nguoi_dat_hang.DM_NGUOI_DAT_HANG.Rows)
         {
             v_auto_complete_string_ten_nguoi_dat_hang.Add(v_dr[DM_NGUOI_DAT_HANG.USER_TOPICA].ToString());
         }
     }
     return v_auto_complete_string_ten_nguoi_dat_hang;
 }