public ActionResult Index(FormCollection fc) { var content = fc["editor"]; string contents = content.Replace("<p>", ""); string contesnt1 = contents.Replace("</p>", ""); int pid = Convert.ToInt32(Request["PId"]); int uid = Convert.ToInt32(Session["userId"]); //涉及外键时,先查询后插入 Model.Users users = userInfoBll.LoadEntity(m => m.userId == uid).FirstOrDefault(); int userId = users.userId; Model.Remark remark = new Model.Remark() { remarkId = Convert.ToInt32(XCommon.CreateId.CreateNum()), remTime = DateTime.Now.ToString("yyyy-MM-dd-hh"), userId1 = userId, remTxt = contesnt1, productId = pid, }; if (remarkBll.addEntity(remark)) { return(RedirectToAction("Details", "Product", new { id = pid })); } else { return(Content("<script>alert('出错了')</script>")); } }
public static DataContract.Remark ToDataContract(this Model.Remark remark) { if (remark == null) { return(null); } return(new DataContract.Remark() { Text = remark.Text, CreateTimeStamp = remark.CreateTimeStamp }); }
public Model.Employee Get(string employeeId) { try { Model.Employee emp = new Model.Employee(); List<Model.Remark> tempRemark = new List<Model.Remark>(); SqlConnection conEmp = new SqlConnection("Data Source=TRAINING12;Initial Catalog=Employee;User ID=sa;Password=test123!@#"); SqlConnection conEmpRemark = new SqlConnection("Data Source=TRAINING12;Initial Catalog=Employee;User ID=sa;Password=test123!@#"); conEmp.Open(); conEmpRemark.Open(); SqlCommand cmd = new SqlCommand("GetbyId", conEmp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Id", employeeId)); SqlDataReader empReader = cmd.ExecuteReader(); while (empReader.Read()) { emp.Id = empReader[0].ToString(); emp.FirstName = empReader[1].ToString(); emp.LastName = empReader[2].ToString(); emp.Title = empReader[3].ToString(); emp.Email = empReader[4].ToString(); emp.Phone = empReader[5].ToString(); emp.JoiningDate = DateTime.Parse(empReader[6].ToString()); SqlCommand cmdRemark = new SqlCommand("GetRemarkById", conEmpRemark); cmdRemark.CommandType = CommandType.StoredProcedure; cmdRemark.Parameters.Add(new SqlParameter("@Id", emp.Id)); SqlDataReader empRemarkReader = cmdRemark.ExecuteReader(); while (empRemarkReader.Read()) { Model.Remark remark = new Model.Remark(); remark.Text = empRemarkReader[2].ToString(); remark.CreateTimeStamp = Convert.ToDateTime(empRemarkReader[3].ToString()); tempRemark.Add(remark); } } emp.Remarks = tempRemark; conEmp.Close(); conEmpRemark.Close(); return emp; } catch (Exception ex) { var rethrow = ExceptionPolicy.HandleException("data.policy", ex); if (rethrow) throw; return null; } }