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