/// <summary>
/// 添加返回当前记录的id
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Message Add(OD_ODTYPE_Model o)
{//增加判断该值班日期是否已存在
StringBuilder sbExits = new StringBuilder();
sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo());
sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND);
if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true)
{
return(new Message(false, "新建失败,在该值班日期范围内已存在历史值班日期！", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("insert into OD_TYPE(OD_TYPENAME,OD_DATEBEGIN,OD_DATEEND,BYORGNO) output inserted.OD_TYPEID values(");
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_TYPENAME));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEBEGIN));
sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEEND));
sb.AppendFormat("'{0}')", ClsSql.EncodeSql(SystemCls.getCurUserOrgNo()));
try
{
string strid = DataBaseClass.ReturnSqlField(sb.ToString());
return(new Message(true, "新建成功", strid));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <returns></returns>
public static IEnumerable <OD_ODTYPE_Model> GetOneData()
{
//var result = new List<O_ODUSER_Model>();
//var dt = BaseDT.O_OD_USER.GetModelList(od);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// O_ODUSER_Model ood = new O_ODUSER_Model();
// ood.BYORGNO = BaseDT.T_SYS_ORG.getName(dt, dt.Rows[i]["ORGNO"].ToString());
// ood.ONDUTYUSERTYPE = dt.Rows[i]["ONDUTYUSERTYPE"].ToString();
// ood.USERNAME = dt.Rows[i]["username"].ToString();
// ood.ISATTENDED = dt.Rows[i]["ISATTENDED"].ToString();
// ood.ONDUTYDATE = ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString());
// result.Add(ood);
//}
//dt.Clear();
//dt.Dispose();
//return result;
var result = new List <OD_ODTYPE_Model>();
var dt = BaseDT.OD_TYPE.GetOneData();
for (int i = 0; i < dt.Rows.Count; i++)
{
OD_ODTYPE_Model om = new OD_ODTYPE_Model();
om.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
om.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString();
om.OD_DATEBEGIN = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEBEGIN"].ToString());
om.OD_DATEEND = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEEND"].ToString());
result.Add(om);
}
dt.Clear();
dt.Dispose();
return(result);
}
///// <summary>
///// 获取排班日期表的日期与星期数据集合
///// </summary>
///// <returns></returns>
//public static IEnumerable<OD_DATE_Model> GetModelList()
//{
// var result = new List<OD_DATE_Model>();
// var dt = BaseDT.OD_DATE.GetModelList();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// OD_DATE_Model m = new OD_DATE_Model();
// m.WEEK = dt.Rows[i]["WEEK"].ToString();
// m.ONDUTYDATE = ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString());
// result.Add(m);
// }
// return result;
//}
//public static IEnumerable<OD_DATE_Model> GetDateModelList(OD_DATE_Model dm)
//{
// var result = new List<OD_DATE_Model>();
// var dt = BaseDT.OD_DATE.GetModelList(dm);
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// OD_DATE_Model m = new OD_DATE_Model();
// m.WEEK = dt.Rows[i]["WEEK"].ToString();
// m.ONDUTYDATE = ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString());
// result.Add(m);
// }
// return result;
//}
/// <summary>
/// 日期排班表的增加，删除，修改
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Message Manager(OD_ODTYPE_Model o)
{
if (o.op_Method == "Add")
{
return(BaseDT.OD_DATE.Add(o));
}
return(new Message(false, "无效操作", ""));
}
///// <summary>
///// 添加返回刚插入数据的id
///// </summary>
///// <param name="o"></param>
///// <returns></returns>
//public static string ADD(OD_ODTYPE_Model o)
//{
// return BaseDT.OD_TYPE.ADD(o);
//}
#region 对类别表进行管理 Message Manager(OD_ODTYPE_Model od)
/// <summary>
/// 根据标识op_Method执行修改操作
/// </summary>
/// <param name="od"></param>
/// <returns></returns>
public static Message Manager(OD_ODTYPE_Model od)
{
if (od.op_Method == "Mdy")
{
return(BaseDT.OD_TYPE.Mdy(od));
}
if (od.op_Method == "Add")
{
return(BaseDT.OD_TYPE.Add(od));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 获取带参数的数据集合
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static DataTable GetModelList(OD_ODTYPE_Model o)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select OD_TYPEID,OD_TYPENAME,OD_DATEBEGIN,OD_DATEEND from OD_TYPE where 1=1");
if (!string.IsNullOrEmpty(o.OD_TYPEID))
{
sb.AppendFormat(" and OD_TYPEID={0}", o.OD_TYPEID);
}
if (!string.IsNullOrEmpty(o.OD_TYPENAME))
{
sb.AppendFormat(" and OD_TYPENAME='{0}'", o.OD_TYPENAME);
}
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <returns></returns>
public static OD_ODTYPE_Model getModel(OD_ODTYPE_SW sw)
{
OD_ODTYPE_Model m = new OD_ODTYPE_Model();
DataTable dt = BaseDT.OD_TYPE.getDT(sw);
if (dt.Rows.Count > 0)
{
int i = 0;
m.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString();
m.OD_DATEBEGIN = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEBEGIN"].ToString());
m.OD_DATEEND = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEEND"].ToString());
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取数据集合
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static IEnumerable <OD_ODTYPE_Model> GetModelList(OD_ODTYPE_Model o)
{
var result = new List <OD_ODTYPE_Model>();
var dt = BaseDT.OD_TYPE.GetModelList(o);
for (int i = 0; i < dt.Rows.Count; i++)
{
OD_ODTYPE_Model om = new OD_ODTYPE_Model();
om.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
om.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString();
om.OD_DATEBEGIN = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEBEGIN"].ToString());
om.OD_DATEEND = ClsSwitch.SwitDate(dt.Rows[i]["OD_DATEEND"].ToString());
result.Add(om);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <OD_ODTYPE_Model> getListModel(OD_ODTYPE_SW sw)
{
var result = new List <OD_ODTYPE_Model>();
DataTable dt = BaseDT.OD_TYPE.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
OD_ODTYPE_Model m = new OD_ODTYPE_Model();
m.OD_TYPEID = dt.Rows[i]["OD_TYPEID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.OD_TYPENAME = dt.Rows[i]["OD_TYPENAME"].ToString();
m.OD_DATEBEGIN = dt.Rows[i]["OD_DATEBEGIN"].ToString();
m.OD_DATEEND = dt.Rows[i]["OD_DATEEND"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="o">对象</param>
/// <returns></returns>
public static Message Mdy(OD_ODTYPE_Model o)
{
if (string.IsNullOrEmpty(o.OD_TYPEID))
{
return(new Message(false, "修改ID不能为空", ""));
}
//增加判断该值班日期是否已存在
StringBuilder sbExits = new StringBuilder();
sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo());
sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND);
sbExits.AppendFormat("and OD_TYPEID<>'{0}'", o.OD_TYPEID);
if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true)
{
return(new Message(false, "重新生成失败,在该值班日期范围内已存在历史值班日期！", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("update OD_TYPE set");
sb.AppendFormat(" OD_TYPENAME='{0}',", ClsSql.EncodeSql(o.OD_TYPENAME));
sb.AppendFormat("OD_DATEBEGIN='{0}',", ClsSwitch.SwitDate(o.OD_DATEBEGIN));
sb.AppendFormat("OD_DATEEND='{0}'", ClsSwitch.SwitDate(o.OD_DATEEND));
if (!string.IsNullOrEmpty(o.OD_TYPEID))
{
sb.AppendFormat(" where OD_TYPEID={0}", ClsSql.EncodeSql(o.OD_TYPEID));
}
bool b = DataBaseClass.ExeSql(sb.ToString());
if (b)
{
return(new Message(true, "修改成功", o.OD_TYPEID));
}
else
{
return(new Message(false, "修改失败", ""));
}
}
/// <summary>
/// 值班日期表添加方法
/// </summary>
/// <param name="m">对象</param>
/// <returns></returns>
public static Message Add(OD_ODTYPE_Model m)
{
//if (o.Flog == "false")
//{
//先删除日期表中该类别下的日期
StringBuilder s = new StringBuilder();
s.AppendFormat("delete OD_DATE where 1=1 ");
s.AppendFormat(" and OD_TYPEID={0}", ClsSql.EncodeSql(m.OD_TYPEID.ToString()));
bool b = DataBaseClass.ExeSql(s.ToString());
//}
//执行插入
StringBuilder sCreate = new StringBuilder();
sCreate = sCreate.Append(" insert OD_DATE( OD_TYPEID,ONDUTYDATE, WEEK)select " + m.OD_TYPEID + ",dateadd(day,number,'" + m.OD_DATEBEGIN + "') as dt, ");
sCreate = sCreate.Append(" datename(weekday,dateadd(day,number,'" + m.OD_DATEBEGIN + "')) from master.dbo.spt_values where type ='P' ");
sCreate = sCreate.Append(" and number <=DATEDIFF(day, '" + m.OD_DATEBEGIN + "','" + m.OD_DATEEND + "')");
//删除不在值班日期之内的用户数据
StringBuilder sbUser = new StringBuilder();
sbUser.AppendFormat("delete from OD_USER where BYORGNO='{0}' ", m.BYORGNO);
sbUser.AppendFormat(" and OD_TYPEID='{0}'", m.OD_TYPEID);
sbUser.AppendFormat(" and (ONDUTYDATE<'{0}'", m.OD_DATEBEGIN);
sbUser.AppendFormat(" or ONDUTYDATE>'{0}')", m.OD_DATEEND);
DataBaseClassLibrary.DataBaseClass.ExeSql(sbUser.ToString());
if (DataBaseClass.ExeSql(sCreate.ToString()))
{
return(new Message(true, "生成成功！", m.OD_TYPEID.ToString()));
}
else
{
return(new Message(false, "生成失败！", ""));
}
}
