public string GetDataColumn(string model)
{
ModelInfo modelInfo = ModelHelper.GetModelInfo(model);
We7DataColumnCollection columns = modelInfo.DataSet.Tables[0].Columns;
We7DataColumnCollection dcs = new We7DataColumnCollection();
foreach (We7DataColumn dc in columns)
{
if (dc.IsSystem && !dc.List)
{
continue;
}
if (dc.Direction == ParameterDirection.ReturnValue)
{
continue;
}
dcs.Add(dc);
}
//string json = JavaScriptConvert.SerializeObject(columns).Replace("null", "\"\"");
string json = JavaScriptConvert.SerializeObject(dcs).Replace("null", "\"\"");
return(json);
}
public string GetSearchDataColumn(string model)
{
ModelInfo modelInfo = ModelHelper.GetModelInfo(model);
We7DataColumnCollection columns = GetConditionControl(modelInfo);
string json = JavaScriptConvert.SerializeObject(columns).Replace("null", "\"\"");
return(json);
}
/// <summary>
/// BindData()
/// </summary>
void BindData()
{
Action = We7Request.GetString("t").ToLower();
if (Action == "widget")
{
List <string> displayFields = new List <string>();
We7DataColumnCollection dcs = new We7DataColumnCollection();
foreach (We7DataColumn col in ModelInfo.DataSet.Tables[0].Columns)
{
if (col.Direction == ParameterDirection.ReturnValue || (col.IsSystem && !displayFields.Contains(col.Name)))
{
continue;
}
dcs.Add(col);
}
chklstWidgetList.DataSource = dcs;
chklstWidgetList.DataTextField = "Label";
chklstWidgetList.DataValueField = "Name";
chklstWidgetView.DataSource = dcs;
chklstWidgetView.DataTextField = "Label";
chklstWidgetView.DataValueField = "Name";
chklstWidgetList.DataBind();
chklstWidgetView.DataBind();
}
if (ModelInfo.Layout != null && ModelInfo.Layout.UCContrl != null)
{
foreach (ListItem item in chklstWidgetView.Items)
{
item.Attributes["mvalue"] = item.Value;
if (ModelInfo.Layout.UCContrl.WidgetDetailFieldArray != null)
{
item.Selected = Array.Exists(ModelInfo.Layout.UCContrl.WidgetDetailFieldArray,
s => s == item.Value);
}
}
foreach (ListItem item in chklstWidgetList.Items)
{
item.Attributes["mvalue"] = item.Value;
if (ModelInfo.Layout.UCContrl.WidgetListFieldArray != null)
{
item.Selected = Array.Exists(ModelInfo.Layout.UCContrl.WidgetListFieldArray, s => s == item.Value);
}
}
}
Exist(Action);
}
//获取查询项
private string GetMapping(ModelInfo modelInfo, out int count)
{
We7DataColumnCollection cols = modelInfo.DataSet.Tables[0].Columns;
IList <DefaultModel> defaultModels = ModelHelper.GetDefaultModels();
DefaultModel defaultModel = null;
for (int i = 0; i < defaultModels.Count; i++)
{
if (defaultModels[i].Name == ConvertModelType(modelInfo.Type))
{
defaultModel = defaultModels[i];
}
}
string[] mappingField = null;
if (defaultModel != null)
{
mappingField = defaultModel.MappingFields.Split(new char[] { '|' });
}
string mapping = string.Empty;
if (mappingField != null && mappingField.Length > 0)
{
bool bout = false;
for (int i = 0; i < mappingField.Length; i++)
{
if (bout)
{
break;
}
for (int j = 0; j < cols.Count; j++)
{
if (mappingField[i] == cols[j].Mapping)
{
break;
}
if (j == cols.Count - 1 && mappingField[i] != cols[j].Mapping)
{
mapping = mappingField[i];
bout = true;
}
}
}
}
count = mappingField.Length;
return(mapping);
}
/// <summary>
/// 更新表
/// </summary>
/// <param name="model"></param>
public void UpdateTable(We7.Model.Core.ModelInfo model)
{
ModelDBHelper DbHelper = ModelDBHelper.Create(model.ModelName);
string table = model.DataSet.Tables[0].Name;
DataTable dt = DbHelper.Query(String.Format(SqlSelectTable, table));
We7DataColumnCollection columns = model.DataSet.Tables[0].Columns;
if (!columns.Contains("Updated", true))
{
columns.Add(new We7DataColumn()
{
DataType = TypeCode.DateTime, Name = "Updated"
});
}
if (!columns.Contains("AccountID", true))
{
columns.Add(new We7DataColumn()
{
DataType = TypeCode.String, Name = "AccountID", MaxLength = 40
});
}
foreach (We7DataColumn c in columns)
{
try
{
if (c.Direction == ParameterDirection.ReturnValue)
{
continue;
}
string sql = String.Empty;
if (ContainsColumn(dt, c.Name))
{
if (IgnoreUpdateFields.Contains(c.Name))
{
continue;
}
sql = String.Format(SqlAlterColumn, table, c.Name, GetDbType(c));
}
else
{
sql = String.Format(SqlAddColumn, table, c.Name, GetDbType(c));
}
//DbHelper.Execute(sql);
ExecuteSql(sql);
}
catch (Exception ex) { }
}
}
//是否包含标题项
private bool hasTitle(ModelInfo modelInfo)
{
bool has = false;
We7DataColumnCollection cols = modelInfo.DataSet.Tables[0].Columns;
for (int i = 0; i < cols.Count; i++)
{
if (cols[i].Mapping == "Title")
{
has = true;
break;
}
}
return(has);
}
//获取查询项
private We7DataColumnCollection GetConditionControl(ModelInfo modelInfo)
{
We7DataColumnCollection collections = new We7DataColumnCollection();
We7DataColumnCollection cols = modelInfo.DataSet.Tables[0].Columns;
IList <DefaultModel> defaultModels = ModelHelper.GetDefaultModels();
DefaultModel defaultModel = null;
for (int i = 0; i < defaultModels.Count; i++)
{
if (defaultModels[i].Name == ConvertModelType(modelInfo.Type))
{
defaultModel = defaultModels[i];
}
}
string[] mappingField = null;
if (defaultModel != null)
{
mappingField = defaultModel.MappingFields.Split(new char[] { '|' });
}
bool hasTitle = false;
if (mappingField != null && mappingField.Length > 0)
{
for (int i = 0; i < mappingField.Length; i++)
{
for (int j = 0; j < cols.Count; j++)
{
if (mappingField[i] == cols[j].Mapping)
{
collections.Add(cols[j]);
}
if (!hasTitle && cols[j].Mapping == "Title")
{
collections.Add(cols[j]);
hasTitle = true;
}
}
}
}
return(collections);
}
public string GetOutDataColumn(string model)
{
ModelInfo modelInfo = ModelHelper.GetModelInfo(model);
We7DataColumnCollection columns = modelInfo.DataSet.Tables[0].Columns;
We7DataColumnCollection cols = new We7DataColumnCollection();
for (int i = 0; i < columns.Count; i++)
{
if (!columns[i].IsSystem && (columns[i].Direction == ParameterDirection.Output || columns[i].Direction == ParameterDirection.InputOutput))
{
cols.Add(columns[i]);
}
}
string json = JavaScriptConvert.SerializeObject(cols).Replace("null", "\"\"");
return(json);
}
