//
// GET: /Jianyan/
public ActionResult Index(int?p, int id)
{
Pager pager = new Pager();
pager.table = "CMSJianyan";
pager.strwhere = "JianyanCustomerId=" + id;
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "JianyanId";
pager.FiledOrder = "JianyanId Desc";
pager = CMSService.SelectAll("Jianyan", pager);
List <JianyanDto> list = new List <JianyanDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
JianyanDto dto = JianyanMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewBag.CustomerId = id;
ViewBag.CustomerName = MyService.CustomerIdToName("CustomerId=" + id);
return(View(pager.Entity));
}
public SqlParameter[] JsonStringToSqlParameter(string jsonString)
{
SqlParameter[] arParames = new SqlParameter[7];
JianyanDto jianyanDto = JsonHelper.JsonDeserializeBySingleData <JianyanDto>(jsonString);
arParames[0] = new SqlParameter("@JianyanId", SqlDbType.Int);
arParames[0].Value = jianyanDto.JianyanId;
arParames[1] = new SqlParameter("@JianyanCustomerId", SqlDbType.Int);
arParames[1].Value = jianyanDto.JianyanCustomerId;
arParames[2] = new SqlParameter("@JianyanCategory", SqlDbType.VarChar, 50);
arParames[2].Value = jianyanDto.JianyanCategory;
arParames[3] = new SqlParameter("@JianyanDescription", SqlDbType.VarChar, 5000);
arParames[3].Value = jianyanDto.JianyanDescription;
arParames[4] = new SqlParameter("@JianyanImg", SqlDbType.VarChar, 500);
arParames[4].Value = jianyanDto.JianyanImg;
arParames[5] = new SqlParameter("@JianyanTime", SqlDbType.DateTime);
arParames[5].Value = jianyanDto.JianyanTime;
arParames[6] = new SqlParameter("@JianyanDoctor", SqlDbType.Int);
arParames[6].Value = jianyanDto.JianyanDoctor;
return(arParames);
}
public static JianyanDto getDTO(DataRow dr)
{
JianyanDto dto = new JianyanDto();
dto.JianyanId = int.Parse(dr["JianyanId"].ToString());
dto.JianyanCustomerId = int.Parse(dr["JianyanCustomerId"].ToString());
dto.JianyanImg = dr["JianyanImg"].ToString();
dto.JianyanCategory = dr["JianyanCategory"].ToString();
dto.JianyanDescription = dr["JianyanDescription"].ToString();
dto.JianyanTime = DateTime.Parse(dr["JianyanTime"].ToString());
dto.JianyanDoctor = int.Parse(dr["JianyanDoctor"].ToString());
return(dto);
}
public ActionResult Create(JianyanAddViewModel model)
{
try
{
JianyanDto dto = new JianyanDto();
dto.JianyanCategory = model.JianyanCategory;
dto.JianyanImg = model.JianyanImg;
dto.JianyanDescription = model.JianyanDescription;
dto.JianyanCustomerId = model.JianyanCustomerId;
dto.JianyanTime = System.DateTime.Now;
dto.JianyanDoctor = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserId"].Value);
string JsonString = JsonHelper.JsonSerializerBySingleData(dto);
Message msg = CMSService.Insert("Jianyan", JsonString);
return(RedirectTo("/Jianyan/Index/" + dto.JianyanCustomerId, msg.MessageInfo));
}
catch
{
Message msg = new Message();
msg.MessageInfo = "好像没上传图片，请点击上传按钮后在提交";
return(RedirectTo("/Jianyan/Create/" + model.JianyanCustomerId, msg.MessageInfo));
}
}
