/// <summary>
/// 发表反馈
/// </summary>
/// <param name="model"></param>
/// <returns>返回ID</returns>
public static int Insert(CompanyFeedbackInfo model) {
string strSQL = "INSERT INTO CompanyFeedback(UserId,RealName,CompanyName,Phone,Email,[Type],Content,ForCompanyId,IP) VALUES (@UserId,@RealName,@CompanyName,@Phone,@Email,@Type,@Content,@ForCompanyId,@IP);SELECT @@IDENTITY;";
SqlParameter[] parms = {
new SqlParameter("UserId",SqlDbType.Int),
new SqlParameter("RealName",SqlDbType.NVarChar),
new SqlParameter("CompanyName",SqlDbType.NVarChar),
new SqlParameter("Phone",SqlDbType.NVarChar),
new SqlParameter("Email",SqlDbType.NVarChar),
new SqlParameter("Type",SqlDbType.NVarChar),
new SqlParameter("Content",SqlDbType.NVarChar),
new SqlParameter("ForCompanyId",SqlDbType.Int),
new SqlParameter("IP",SqlDbType.NVarChar),
};
parms[0].Value = model.UserId;
parms[1].Value = model.RealName;
parms[2].Value = model.CompanyName;
parms[3].Value = model.Phone;
parms[4].Value = model.Email;
parms[5].Value = model.Type;
parms[6].Value = model.Content;
parms[7].Value = model.ForCompanyId;
parms[8].Value = model.IP;
return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms));
}
/// <summary>
/// 发表反馈
/// </summary>
/// <param name="model"></param>
/// <returns>返回ID</returns>
public static int Insert(CompanyFeedbackInfo model)
{
return CompanyFeedbackManage.Insert(model);
}
