SQLite查询系统参数

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

public static int GetParameterValue(string parameterName)        {            var ds = GetDataSet(connString, string.Format("select * from SystemParameter where ParameterName='{0}'", parameterName));            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)            {                int returnValue = 0;                try                {                    returnValue = Convert.ToInt32(ds.Tables[0].Rows[0]["ParameterValue"]);                }                catch                {                    throw new Exception("SQLite查询系统参数[" + parameterName + "]异常");                }                return returnValue;            }            else            {                throw new Exception("SQLite查询系统参数[" + parameterName + "]异常");            }        }

 尝试用一种非常规的方式，学习，理解代码，不急功近利，切记做好一件事，做完美。不断优化，改正，修正