public ActionResult Create(FankuiAddViewModel model) { try { FankuiDto dto = new FankuiDto(); dto.FankuiResult = model.FankuiResult; dto.FankuiSource = model.FankuiSource; dto.FankuiDescription = model.FankuiDescription; dto.FankuiSendTime = System.DateTime.Now; dto.FankuiTime = System.DateTime.Now; dto.FankuiStatus = "已查看"; dto.FankuiCustomerId = model.FankuiCustomerId; dto.FankuiDoctor = int.Parse(System.Web.HttpContext.Current.Request.Cookies["UserId"].Value); // TODO: Add insert logic here string JsonString = JsonHelper.JsonSerializerBySingleData(dto); Message msg = CMSService.Insert("Fankui", JsonString); return(RedirectTo("/Fankui/Index/" + model.FankuiCustomerId, msg.MessageInfo)); // return RedirectToAction("Index"); } catch { Message msg = new Message(); msg.MessageInfo = "插入操作失败了,请检查是否输入错误"; return(RedirectTo("/Fankui/Create/" + model.FankuiCustomerId, msg.MessageInfo)); } }
// // GET: /Fankui/ public ActionResult Index(int?p, int id) { Pager pager = new Pager(); pager.table = "CMSFankui"; pager.strwhere = "FankuiCustomerId=" + id; pager.PageSize = 10; pager.PageNo = p ?? 1; pager.FieldKey = "FankuiId"; pager.FiledOrder = "FankuiId Desc"; pager = CMSService.SelectAll("Fankui", pager); List <FankuiDto> list = new List <FankuiDto>(); foreach (DataRow dr in pager.EntityDataTable.Rows) { FankuiDto dto = FankuiMapping.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[9]; FankuiDto dto = JsonHelper.JsonDeserializeBySingleData <FankuiDto>(jsonString); arParames[0] = new SqlParameter("@FankuiId", SqlDbType.Int); arParames[0].Value = dto.FankuiId; arParames[1] = new SqlParameter("@FankuiCustomerId", SqlDbType.Int); arParames[1].Value = dto.FankuiCustomerId; arParames[2] = new SqlParameter("@FankuiResult", SqlDbType.Int); arParames[2].Value = dto.FankuiResult; arParames[3] = new SqlParameter("@FankuiDescription", SqlDbType.Text); arParames[3].Value = dto.FankuiDescription; arParames[4] = new SqlParameter("@FankuiTime", SqlDbType.DateTime); arParames[4].Value = dto.FankuiTime; arParames[5] = new SqlParameter("@FankuiSendTime", SqlDbType.DateTime); arParames[5].Value = dto.FankuiSendTime; arParames[6] = new SqlParameter("@FankuiStatus", SqlDbType.VarChar, 50); arParames[6].Value = dto.FankuiStatus; arParames[7] = new SqlParameter("@FankuiSource", SqlDbType.Int); arParames[7].Value = dto.FankuiSource; arParames[8] = new SqlParameter("@FankuiDoctor", SqlDbType.Int); arParames[8].Value = dto.FankuiDoctor; return(arParames); }
public static FankuiDto getDTO(DataRow dr) { FankuiDto dto = new FankuiDto(); dto.FankuiId = int.Parse(dr["FankuiId"].ToString()); dto.FankuiCustomerId = int.Parse(dr["FankuiCustomerId"].ToString()); dto.FankuiResult = int.Parse(dr["FankuiResult"].ToString()); dto.FankuiDescription = dr["FankuiDescription"].ToString(); dto.FankuiTime = DateTime.Parse(dr["FankuiTime"].ToString()); dto.FankuiSendTime = DateTime.Parse(dr["FankuiSendTime"].ToString()); dto.FankuiSource = int.Parse(dr["FankuiSource"].ToString()); dto.FankuiStatus = dr["FankuiSource"].ToString(); dto.FankuiDoctor = int.Parse(dr["FankuiDoctor"].ToString()); return(dto); }