/// <summary>
/// 获取模型
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static ART_TYPE_Model getModel(ART_TYPE_SW sw)
{
DataTable dt = BaseDT.ART_TYPE.getDT(sw);
ART_TYPE_Model m = new ART_TYPE_Model();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
int i = 0;
m.ARTTYPEID = dt.Rows[i]["ARTTYPEID"].ToString();
m.ARTTYPENAME = dt.Rows[i]["ARTTYPENAME"].ToString();
m.ARTTYPERID = dt.Rows[i]["ARTTYPERID"].ToString();
m.ISCHECKED = dt.Rows[i]["ISCHECKED"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
}
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <ART_TYPE_Model> getListModel(ART_TYPE_SW sw)
{
var result = new List <ART_TYPE_Model>();
DataTable dt = BaseDT.ART_TYPE.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
ART_TYPE_Model m = new ART_TYPE_Model();
m.ARTTYPEID = dt.Rows[i]["ARTTYPEID"].ToString();
m.ARTTYPENAME = dt.Rows[i]["ARTTYPENAME"].ToString();
m.ARTTYPERID = dt.Rows[i]["ARTTYPERID"].ToString();
m.ISCHECKED = dt.Rows[i]["ISCHECKED"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(ART_TYPE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT ARTTYPEID, ARTTYPENAME, ARTTYPERID, ISCHECKED, ORDERBY");
sb.AppendFormat(" FROM ART_TYPE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.ARTTYPEID) == false)
{
sb.AppendFormat(" AND ARTTYPEID = '{0}'", ClsSql.EncodeSql(sw.ARTTYPEID));
}
if (string.IsNullOrEmpty(sw.ARTTYPERID) == false)
{
sb.AppendFormat(" AND ARTTYPERID = '{0}'", ClsSql.EncodeSql(sw.ARTTYPERID));
}
//if (string.IsNullOrEmpty(sw.USERID) == false)
// sb.AppendFormat(" AND USERID = '{0}'", ClsSql.EncodeSql(sw.USERID));
sb.AppendFormat(" ORDER BY ORDERBY ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
