private void Bind() { Guid Id = Guid.Empty; if (!string.IsNullOrWhiteSpace(Request.QueryString["Id"])) { Guid.TryParse(Request.QueryString["Id"], out Id); } if (!Id.Equals(Guid.Empty)) { ErnieItem bll = new ErnieItem(); var model = bll.GetModel(Id); if (model != null) { hErnieItemId.Value = model.Id.ToString(); var li = ddlNumType.Items.FindByValue(model.NumType); if (li != null) { li.Selected = true; } string[] nums = model.Num.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var num in nums) { li = cbListNum.Items.FindByValue(num); if (li != null) { li.Selected = true; } } txtAppearRatio.Value = Math.Round((double)model.AppearRatio, 2).ToString(); } } }
private void GetErnieItemForDatagrid(HttpContext context) { context.Response.ContentType = "text/plain"; Guid ernieId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.QueryString["ernieId"])) { Guid.TryParse(context.Request.QueryString["ernieId"], out ernieId); } if (ernieId.Equals(Guid.Empty)) { context.Response.Write("{\"total\":0,\"rows\":[]}"); return; } int totalRecords = 0; int pageIndex = 1; int pageSize = 10; if (!string.IsNullOrWhiteSpace(context.Request.Form["page"])) { int.TryParse(context.Request.Form["page"], out pageIndex); } if (!string.IsNullOrWhiteSpace(context.Request.Form["rows"])) { int.TryParse(context.Request.Form["rows"], out pageSize); } if (pageIndex < 1) { pageIndex = 1; } if (pageSize < 10) { pageSize = 10; } ErnieItem bll = new ErnieItem(); string sqlWhere = "and ErnieId = @ErnieId "; SqlParameter parm = new SqlParameter("@ErnieId", SqlDbType.UniqueIdentifier); parm.Value = ernieId; var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parm); if (list == null || list.Count == 0) { context.Response.Write("{\"total\":0,\"rows\":[]}"); return; } StringBuilder sb = new StringBuilder(1000); foreach (var model in list) { sb.Append("{\"Id\":\"" + model.Id + "\",\"ErnieId\":\"" + model.ErnieId + "\",\"NumType\":\"" + model.NumType + "\",\"Num\":\"" + model.Num + "\",\"AppearRatio\":\"" + Math.Round((double)model.AppearRatio, 2) + "\"},"); } context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}"); }
private void SaveErnieItem(HttpContext context) { context.Response.ContentType = "text/plain"; Guid Id = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["Id"])) { Guid.TryParse(context.Request.Form["Id"], out Id); } Guid ernieId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["ErnieId"])) { Guid.TryParse(context.Request.Form["ErnieId"], out ernieId); } if (ernieId.Equals(Guid.Empty)) { context.Response.Write("{\"success\": false,\"message\": \"请先完成基本信息再执行此操作!\"}"); return; } string numType = string.IsNullOrWhiteSpace(context.Request.Form["NumType"]) ? "" : context.Request.Form["NumType"].Trim(); if (string.IsNullOrWhiteSpace(numType)) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}"); return; } string num = string.IsNullOrWhiteSpace(context.Request.Form["Num"]) ? "" : context.Request.Form["Num"].Trim().Trim(','); if (string.IsNullOrWhiteSpace(num)) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}"); return; } float appearRatio = 0; if (!string.IsNullOrWhiteSpace(context.Request.Form["AppearRatio"])) { float.TryParse(context.Request.Form["AppearRatio"], out appearRatio); } ErnieItemInfo model = new ErnieItemInfo(); model.Id = Id; model.ErnieId = ernieId; model.NumType = numType; model.Num = num; model.AppearRatio = appearRatio; ErnieItem bll = new ErnieItem(); int effect = -1; if (!Id.Equals(Guid.Empty)) { effect = bll.Update(model); } else { effect = bll.Insert(model); } if (effect < 1) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_InvalidError + "\"}"); return; } context.Response.Write("{\"success\": true,\"message\": \"" + Id + "\"}"); }