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