/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="SW">参见模型</param>
/// <returns>参见模型</returns>
public static bool isExists(T_SYS_PARAMETER_SW SW)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYS_PARAMETER where 1=1");
if (string.IsNullOrEmpty(SW.PARAMID) == false)
{
sb.AppendFormat(" and PARAMID='{0}'", ClsSql.EncodeSql(SW.PARAMID));
}
if (string.IsNullOrEmpty(SW.PARAMVALUE) == false)
{
sb.AppendFormat(" and PARAMVALUE='{0}'", ClsSql.EncodeSql(SW.PARAMVALUE));
}
if (string.IsNullOrEmpty(SW.PARAMNAME) == false)
{
sb.AppendFormat(" and PARAMNAME='{0}'", ClsSql.EncodeSql(SW.PARAMNAME));
}
if (string.IsNullOrEmpty(SW.PARAMFLAG) == false)
{
sb.AppendFormat(" and PARAMFLAG='{0}'", ClsSql.EncodeSql(SW.PARAMFLAG));
}
if (string.IsNullOrEmpty(SW.PARAMMARK) == false)
{
sb.AppendFormat(" and PARAMMARK='{0}'", ClsSql.EncodeSql(SW.PARAMMARK));
}
if (string.IsNullOrEmpty(SW.SYSFLAG) == false)
{
sb.AppendFormat(" and SYSFLAG='{0}'", ClsSql.EncodeSql(SW.SYSFLAG));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="SW">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_PARAMETER_Model getModel(T_SYS_PARAMETER_SW SW)
{
DataTable dt = BaseDT.T_SYS_PARAMETER.getDT(SW);
T_SYS_PARAMETER_Model m = new T_SYS_PARAMETER_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.PARAMID = dt.Rows[i]["PARAMID"].ToString();
m.PARAMFLAG = dt.Rows[i]["PARAMFLAG"].ToString();
m.PARAMNAME = dt.Rows[i]["PARAMNAME"].ToString();
m.PARAMVALUE = dt.Rows[i]["PARAMVALUE"].ToString();
m.PARAMMARK = dt.Rows[i]["PARAMMARK"].ToString();
//扩充字段
}
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYS_PARAMETER_Model> getListModel(T_SYS_PARAMETER_SW sw)
{
var result = new List <T_SYS_PARAMETER_Model>();
DataTable dt = BaseDT.T_SYS_PARAMETER.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_PARAMETER_Model m = new T_SYS_PARAMETER_Model();
m.PARAMID = dt.Rows[i]["PARAMID"].ToString();
m.PARAMFLAG = dt.Rows[i]["PARAMFLAG"].ToString();
m.PARAMNAME = dt.Rows[i]["PARAMNAME"].ToString();
m.PARAMVALUE = dt.Rows[i]["PARAMVALUE"].ToString();
m.PARAMMARK = dt.Rows[i]["PARAMMARK"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_PARAMETER_SW SW)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT PARAMID,PARAMFLAG,PARAMNAME,PARAMVALUE,PARAMMARK,SYSFLAG");
sb.AppendFormat(" FROM T_SYS_PARAMETER");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(SW.PARAMID) == false)
{
sb.AppendFormat(" AND PARAMID = '{0}'", ClsSql.EncodeSql(SW.PARAMID));
}
if (string.IsNullOrEmpty(SW.PARAMFLAG) == false)
{
sb.AppendFormat(" AND PARAMFLAG = '{0}'", ClsSql.EncodeSql(SW.PARAMFLAG));
}
if (string.IsNullOrEmpty(SW.PARAMNAME) == false)
{
sb.AppendFormat(" AND PARAMNAME = '{0}'", ClsSql.EncodeSql(SW.PARAMNAME));
}
if (string.IsNullOrEmpty(SW.PARAMVALUE) == false)
{
sb.AppendFormat(" AND PARAMVALUE = '{0}'", ClsSql.EncodeSql(SW.PARAMVALUE));
}
if (string.IsNullOrEmpty(SW.PARAMMARK) == false)
{
sb.AppendFormat(" AND PARAMMARK = '{0}'", ClsSql.EncodeSql(SW.PARAMMARK));
}
if (string.IsNullOrEmpty(SW.SYSFLAG) == false)
{
sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(SW.SYSFLAG));
}
sb.AppendFormat(" ORDER BY ORDERBY ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 根据系统标识和参数标识符获取参数值
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参数值</returns>
public static string getValueByFlag(T_SYS_PARAMETER_SW sw)
{
var v = getModel(sw);
return(v.PARAMVALUE);
}
