//根据实例Id获取表单实例
public FormViewModel GetFormInstanceById(int InstanceId)
{
FormViewModel formInstance = new FormViewModel();
Dictionary<string, object> dsDic = new Dictionary<string, object>();
dsDic.Add("i_InstanceId", InstanceId);
using (BaseDB db = new RedasDBHelper())
{
try
{
IList<FormViewModel> InstanceList = db.ExecuteListProc<FormViewModel>("pkg_Test.sp_get_instanceform", dsDic);
if (InstanceList != null && InstanceList.Count > 0)
{
formInstance = InstanceList[0];
formInstance.LABLELIST = JsonTools.JsonToObject2<DFormViewModel>(formInstance.CONTENTS).FormLabels
.Where(l => l.IsSelected == true)
.OrderBy(d => d.DEFAULT_ORDER).ThenBy(d => d.SORT).ToList();
}
}
catch
{
formInstance = new FormViewModel();
}
}
return formInstance;
}
public List<SurveryDataModel> ExportSurveryData()
{
using (var db = new RedasDBHelper())
{
var dic = new Dictionary<string, object>();
dic.Add("cur_result", null);
var field = new RedasDbFieldDTO();
IList<SurveryDataModel> fieldList = db.ExecuteListProc<SurveryDataModel>("pkg_Test.sp_SurveryData_get", dic);
return fieldList.ToList();
}
}
