110,502
社区成员
发帖
与我相关
我的任务
分享
SuggestWebService.SuggestionInfo suggest = new SuggestWebService.SuggestionInfo
{
Content = content,
Email = email,
AppName = "ios",
TimeStamp = DateTime.Now
};
SuggestWebService.SuggestWebServiceSoapClient suggestService = new SuggestWebService.SuggestWebServiceSoapClient("SuggestWebServiceSoap");
int a = suggestService.AddSuggestion(suggest);
[WebMethod]
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns>受影响行数</returns>
public int AddSuggestion(SuggestionInfo entity)
{
string cmdText = @"INSERT INTO `SuggestionInfo` (`appName`,`Email`,`content`,`timeStamp`)
VALUES (?appName,?Email,?content,?timeStamp);
";
MySqlParameter[] cmdParam = {
new MySqlParameter("?appName",entity.AppName),
new MySqlParameter("?Email",entity.Email),
new MySqlParameter("?content",entity.Content),
new MySqlParameter("?timeStamp",entity.TimeStamp)
};
return DBHelper.ExecuteNonQuery(cmdText, cmdParam);
}
[Serializable]
public class SuggestionInfo
{
#region 字段
private int _id;
private string _appName;
private string _email;
private string _content;
private DateTime _timeStamp;
#endregion
/// <summary>
/// 标识
/// </summary>
public int Id
{
get { return _id; }
set { _id = value; }
}
/// <summary>
/// 所属 应用
/// </summary>
public string AppName
{
get { return _appName; }
set { _appName = value; }
}
/// <summary>
/// 投诉者邮箱
/// </summary>
public string Email
{
get { return _email; }
set { _email = value; }
}
/// <summary>
/// 建议内容
/// </summary>
public string Content
{
get { return _content; }
set { _content = value; }
}
/// <summary>
/// 时间戳
/// </summary>
public DateTime TimeStamp
{
get { return _timeStamp; }
set { _timeStamp = value; }
}
}