/// <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, "生成失败!", "")); } }