public DataTable GetModelDT(S_UI_Form formInfo, string id, bool isUpVersion = false, string taskExecID = "", string code = "")
{
UIBuilder uiFO = new UIBuilder();
SQLHelper sqlHelper = SQLHelper.CreateSqlHelper(formInfo.ConnName);
var items = JsonHelper.ToObject <List <FormItem> >(formInfo.Items);
string sql = string.Format("select * from {0} where ID='{1}'", formInfo.TableName, id);
DataTable dt = sqlHelper.ExecuteDataTable(sql);
//获取数据后处理加密字段
if (System.Configuration.ConfigurationManager.AppSettings["FieldEncryption"] == "True")
{
foreach (var item in items)
{
if (item.FieldType == "varbinary(500)")
{
string _sql = @"
OPEN SYMMETRIC KEY SymmetricByCert
DECRYPTION BY CERTIFICATE JinHuiCertificate
";
_sql += string.Format("select convert(nvarchar(500), DecryptByKey({1})) from {0} where ID='{2}'", formInfo.TableName, item.Code, id);
var obj = sqlHelper.ExecuteScalar(_sql);
if (dt.Rows.Count > 0)
{
dt.Columns.Remove(item.Code);
dt.Columns.Add(item.Code);
dt.Rows[0][item.Code] = obj.ToString();
}
}
}
}
Dictionary <string, DataTable> defaultValueRows = null;
if (dt.Rows.Count == 0)
{
defaultValueRows = uiFO.GetDefaultValueDic(formInfo.DefaultValueSettings);
}
else
{
defaultValueRows = uiFO.GetDefaultValueDic(formInfo.DefaultValueSettings, dt.Rows[0]);
}
#region 数据默认值
StringBuilder sb = new StringBuilder();
foreach (var key in defaultValueRows.Keys)
{
var guid = new Guid();
if (Guid.TryParse(key, out guid) == false)
{
sb.AppendFormat("\n var {0}={1}", key, JsonHelper.ToJson(defaultValueRows[key]));
}
}
ViewBag.DataSource = sb.ToString();
#endregion
if (dt.Rows.Count == 0 || isUpVersion)
{
#region 新对象默认值
DataRow row = null;
if (dt.Rows.Count == 0)
{
row = dt.NewRow();
dt.Rows.Add(row);
}
else
{
row = dt.Rows[0];
}
row["ID"] = string.IsNullOrEmpty(id) ? GuidHelper.CreateGuid() : id;
//包含默认值设置则初始化默认值
items.Where(c => !string.IsNullOrEmpty(c.DefaultValue)).ToList().ForEach(d =>
{
if (d.ItemType == "SubTable")
{
//子表
if (!dt.Columns.Contains(d.Code))
{
dt.Columns.Add(d.Code);
}
row[d.Code] = uiFO.GetDefaultValue(d.Code, d.DefaultValue, defaultValueRows);
}
else if (!dt.Columns.Contains(d.Code))
{
return;
}
else if ((d.ItemType == "ButtonEdit" || d.ItemType == "ComboBox") && d.DefaultValue.Split(',').Count() == 2)
{
//键值控件
string v1 = uiFO.GetDefaultValue(d.Code, d.DefaultValue.Split(',')[0], defaultValueRows);
string v2 = uiFO.GetDefaultValue(d.Code, d.DefaultValue.Split(',')[1], defaultValueRows);
if (!string.IsNullOrEmpty(v1) && v1.Contains('{') == false)
{
row[d.Code] = v1;
}
if (!string.IsNullOrEmpty(v2) && v2.Contains('{') == false)
{
var fieldName = "";
fieldName = d.Code + "Name";
if (!String.IsNullOrWhiteSpace(d.Settings))
{
var settings = JsonHelper.ToObject(d.Settings);
var txtName = settings.GetValue("textName");
if (!String.IsNullOrEmpty(txtName))
{
fieldName = txtName;
}
}
row[fieldName] = v2;
}
}
else
{
//单值控件
string v = uiFO.GetDefaultValue(d.Code, d.DefaultValue, defaultValueRows);
if (!string.IsNullOrEmpty(v) && v.Contains('{') == false)
{
row[d.Code] = v;
}
}
});
#endregion
#region 升版子表无默认值数据取历史版本
foreach (var item in items)
{
if (item.ItemType != "SubTable")
{
continue;
}
if (!dt.Columns.Contains(item.Code))
{
dt.Columns.Add(item.Code);
}
if (!string.IsNullOrEmpty(Convert.ToString(dt.Rows[0][item.Code])))
{
sql = string.Format("select * from {0}_{1} where {0}ID='{2}' order by SortIndex", formInfo.TableName, item.Code, id);
DataTable dtSubTable = sqlHelper.ExecuteDataTable(sql);
if (dtSubTable.Rows.Count > 0)
{
dt.Rows[0][item.Code] = JsonHelper.ToJson(dtSubTable);
}
}
}
#endregion
//设置默认流水号
if (dt.Columns.Contains("SerialNumber") && !string.IsNullOrEmpty(formInfo.SerialNumberSettings) && !isUpVersion)
{
var serialNumberDic = JsonHelper.ToObject(formInfo.SerialNumberSettings);
string userMode = "ONLYGET";//默认值兼容老项目没有配置该选项
if (serialNumberDic.ContainsKey("UserSerialNumber"))
{
userMode = serialNumberDic["UserSerialNumber"] == null ? "" : serialNumberDic["UserSerialNumber"].ToString().Trim().ToUpper();
}
if (userMode != "NONE" && userMode != "FLOWEND")
{
bool isAutoIncrease = userMode.Equals("ONLYGET");
row["SerialNumber"] = GetSerialNumber(formInfo.Code, formInfo.SerialNumberSettings, isAutoIncrease, row, null);
}
}
}
else //获取子表数据
{
#region 获取子表数据
foreach (var item in items)
{
if (item.ItemType != "SubTable")
{
continue;
}
//表单子表支持加密字段
if (System.Configuration.ConfigurationManager.AppSettings["FieldEncryption"] == "True")
{
var subTableSettings = JsonHelper.ToObject(item.Settings);
var subTableItems = JsonHelper.ToObject <List <FormItem> >(subTableSettings["listData"].ToString());
StringBuilder sbSubTableFields = new StringBuilder();
sbSubTableFields.AppendFormat("ID");
foreach (var subItem in subTableItems)
{
if (subItem.FieldType == "")
{
}
else if (subItem.FieldType == "varbinary(500)")
{
sbSubTableFields.AppendFormat(",{0}=convert(nvarchar(500), DecryptByKey({0})) ", subItem.Code);
}
else
{
sbSubTableFields.Append("," + subItem.Code);
}
if (subItem.ItemType == "ButtonEdit")
{
sbSubTableFields.Append("," + subItem.Code + "Name");
}
else if (subItem.ItemType == "ComboBox" && !String.IsNullOrEmpty(subItem.Settings))
{
var subSetting = JsonHelper.ToObject(subItem.Settings);
if (!String.IsNullOrEmpty(subSetting.GetValue("textName")))
{
sbSubTableFields.Append("," + subSetting.GetValue("textName"));
}
}
}
sql = string.Format("select {3} from {0}_{1} where {0}ID='{2}' order by SortIndex", formInfo.TableName, item.Code, id, sbSubTableFields);
//子表支持加密
if (System.Configuration.ConfigurationManager.AppSettings["FieldEncryption"] == "True")
{
sql = @"
OPEN SYMMETRIC KEY SymmetricByCert
DECRYPTION BY CERTIFICATE JinHuiCertificate
" + sql;
}
}
else
{
sql = string.Format("select * from {0}_{1} where {0}ID='{2}' order by SortIndex", formInfo.TableName, item.Code, id);
}
DataTable dtSubTable = sqlHelper.ExecuteDataTable(sql);
if (!dt.Columns.Contains(item.Code))
{
dt.Columns.Add(item.Code);
}
dt.Rows[0][item.Code] = JsonHelper.ToJson(dtSubTable);
}
#endregion
}
//计算值(增加表单表没有的字段) 2015-6-16 新增功能
foreach (var item in items)
{
if (dt.Columns.Contains(item.Code))
{
continue;
}
if (string.IsNullOrEmpty(item.DefaultValue))
{
continue;
}
dt.Columns.Add(item.Code);
string v = uiFO.GetDefaultValue(item.Code, item.DefaultValue, defaultValueRows);
if (!string.IsNullOrEmpty(v) && v.Contains('{') == false)
{
dt.Rows[0][item.Code] = v;
}
}
return(dt);
}
