/// <summary> /// 增加一条数据 /// </summary> public bool Add(RC403ZhangChenYang.TMessage_Model.TMessage_data model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TMessage("); strSql.Append("QQId,QQFriendID,messagetime,message)"); strSql.Append(" values ("); strSql.Append("@QQId,@QQFriendID,@messagetime,@message)"); SqlParameter[] parameters = { new SqlParameter("@QQId", SqlDbType.NVarChar, 16), new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), new SqlParameter("@messagetime", SqlDbType.DateTime), new SqlParameter("@message", SqlDbType.NVarChar, 512) }; parameters[0].Value = model.QQId; parameters[1].Value = model.QQFriendID; parameters[2].Value = model.messagetime; parameters[3].Value = model.message; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RC403ZhangChenYang.TMessage_Model.TMessage_data model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TMessage set "); strSql.Append("QQFriendID=@QQFriendID,"); strSql.Append("messagetime=@messagetime,"); strSql.Append("message=@message"); strSql.Append(" where QQId=@QQId "); SqlParameter[] parameters = { new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), new SqlParameter("@messagetime", SqlDbType.DateTime), new SqlParameter("@message", SqlDbType.NVarChar, 512), new SqlParameter("@QQId", SqlDbType.NVarChar, 16) }; parameters[0].Value = model.QQFriendID; parameters[1].Value = model.messagetime; parameters[2].Value = model.message; parameters[3].Value = model.QQId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public RC403ZhangChenYang.TMessage_Model.TMessage_data GetModel(string QQID, string QQFriendID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QQId,QQFriendID,messagetime,message from TMessage "); strSql.Append(" where QQID=@QQID and QQFriendID=@QQFriendID "); SqlParameter[] parameters = { new SqlParameter("@QQID", SqlDbType.NVarChar, 16), new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), }; parameters[0].Value = QQID; parameters[1].Value = QQFriendID; RC403ZhangChenYang.TMessage_Model.TMessage_data model = new RC403ZhangChenYang.TMessage_Model.TMessage_data(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["QQId"] != null && ds.Tables[0].Rows[0]["QQId"].ToString() != "") { model.QQId = ds.Tables[0].Rows[0]["QQId"].ToString(); } if (ds.Tables[0].Rows[0]["QQFriendID"] != null && ds.Tables[0].Rows[0]["QQFriendID"].ToString() != "") { model.QQFriendID = ds.Tables[0].Rows[0]["QQFriendID"].ToString(); } if (ds.Tables[0].Rows[0]["messagetime"] != null && ds.Tables[0].Rows[0]["messagetime"].ToString() != "") { model.messagetime = DateTime.Parse(ds.Tables[0].Rows[0]["messagetime"].ToString()); } if (ds.Tables[0].Rows[0]["message"] != null && ds.Tables[0].Rows[0]["message"].ToString() != "") { model.message = ds.Tables[0].Rows[0]["message"].ToString(); } return(model); } else { return(null); } }