/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DUTY_HANDOVER_Model getModel(DUTY_HANDOVER_SW sw) { DataTable dt = BaseDT.Duty.DUTY_HANDOVER.getDT(sw); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { curOrgNo = sw.BYORGNO }); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { }); DUTY_HANDOVER_Model m = new DUTY_HANDOVER_Model(); if (dt.Rows.Count > 0) { int i = 0; m.DHID = dt.Rows[i]["DHID"].ToString(); m.DUTYDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["DUTYDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.DUTYUSERTYPE = dt.Rows[i]["DUTYUSERTYPE"].ToString(); m.DUTYTYPE = dt.Rows[i]["DUTYTYPE"].ToString(); m.DUTYUSERID = dt.Rows[i]["DUTYUSERID"].ToString(); m.OPTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["OPTIME"].ToString()); m.OPCONTENT = dt.Rows[i]["OPCONTENT"].ToString(); m.DUTYUSERName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DUTYUSERID); m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString()); } dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(m); }
/// <summary> /// 根据标识op_Method执行修改操作 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Manager(DUTY_HANDOVER_Model m) { if (m.opMethod == "Mdy") { return(BaseDT.Duty.DUTY_HANDOVER.Mdy(m)); } if (m.opMethod == "Add") { return(BaseDT.Duty.DUTY_HANDOVER.Add(m)); } if (m.opMethod == "Del") { return(BaseDT.Duty.DUTY_HANDOVER.Del(m)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(DUTY_HANDOVER_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete DUTY_HANDOVER"); sb.AppendFormat(" where DHID='{0}'", ClsSql.EncodeSql(m.DHID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message DelDayLog(DUTY_HANDOVER_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete DUTY_HANDOVER"); sb.AppendFormat(" where DUTYTYPE='{0}'", "-3"); sb.AppendFormat(" and DUTYDATE='{0}'", m.DUTYDATE); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(DUTY_HANDOVER_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE DUTY_HANDOVER"); sb.AppendFormat(" set "); sb.AppendFormat(" OPTIME='{0}'", PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now)); if (string.IsNullOrEmpty(m.DUTYDATE) == false) { sb.AppendFormat(",DUTYDATE='{0}'", ClsSql.EncodeSql(m.DUTYDATE)); } if (string.IsNullOrEmpty(m.BYORGNO) == false) { sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); } if (string.IsNullOrEmpty(m.DUTYUSERTYPE) == false) { sb.AppendFormat(",DUTYUSERTYPE='{0}'", ClsSql.EncodeSql(m.DUTYUSERTYPE)); } if (string.IsNullOrEmpty(m.DUTYTYPE) == false) { sb.AppendFormat(",DUTYTYPE='{0}'", ClsSql.EncodeSql(m.DUTYTYPE)); } if (string.IsNullOrEmpty(m.DUTYUSERID) == false) { sb.AppendFormat(",DUTYUSERID='{0}'", ClsSql.EncodeSql(m.DUTYUSERID)); } if (string.IsNullOrEmpty(m.OPCONTENT) == false) { sb.AppendFormat(",OPCONTENT='{0}'", ClsSql.EncodeSql(m.OPCONTENT)); } sb.AppendFormat(" where ODHID='{0}'", ClsSql.EncodeSql(m.DHID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(DUTY_HANDOVER_Model m) { if (m.DUTYTYPE == "-3")//如果是填写日志 { if (isExists(new DUTY_HANDOVER_SW { DUTYTYPE = "-3", DUTYDATE = m.DUTYDATE }) == true) //先删除当天日志 { DelDayLog(new DUTY_HANDOVER_Model { DUTYTYPE = "-3", DUTYDATE = m.DUTYDATE }); } } StringBuilder sb = new StringBuilder(); sb.AppendFormat("insert DUTY_HANDOVER(DUTYDATE, BYORGNO, DUTYUSERTYPE, DUTYTYPE, DUTYUSERID, OPTIME, OPCONTENT)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.DUTYDATE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DUTYUSERTYPE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DUTYTYPE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DUTYUSERID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPCONTENT)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }