/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(PEST_PHOTO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" DELETE PEST_PHOTO"); sb.AppendFormat(" WHERE PEST_PHOTOID= '{0}'", ClsSql.EncodeSql(m.PEST_PHOTOID)); 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_PHOTO_Model getModel(PEST_PHOTO_SW sw) { PEST_PHOTO_Model m = new PEST_PHOTO_Model(); DataTable dt = BaseDT.PEST_PHOTO.getDT(sw);//列表 if (dt.Rows.Count > 0) { int i = 0; m.PEST_PHOTOID = dt.Rows[i]["PEST_PHOTOID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = ClsSwitch.SwitTM(dt.Rows[i]["PHOTOTIME"].ToString()); m.PHOTOTYPE = dt.Rows[i]["PHOTOTYPE"].ToString(); m.PRID = dt.Rows[i]["PRID"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <PEST_PHOTO_Model> getModelList(PEST_PHOTO_SW sw) { var result = new List <PEST_PHOTO_Model>(); DataTable dt = BaseDT.PEST_PHOTO.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { PEST_PHOTO_Model m = new PEST_PHOTO_Model(); m.PEST_PHOTOID = dt.Rows[i]["PEST_PHOTOID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = ClsSwitch.SwitTM(dt.Rows[i]["PHOTOTIME"].ToString()); m.PHOTOTYPE = dt.Rows[i]["PHOTOTYPE"].ToString(); m.PRID = dt.Rows[i]["PRID"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message MdyTP(PEST_PHOTO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE PEST_PHOTO SET"); sb.AppendFormat(" PHOTOTITLE={0}", ClsSql.saveNullField(m.PHOTOTITLE)); sb.AppendFormat(",PHOTOEXPLAIN={0}", ClsSql.saveNullField(m.PHOTOEXPLAIN)); sb.AppendFormat(",PHOTOTIME={0}", ClsSql.saveNullField(m.PHOTOTIME)); sb.AppendFormat(",PHOTOTYPE={0}", ClsSql.saveNullField(m.PHOTOTYPE)); sb.AppendFormat(",PRID={0}", ClsSql.saveNullField(m.PRID)); sb.AppendFormat(" WHERE PEST_PHOTOID= '{0}'", ClsSql.EncodeSql(m.PEST_PHOTOID)); 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(PEST_PHOTO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO PEST_PHOTO(PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID) VALUES( "); sb.AppendFormat(" {0}", ClsSql.saveNullField(m.PHOTOTITLE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PHOTOFILENAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PHOTOEXPLAIN)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PHOTOTIME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PHOTOTYPE)); sb.AppendFormat(",{0})", ClsSql.saveNullField(m.PRID)); 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>参见模型Message</returns> public static Message Manager(PEST_PHOTO_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_PHOTO.Add(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Mdy") { Message msg = BaseDT.PEST_PHOTO.Mdy(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "MdyTP") { Message msg = BaseDT.PEST_PHOTO.MdyTP(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Del") { Message msg = BaseDT.PEST_PHOTO.Del(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } return(new Message(false, "无效操作", m.returnUrl)); }