/// <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);
}
}
