public void insertWeightTable(RateBO rate, WeightTableStruct weightTable) { SqlParameter[] sqlParams; SqlDataReader sqlDataRdr = base.GetDataReader("SELECT * FROM RateCode WHERE RateTypeCode='Table' AND RateSeqNum=" + rate.ID); sqlParams = base.GetParameters("DeleteRateCode"); while(sqlDataRdr.Read()) { sqlParams[fld_RateCodeSeqNum].Value = sqlDataRdr["RateCodeSeqNum"]; sqlParams[fld_RateSeqNum].Value = sqlDataRdr["RateSeqNum"]; sqlParams[fld_RateSchedSeqNum].Value = sqlDataRdr["RateSchedSeqNum"]; base.ExecuteDelete("DeleteRateCode", sqlParams); } base.CloseConnection(); sqlParams = base.GetParameters("UpdateRateCode"); sqlParams[fld_RateCodeSeqNum].Value = null; sqlParams[fld_RateSeqNum].Value = rate.ID; sqlParams[fld_RateSchedSeqNum].Value = rate.RateScheduleID; sqlParams[fld_RateCode].Value = weightTable.TableID; sqlParams[fld_RateTypeCode].Value = "Table"; base.ExecuteUpdate("UpdateRateCode", sqlParams); }
public WeightTableStruct getWeightTable(int rateID) { SqlDataReader sqlDataRdr = base.GetDataReader("SELECT RateCode, RateTypeCode FROM RateCode WHERE RateTypeCode='Table' AND RateSeqNum=" + rateID + " ORDER BY RateTypeCode ASC"); WeightTableStruct weightTable = new WeightTableStruct(1, "DEFAULT"); if(sqlDataRdr.Read()) { weightTable.TableID = Convert.ToInt16(sqlDataRdr["RateCode"]); sqlDataRdr = base.GetDataReader("SELECT DRGWgtName FROM DRGWgtID WHERE DRGWgtIDSeqNum=" + weightTable.TableID); if (sqlDataRdr.Read()) { weightTable.TableName = sqlDataRdr["DRGWgtName"].ToString(); } } base.CloseConnection(); return weightTable; }
public void setRate(int id, int in_RateScheduleID, string in_RateName, string in_RateCategory, string in_RateType, char in_InOut, CodesBO in_RateCodes, double in_Rate, int in_DRG_WgtTableID, string in_DRG_WgtTableName) { this.setMainRate(id, in_RateScheduleID, in_RateName, in_RateCategory, in_RateType, in_InOut, in_RateCodes); this.Rate = in_Rate; this.WeightTable = new WeightTableStruct(in_DRG_WgtTableID, in_DRG_WgtTableName); }