public US_GD_DON_DAT_HANG_DETAIL(decimal i_dbID) { pm_objDS = new DS_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 delete_data_don_hang() { //if (!check_validate_is_ok()) return; US_GD_DON_DAT_HANG_DETAIL v_us = new US_GD_DON_DAT_HANG_DETAIL(); DS_GD_DON_DAT_HANG_DETAIL v_ds = new DS_GD_DON_DAT_HANG_DETAIL(); v_us.Delete_don_hang_de(v_ds, CIPConvert.ToDecimal(m_hdf_id_don_hang.Value)); m_us_gd_don_dat_hang.DeleteByID(CIPConvert.ToDecimal(m_hdf_id_don_hang.Value)); m_grv_don_hang_nhap.SelectedIndex = -1; load_data_to_grid_don_hang(); thong_bao("Đã xóa đơn hàng VPP thành công!", true); }
public US_GD_DON_DAT_HANG_DETAIL() { pm_objDS = new DS_GD_DON_DAT_HANG_DETAIL(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void update_so_luong_VPP_da_ton_tai(DS_GD_DON_DAT_HANG_DETAIL ip_m_ds_gd_don_dat_hang_de, decimal ip_id_vpp, decimal ip_so_luong) { CStoredProc v_store_proc = new CStoredProc("pr_Update_so_luong_vpp"); v_store_proc.addDecimalInputParam("@ID_VPP", ip_id_vpp); v_store_proc.addDecimalInputParam("@SO_LUONG", ip_so_luong); v_store_proc.fillDataSetByCommand(this, ip_m_ds_gd_don_dat_hang_de); }
public void Delete_don_hang_de(DS_GD_DON_DAT_HANG_DETAIL ip_v_ds, decimal ip_id_don_hang) { CStoredProc v_store_proc = new CStoredProc("pr_Delete_don_hang_de"); v_store_proc.addDecimalInputParam("@ID_DON_HANG", ip_id_don_hang); v_store_proc.fillDataSetByCommand(this, ip_v_ds); }
public bool check_is_having_vpp_don_hang_de(decimal ip_id_vpp, decimal ip_id_don_hang) { DS_GD_DON_DAT_HANG_DETAIL v_ds = new DS_GD_DON_DAT_HANG_DETAIL(); CStoredProc v_cstore = new CStoredProc("pr_check_is_having_vpp_don_hang_de"); v_cstore.addNVarcharInputParam("@ID_VPP", ip_id_vpp); v_cstore.addDecimalInputParam("@ID_DON_HANG", ip_id_don_hang); v_cstore.fillDataSetByCommand(this, v_ds); if (v_ds.GD_DON_DAT_HANG_DETAIL.Rows.Count == 0) return false; return true; }