public static A2ZHRPARAMETERDTO GetParameterValue() { A2ZHRPARAMETERDTO p = new A2ZHRPARAMETERDTO(); DataTable dt = CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZHRPARAMETER", "A2ZHRMCUS"); p.CurrentMonth = Converter.GetSmallInteger(dt.Rows[0]["CurrentMonth"]); p.FinancialMonth = Converter.GetSmallInteger(dt.Rows[0]["FinancialMonth"]); p.CurrentYear = Converter.GetSmallInteger(dt.Rows[0]["CurrentYear"]); p.SystemBatchNo = Converter.GetString(dt.Rows[0]["SystemBatchNo"]); p.IncomeCode = Converter.GetLong(dt.Rows[0]["IncomeCode"]); p.PLCode = Converter.GetLong(dt.Rows[0]["PLCode"]); p.BackupDir = Converter.GetString(dt.Rows[0]["BackupDir"]); p.FinancialMonth = Converter.GetSmallInteger(dt.Rows[0]["FinancialMonth"]); p.FinancialBegYear = Converter.GetSmallInteger(dt.Rows[0]["FinancialBegYear"]); p.FinancialEndYear = Converter.GetSmallInteger(dt.Rows[0]["FinancialEndYear"]); p.ProcessDate = Converter.GetDateTime(dt.Rows[0]["ProcessDate"]); return(p); }
public static int UpdateParameterValue(A2ZHRPARAMETERDTO dto) { string strQuery = "UPDATE A2ZHRPARAMETER SET BackupDir ='" + dto.BackupDir + "' WHERE SystemBatchNo='" + dto.SystemBatchNo + "'"; return(Converter.GetInteger(CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"))); }