/// <summary>
/// 获取单条记录
/// </summary>
/// <returns></returns>
public static OD_DATE_Model getModel(OD_DATE_SW sw)
{
OD_DATE_Model m = new OD_DATE_Model();
DataTable dt = BaseDT.OD_DATE.getDT(sw);
if (dt.Rows.Count > 0)
{
int i = 0;
m.ONDUTYID = dt.Rows[i]["ONDUTYID"].ToString();
m.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
m.ONDUTYDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString());
m.WEEK = dt.Rows[i]["WEEK"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <OD_DATE_Model> getListModel(OD_DATE_SW sw)
{
var result = new List <OD_DATE_Model>();
DataTable dt = BaseDT.OD_DATE.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
OD_DATE_Model m = new OD_DATE_Model();
m.ONDUTYID = dt.Rows[i]["ONDUTYID"].ToString();
m.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
m.ONDUTYDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString());
m.WEEK = dt.Rows[i]["WEEK"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取DataTable
/// </summary>
/// <param name="sw">参见OD_ODTYPE_SW</param>
/// <returns>DataTable</returns>
public static DataTable getDT(OD_DATE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT ");
sb.AppendFormat(" ONDUTYID, OD_TYPEID, ONDUTYDATE, WEEK");
sb.AppendFormat(" FROM OD_DATE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.OD_TYPEID) == false)
{
sb.AppendFormat(" AND OD_TYPEID='{0}'", sw.OD_TYPEID);
}
if (string.IsNullOrEmpty(sw.DTBegin) == false)
{
sb.AppendFormat(" AND ONDUTYDATE>='{0}'", sw.DTBegin);
}
if (string.IsNullOrEmpty(sw.DTEnd) == false)
{
sb.AppendFormat(" AND ONDUTYDATE<='{0}'", sw.DTEnd);
}
sb.AppendFormat(" order by ONDUTYDATE");
return(DataBaseClass.FullDataSet(sb.ToString()).Tables[0]);
}
