private decimal find_hs_lns(decimal ip_dc_id_ma_lns, decimal ip_dc_id_muc_lns) { try { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); string v_str_filter = "ID_MA_LNS = " + ip_dc_id_ma_lns + " AND ID_MUC_LNS = " + ip_dc_id_muc_lns; DataRow[] v_dr = v_ds.DM_HE_SO_LUONG_NS.Select(v_str_filter); if (v_dr.Count() == 0) { return 0; } else { return CIPConvert.ToDecimal(v_dr.First()["HE_SO"].ToString()); } } catch (Exception v_e) { throw v_e; } }
public US_DM_HE_SO_LUONG_NS(decimal i_dbID) { pm_objDS = new DS_DM_HE_SO_LUONG_NS(); 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 bool check_ma_muc_da_ton_tai() { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); decimal v_id_ma = CIPConvert.ToDecimal(m_sle_ma_lns.EditValue); decimal v_id_muc = CIPConvert.ToDecimal(m_sle_muc_lns.EditValue); v_us.FillDataset(v_ds, "where id_ma_lns = " + v_id_ma + "and id_muc_lns =" + v_id_muc); if ((m_us.dcID_MA_LNS != v_id_ma || m_us.dcID_MUC_LNS != v_id_muc) && v_ds.Tables[0].Rows.Count != 0) { return true; } return false; }
private void focus_new_row_created(decimal ip_dc_id_dm_dv) { int v_row_index = 0; decimal v_id_qd_moi_lap = 0; US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_id_qd_moi_lap = ip_dc_id_dm_dv; v_us.FillDataset(v_ds); for (v_row_index = 0; v_row_index < v_ds.Tables[0].Rows.Count; v_row_index++) { var v_id_gd_qd = CIPConvert.ToDecimal(m_grv_dm_he_so_luong_ns.GetDataRow(v_row_index)["ID"].ToString()); if (v_id_gd_qd == v_id_qd_moi_lap) { break; } } m_grv_dm_he_so_luong_ns.FocusedRowHandle = v_row_index; }
private string load_data_to_lbl_he_so_lns() { if (m_sle_ma_lns.EditValue != null && m_sle_muc_lns.EditValue != null) { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); string v_str_filter = "ID_MA_LNS = " + m_sle_ma_lns.EditValue + " AND ID_MUC_LNS = " + m_sle_muc_lns.EditValue; DataRow[] v_dr = v_ds.DM_HE_SO_LUONG_NS.Select(v_str_filter); if (v_dr.Count() == 0) { return ""; } else { return v_dr.First()["HE_SO"].ToString().ToString(); } } else { return ""; } }
private decimal find_id_hs_lns() { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); string v_str_filter = "ID_MA_LNS = " + m_sle_ma_lns.EditValue + " AND ID_MUC_LNS = " + m_sle_muc_lns.EditValue; DataRow[] v_dr = v_ds.DM_HE_SO_LUONG_NS.Select(v_str_filter); if (v_dr.Count() == 0) { return -1; } else { return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString()); } }
private decimal find_id_hs_lns_by_ma_muc(string ma_lns, string muc_lns) { try { decimal id_ma_lns = (from DataRow dr in m_dt_ma_lns.Rows where (string)dr[CM_DM_TU_DIEN.MA_TU_DIEN] == ma_lns select (decimal)dr[CM_DM_TU_DIEN.ID]).FirstOrDefault(); decimal id_muc_lns = (from DataRow dr in m_dt_muc_lns.Rows where (string)dr[CM_DM_TU_DIEN.MA_TU_DIEN] == muc_lns select (decimal)dr[CM_DM_TU_DIEN.ID]).FirstOrDefault(); US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); decimal id_lns = (from DataRow dr in v_ds.Tables[0].Rows where (decimal)dr["ID_MA_LNS"] == id_ma_lns & (decimal)dr["ID_MUC_LNS"] == id_muc_lns select (decimal)dr["ID"]).FirstOrDefault(); return id_lns; } catch(Exception v_e) { throw v_e; } }
private decimal find_id_muc_lns(decimal ip_dc_id_hs_lns) { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); string v_str_filter = "ID = " + ip_dc_id_hs_lns; DataRow[] v_dr = v_ds.DM_HE_SO_LUONG_NS.Select(v_str_filter); if (v_dr.Count() == 0) { return -1; } else { return CIPConvert.ToDecimal(v_dr.First()["ID_MUC_LNS"].ToString()); } }
private DS_DM_HE_SO_LUONG_NS load_data_2_dm_loai_don_vi() { DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_us = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); return v_ds; }
private decimal find_hs_lns() { if(m_sle_chuc_danh_lns.EditValue != null && m_sle_muc_lns.EditValue != null) { US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS(); DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS(); v_us.FillDataset(v_ds); string v_str_filter = "ID_MA_LNS = " + m_sle_chuc_danh_lns.EditValue + " AND ID_MUC_LNS = " + m_sle_muc_lns.EditValue; DataRow[] v_dr = v_ds.DM_HE_SO_LUONG_NS.Select(v_str_filter); if(v_dr.Count() == 0) { return 0; } else { return Convert.ToDecimal(v_dr.First()["HE_SO"]); } } else { return 0; } }
public US_DM_HE_SO_LUONG_NS() { pm_objDS = new DS_DM_HE_SO_LUONG_NS(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void FillDatasetTheoIDMaMuc(DS_DM_HE_SO_LUONG_NS v_ds, string id_ma_lns, string id_muc_lns) { CStoredProc v_cstore = new CStoredProc("pr_LNS_get_he_so_theo_ID_ma_muc"); v_cstore.addDecimalInputParam("@id_ma_lns", id_ma_lns); v_cstore.addDecimalInputParam("@id_muc_lns", id_muc_lns); v_cstore.fillDataSetByCommand(this, v_ds); }