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