public ActionResult Index(FeedbackInfo model,FormCollection fc) {
/*
* 设置_CommmonLayout.cshtml中的变量
*/
ViewBag.RootCategoryInfo = ViewBag.CurrentCategoryInfo = CategoryService.Get(GeneralConfig.FeedbackRootId);
bool errors = false;
if(string.IsNullOrEmpty(model.Title)){
errors = true;
ModelState.AddModelError("Title", "请输入投诉(建议)标题");
}
if(string.IsNullOrEmpty(model.Content)){
errors = true;
ModelState.AddModelError("Content", "请输入投诉(建议)内容");
}
if(ModelState.IsValid && !errors){
//过滤掉内容HTML
model.Content = Goodspeed.Library.Char.HtmlHelper.RemoveHtml(model.Content);
int id = FeedbackService.Create(model).Id;
ViewBag.Status = false;
if(id>0){
ViewBag.Status = true;
}
}
return View();
}
/// <summary>
/// 添加或编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static FeedbackInfo Create(FeedbackInfo model) {
if(model.Id == 0){
int id = FeedbackManage.Insert(model);
model.Id = id;
}
return model;
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(FeedbackInfo model) {
string strSQL = "INSERT INTO Feedback(Title,Content,[Address],Contact,Email,Phone,Fax,CreateDateTime,IsDeleted) VALUES(@Title,@Content,@Address,@Contact,@Email,@Phone,@Fax,GETDATE(),0);SELECT @@IDENTITY;";
SqlParameter[] param = {
new SqlParameter("Title",SqlDbType.NVarChar),
new SqlParameter("Content",SqlDbType.NVarChar),
new SqlParameter("Address",SqlDbType.NVarChar),
new SqlParameter("Contact",SqlDbType.NVarChar),
new SqlParameter("Email",SqlDbType.NVarChar),
new SqlParameter("Phone",SqlDbType.NVarChar),
new SqlParameter("Fax",SqlDbType.NVarChar),
};
param[0].Value = model.Title ?? string.Empty;
param[1].Value = model.Content ?? string.Empty;
param[2].Value = model.Address ?? string.Empty;
param[3].Value = model.Contact ?? string.Empty;
param[4].Value = model.Email ?? string.Empty;
param[5].Value = model.Phone ?? string.Empty;
param[6].Value = model.Fax ?? string.Empty;
return Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text,strSQL,param));
}
