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