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