public ActionResult Statistics(long siteId, long menuId, long?id, bool?isEvent) { if (id == null) { id = 0; FormModel item = FormDAO.GetItemFromSourceID(menuId); if (item != null) { id = item.ID; } } IEnumerable <FieldModel> fields = FieldDAO.GetItems((long)id); IEnumerable <FieldValue> fieldValues = FieldValueDAO.GetItemsByFormID((long)id); bool hasValues = false; foreach (var item in fields) { IEnumerable <FieldValue> values = fieldValues.Where(v => v.FieldID == item.ID); int total = values.Count(); if (total > 0) { hasValues = true; break; } } ViewBag.hasValues = hasValues; ViewBag.Values = fieldValues; ViewBag.SiteID = siteId; ViewBag.MenuID = menuId; ViewBag.IsEvent = isEvent ?? false; return(View(fields)); }
public int GetItemCount(long formId, long fieldId, string value, long?formItemId) { return(FieldValueDAO.GetItemCount(formId, fieldId, value, formItemId)); }
public int CheckValueExist(long formId, long fieldId, string value, long?formItemId) { return(FieldValueDAO.IsExist(formId, fieldId, value, formItemId) ? 1 : 0); }
private FormItem FormItemSave(FormModel form) { FormItem formItem = new FormItem { FormID = form.ID, ID = WorkLib.GetItem.NewSN(), IsTemp = false }; IEnumerable <FieldModel> fields = form.GetFields(); foreach (FieldModel field in fields) { string val = Request.Form[field.ID.ToString()] ?? string.Empty; if (field.TypeID == "address") { string regions = Request.Form["Regions_" + field.ID] ?? string.Empty; int[] regionList = null; if (regions != string.Empty) { regionList = JsonConvert.DeserializeObject <int[]>(regions); } string address = Request.Form["Address_" + field.ID] ?? string.Empty; val = JsonConvert.SerializeObject(new FieldAddress { Regions = regionList, Address = address }); } FieldValueDAO.SetItem(new FieldValue { FormItemID = formItem.ID, FieldID = field.ID, Value = val }); if (field.DefaultType != null) { switch ((FieldDefaultType)(byte)field.DefaultType) { case FieldDefaultType.Email: formItem.Email = val; break; case FieldDefaultType.姓名: formItem.Name = val; break; case FieldDefaultType.性別: formItem.Sex = val; break; case FieldDefaultType.身份證字號: formItem.IDCard = val; break; case FieldDefaultType.手機: formItem.Mobile = val; break; case FieldDefaultType.電話: formItem.Phone = val; break; } } } FormItemDAO.SetItem(formItem); return(formItem); }