/// <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>
/// 带参数值班日期表数据集合查询
/// </summary>
/// <param name="dm"></param>
/// <returns></returns>
public static DataTable GetModelList(OD_DATE_Model dm)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select ONDUTYDATE,WEEK from OD_DATE where 1=1 ");
if (dm.ODTYPEID != 0)
{
sb.AppendFormat(" and OD_TYPEID={0}", dm.ODTYPEID);
}
if (!string.IsNullOrEmpty(dm.ONDUTYDATE))
{
sb.AppendFormat(" and ONDUTYDATE>='{0}'", ClsSql.EncodeSql(dm.ONDUTYDATE));
}
//if (!string.IsNullOrEmpty(dm.ONDUTYYEAR))
// sb.AppendFormat(" and ONDUTYDATE<='{0}'", ClsSql.EncodeSql(dm.ONDUTYYEAR));
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
