/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_CONSULTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO PEST_CONSULTATION( CONSULTITLE, CONSULPHONE, CONSULTIME, CONSULCONTENT)"); sb.AppendFormat(" OUTPUT INSERTED.PEST_CONSULTATIONID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.CONSULTITLE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.CONSULPHONE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.CONSULTIME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.CONSULCONTENT)); sb.AppendFormat(")"); try { string sId = DataBaseClass.ReturnSqlField(sb.ToString()); if (sId != "") { return(new Message(true, "添加成功!", sId)); } else { return(new Message(false, "添加失败!", "")); } } catch { return(new Message(false, "添加失败!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(PEST_CONSULTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete PEST_CONSULTATION"); sb.AppendFormat(" where PEST_CONSULTATIONID= '{0}'", ClsSql.EncodeSql(m.PEST_CONSULTATIONID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败!", "")); } }
/// <summary> /// 获取单条数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_CONSULTATION_Model getModel(PEST_CONSULTATION_SW sw) { DataTable dt = BaseDT.PEST_CONSULTATION.getDT(sw);//列表 PEST_CONSULTATION_Model m = new PEST_CONSULTATION_Model(); if (dt.Rows.Count > 0) { int i = 0; m.PEST_CONSULTATIONID = dt.Rows[i]["PEST_CONSULTATIONID"].ToString(); m.CONSULTITLE = dt.Rows[i]["CONSULTITLE"].ToString(); m.CONSULPHONE = dt.Rows[i]["CONSULPHONE"].ToString(); m.CONSULTIME = ClsSwitch.SwitMN(dt.Rows[i]["CONSULTIME"].ToString()); m.CONSULCONTENT = dt.Rows[i]["CONSULCONTENT"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static IEnumerable <PEST_CONSULTATION_Model> getListModel(PEST_CONSULTATION_SW sw, out int total) { var result = new List <PEST_CONSULTATION_Model>(); DataTable dt = BaseDT.PEST_CONSULTATION.getDT(sw, out total);//列表 for (int i = 0; i < dt.Rows.Count; i++) { PEST_CONSULTATION_Model m = new PEST_CONSULTATION_Model(); m.PEST_CONSULTATIONID = dt.Rows[i]["PEST_CONSULTATIONID"].ToString(); m.CONSULTITLE = dt.Rows[i]["CONSULTITLE"].ToString(); m.CONSULPHONE = dt.Rows[i]["CONSULPHONE"].ToString(); m.CONSULTIME = ClsSwitch.SwitMN(dt.Rows[i]["CONSULTIME"].ToString()); m.CONSULCONTENT = dt.Rows[i]["CONSULCONTENT"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_CONSULTATION_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_CONSULTATION.Add(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Mdy") { Message msg = BaseDT.PEST_CONSULTATION.Mdy(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Del") { Message msg = BaseDT.PEST_CONSULTATION.Del(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(PEST_CONSULTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE PEST_CONSULTATION SET "); sb.AppendFormat(" CONSULTITLE={0}", ClsSql.saveNullField(m.CONSULTITLE)); sb.AppendFormat(",CONSULPHONE={0}", ClsSql.saveNullField(m.CONSULPHONE)); sb.AppendFormat(",CONSULCONTENT={0}", ClsSql.saveNullField(m.CONSULCONTENT)); sb.AppendFormat(" WHERE PEST_CONSULTATIONID= '{0}'", ClsSql.EncodeSql(m.PEST_CONSULTATIONID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.PEST_CONSULTATIONID)); } else { return(new Message(false, "修改失败!", "")); } }