/// <summary>
/// 获取list页的数据源
/// 支持主模块的链接
/// 支持枚举量
/// 支持时间格式
/// </summary>
/// <param name="f1"></param>
/// <returns></returns>
public string GetHtmlList(DataBaseField f1, ITableImplement this1)
{
if (!f1.Desc.af_Enable)
{
return(""); //是否可用
}
if (!f1.Desc.af_Visable)
{
return(""); //是否可见
}
string html = "";
string tableName = f1.TableName;
AttributeItem attr1 = AttributeItem.Factory(f1);
object value1 = (this1.GetValue(attr1));
DataBaseTable dt1 = f1.DataBaseTable; //DataBaseField f1;
try
{
DataBaseField id1 = dt1.IDField;
DataBaseField name1 = dt1.NameField;
if (f1 == dt1.IDField)
{
//html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>";
}
else if (f1 == dt1.NameField) // != null && dt1.NameField.FieldName == f1.FieldName)//本模块name详细链接
{
string showUrl = "../" + dt1.TableName + "/show.aspx";
if (!Exist(showUrl))
{
showUrl = "show.aspx";
}
html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + tableName
+ "' target='_blank'>" + value1 + "</a>";
}
else if (isSelect(f1)) //枚举量
{
html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1);
}
else if (isChaZhao(f1)) //父表
{
DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField;
AttributeItem attr2 = AttributeItem.Factory(f2);
html = Convert.ToString(this1.GetValue(attr2));
}
else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage)
{
html = "<img src ='" + value1 + "' style='height:40px' />";
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
}
if (html == "")
{
html = Convert.ToString(value1);
}
return(html);
}
private bool initParam()
{
if (string.IsNullOrEmpty(Request["template"]))//表名
{
DBTableName = Convert.ToString(Request["template"]);
}
if (string.IsNullOrEmpty(Request["template_id"]))//表的id
{
ID_FIELD = Convert.ToString(Request["template_id"]);
}
if (string.IsNullOrEmpty(Request["template_name"]))//表的名称
{
NAME_FIELD = Convert.ToString(Request["template_name"]);
}
if (string.IsNullOrEmpty(Request["template_pid"]))//表的父对象id
{
PID_FIELD = Convert.ToString(Request["template_pid"]);
}
if (string.IsNullOrEmpty(Request["template_type"]))//是否为树结构
{
IsTypeTree = Convert.ToString(Request["template_type"]);
}
itable = new ITableImplementHelper(conn).Factory(DBTableName);
if (string.IsNullOrEmpty(DBTableName) ||
string.IsNullOrEmpty(ID_FIELD) ||
string.IsNullOrEmpty(NAME_FIELD) ||
itable == null || itable.IsNull()
)
{
return(false);
}
return(true);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
condObj._TableName = valObj._TableName;
}
BindList(aspPager.CurrentPageIndex);
}
//////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// 属性列表对象。适用于repList_ItemDataBound
/// </summary>
public string GetHTML(string templateList, ITableImplement valObj)
{
BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlValue);
bt.ConnectKey = conn;
string htmlEdit = bt.BuildByStr(templateList, "bs", valObj, @"c:\123.txt");
return(htmlEdit);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <ITableImplement>(hidCondition.Value);
condObj._TableName = valObj._TableName;
}
BindList(aspPager.CurrentPageIndex);
}
int recount = -1; //��ѯ�ܼ�¼��
#endregion Fields
#region Methods
/// <summary>
/// ��ȡlistҳ������Դ
/// ֧����ģ�������
/// ֧��ö����
/// ֧��ʱ���ʽ
/// </summary>
/// <param name="f1"></param>
/// <returns></returns>
public string GetHtmlList(DataBaseField f1, ITableImplement this1)
{
if (!f1.Desc.af_Enable) return "";//�Ƿ����
if (!f1.Desc.af_Visable) return "";//�Ƿ�ɼ�
string html = "";
string tableName = f1.TableName;
AttributeItem attr1 = AttributeItem.Factory(f1);
object value1 = (this1.GetValue(attr1));
DataBaseTable dt1 = f1.DataBaseTable; //DataBaseField f1;
try
{
DataBaseField id1 = dt1.IDField;
DataBaseField name1 = dt1.NameField;
if (f1 == dt1.IDField)
{
//html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>";
}
else if (f1 == dt1.NameField)// != null && dt1.NameField.FieldName == f1.FieldName)//��ģ��name��ϸ����
{
string showUrl = "../" + dt1.TableName + "/show.aspx";
if (!Exist(showUrl))
{
showUrl = "show.aspx";
}
html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + tableName
+ "' target='_blank'>" + value1 + "</a>";
}
else if (isSelect(f1))//ö����
{
html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1);
}
else if (isChaZhao(f1))//����
{
DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField;
AttributeItem attr2 = AttributeItem.Factory(f2);
html = Convert.ToString(this1.GetValue(attr2));
}
else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage)
{
html = "<img src ='" + value1 + "' style='height:40px' />";
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
}
if (html == "")
{
html = Convert.ToString(value1);
}
return html;
}
public void getTemplateHtml()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
string templateName = HttpUtil.GetReqStrValue("templateName");
if (templateName.Equals("默认"))
{
//默认，根据tableName取获取模板
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
int i = 0;
string html = "";
string tr = "<tr>";
foreach (AttributeItem attr in itable.af_AttributeItemList)
{
if (i % 2 == 0)
{
html += tr + "</tr>";
tr = "<tr>";
}
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = attr.FieldName;
TF_TB_FIELD val = BLLTable <TF_TB_FIELD> .GetRowData(conf2);
if (val != null)
{
tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>";
}
else
{
tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName) + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>";
}
i++;
}
Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END);
return;
}
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TEMPLATE_NAME = templateName;
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
TF_CUSTOM_TEMPLATE valObj = BLLTable <TF_CUSTOM_TEMPLATE> .GetRowData(conf);
if (valObj == null)
{
Response.Write("");
}
else
{
Response.Write(valObj.TEMPLATE_HTML);
}
}
/// <summary>
/// 从取值对象中获得属性，从条件对象中获得值
/// </summary>
/// <param name="valObj"></param>
/// <param name="condObj"></param>
/// <returns></returns>
public List <DataBaseField> Parse(ITableImplement valObj, ITableImplement condObj)
{
List <DataBaseField> list2 = new List <DataBaseField>();
List <AttributeItem> list = new List <AttributeItem>();
list.AddRange(valObj.af_GetAvailableAttributeItem());
if (list.Count == 0)
{
list.AddRange(valObj.af_AttributeItemList);
}
string tbName = valObj._TableName.ToLower();
if (tbName == ITableImplement.defaultTableName.ToLower())
{
tbName = list[0].TableName;
}
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
if (dt1 == null)
{
ConsoleService.Warn(tbName + " 数据表不存在");
return(new List <DataBaseField>());
}
#endregion
foreach (AttributeItem item in list)
{
string fieldName = item.FieldName.ToLower();
#region 列操作
DataBaseField f1 = null;
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ConsoleService.Warn(string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName));
continue;
}
if (f1.Desc.CtrlType == BaseCtrlType.Text || f1.Desc.CtrlType == BaseCtrlType.HTML ||
f1.Desc.CtrlType == BaseCtrlType.SmallText)
{
continue;
}
if (condObj != null && condObj.IsNotNull())
{
f1.Value = condObj.GetString(item);
}
#endregion
list2.Add(f1);
}
return(list2);
}
public static string getXmlByTable(ITableImplement table)
{
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
string tableXml = "<" + table.TableName() + ">";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
tableXml += "<" + dataBaseField.FieldName + ">";
tableXml += dataBaseField.Value;
tableXml += "</" + dataBaseField.FieldName + ">";
}
tableXml += "</" + table.TableName() + ">";
return(tableXml);
}
private void SetRequest(ITableImplement condRequest)
{
foreach (AttributeItem attr in condRequest.af_AttributeItemList)
{
if (!string.IsNullOrEmpty(Request[attr.FieldCtrlName]))
{
condRequest.SetValue(attr, Request[attr.FieldCtrlName]);
}
else if (!string.IsNullOrEmpty(Request[attr.FieldName]))
{
condRequest.SetValue(attr, Request[attr.FieldName]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ID"]))
{
keyid = Request["ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["record"]))
{
keyid = Request["record"];
}
if (!IsPostBack)
{
try
{
if (string.IsNullOrEmpty(keyid))//ÐÂÔö
{
}
else//ÐÞ¸Ä
{
ITableImplement cond1 = valObj.Clone(); cond1.SetValue(KeyID, keyid);
resultObj = BLLTable <ITableImplement> .Factory(conn).GetRowData(valObj, cond1);
if (resultObj == null)
{
ScriptHelper.Alert(this, "¼Ç¼²»´æÔÚ");
ScriptHelper.CloseMe(this); return;
}
//string html = Convert.ToString(resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE));
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
if (valObj.IsNull())
{
//valObj.LoadAllAttributes(true);
}
}
public string GetTemplate(string template, ITableImplement valObj, ITableImplement condObj)
{
try
{
BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlTemplate);
bt.ConnectKey = conn;
string template1 = bt.BuildByStr(template, "bs", Parse(valObj, condObj), @"c:\123.txt");
return(template1);
}
catch (Exception ex)
{
File.AppendAllText(Path.Combine(WebHelper.GetAppPath(), "abc.txt"), ex.ToString());
throw ex;
}
return("");
}
public void getTemplateHtml()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
string templateName = HttpUtil.GetReqStrValue("templateName");
if (templateName.Equals("默认")) {
//默认，根据tableName取获取模板
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
int i = 0;
string html = "";
string tr = "<tr>";
foreach(AttributeItem attr in itable.af_AttributeItemList){
if (i % 2 == 0)
{
html += tr+"</tr>";
tr = "<tr>";
}
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = attr.FieldName;
TF_TB_FIELD val = BLLTable<TF_TB_FIELD>.GetRowData(conf2);
if (val != null)
{
tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>";
}
else
{
tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName )+ "</td><td>[" + tableName + "." + attr.FieldName + "]</td>";
}
i++;
}
Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END);
return;
}
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TEMPLATE_NAME = templateName;
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
TF_CUSTOM_TEMPLATE valObj=BLLTable<TF_CUSTOM_TEMPLATE>.GetRowData(conf);
if (valObj == null)
{
Response.Write("");
}
else {
Response.Write(valObj.TEMPLATE_HTML);
}
}
private void getTemplateOptionsAndField()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
List <TF_CUSTOM_TEMPLATE> templateList = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf);
string html = "<option value='-1'>--无--</option>";
if (tableName.Equals("-1"))
{
Response.Write("{\"html\":\"" + html + "\"}");
return;
}
foreach (TF_CUSTOM_TEMPLATE template in templateList)
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField();
string fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val2 = BLLTable <TF_TB_FIELD> .GetRowData(conf2);
if (val2 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
/// <summary>
/// 生成标签模版 + 生成值
/// </summary>
protected void TagBinding(Page page, List <Literal> lits, ITableImplement valObj, ITableImplement condObj, List <ITableImplement> listObj)
{
//isModule = true;
Content c1 = (Content)(page.FindControl("Content2"));
Literal Lit_Finder = (Literal)(page.FindControl("Lit_Finder"));
foreach (Literal lit in lits)
{
if (lit == null)
{
continue;
}
if (lit.ID == "Lit_Finder")
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj, condObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, condObj);
}
else if (lit.ID == "Lit_ListHeader")
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj);
}
else if (lit.ID == "Lit_RepList")
{
string old1 = lit.Text;
if (listObj.Count > 0)
{
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, listObj[0]);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, listObj);
}
else
{
lit.Text = "";
}
}
else
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj);
}
}
}
private void SaveState()
{
#region 获取条件
finderObj = new ITableImplement();
foreach (DataBaseField f1 in valObj.af_GetAvailableDataBaseField())
{
string fieldValue = null;
AttributeItem attr1 = null;
try
{
if (isChaZhao(f1))
{
if (TryGetRequest(f1.Desc.FieldCtrlName + "_NAME", out fieldValue))
{
attr1 = new AttributeItem(f1.TableName, f1.Desc.FieldCtrlName + "_NAME");
finderObj.SetValue(attr1, fieldValue);
}
}
if (TryGetRequest(f1, out fieldValue))
{
attr1 = new AttributeItem(f1);
finderObj.SetValue(attr1, fieldValue);
if (!string.IsNullOrEmpty(fieldValue))
{
condObj.Like(attr1, fieldValue);
}
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
litWarn.Text = ex.Message + ":" + attr1.LongName + "=" + fieldValue;
}
}
//hidVal.Value = valObj111.ToJson(20);
//hidCondition.Value = condObj111.ToJson(20);
hidFind.Value = finderObj.ToJson(20);
//if (hidCondition.Value != "")
//{
// condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
//}
#endregion
}
public static ITableImplement getITableByJson(string tableName, string valJson)
{
ITableImplement ITable = new ITableImplement(tableName);
JavaScriptSerializer jss = new JavaScriptSerializer();
Dictionary <string, object> valMap = jss.Deserialize <Dictionary <string, object> >(valJson);
List <AttributeItem> items = new List <AttributeItem>();
foreach (var val in valMap)
{
items.Add(new AttributeItem(tableName, val.Key));
}
ITable.Add(items.ToArray());
foreach (AttributeItem item in items)
{
ITable[item] = valMap[item.FieldName];
}
return(ITable);
}
private void getTemplateNameOptions()
{
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct = true;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
List <V_TF_TEMPLATE_TABLENAME> templateList = BLLTable <V_TF_TEMPLATE_TABLENAME> .Select(new V_TF_TEMPLATE_TABLENAME(), conf);
string html = "<option value='-1'>--无--</option>";
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
html += "<option value='" + temp.TABLE_NAME + "'>" + temp.CH_NAME + "</option>";
}
Response.Write("{\"html\":\"" + html + "\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
//base.Page_Init(sender, e);
//初始化模块加载参数
base.InitModule(ref valObj, ref KeyID, ref fieldList);
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
resultObj.IsOnlyForModuleIDName = false;
valObj.IsOnlyForModuleIDName = false;
if (!string.IsNullOrEmpty(Request["ID"]))
{
AttributeItem id1 = AttributeItem.Factory(valObj.DataBaseTable.IDField);
ITableImplement cond1 = new ITableImplement(); cond1.SetValue(id1, Request["ID"]);
resultObj = BLLTable <ITableImplement> .Factory(conn).GetRowData(valObj, cond1);
if (resultObj == null)
{
ScriptHelper.Alert(this, "记录不存在");
ScriptHelper.CloseMe(this);
return;
}
BLLTable.SQL_Test.ToArray();
object obj1 = resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE);
}
}
catch (Exception ex)
{
//litWarn.Text = ex.Message;
}
}
}
public JsonData Add(ITableImplement table)
{
this.table = table;
return(this);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
#region 输入参数：数据模型、采用此布局模型展示
if (Request["ModuleType"] != null)
{
string ModuleType = "";
if (Request["ModuleType"] != null)
{
ModuleType = Convert.ToString(Request["ModuleType"]);
}
//是模块，则设置 取值、条件对象 等。
if (ModuleType == "TF_TABLE")
{
msg = "未制定表名";
string ModuleTbName = Convert.ToString(Request["moduleName"]);
if (string.IsNullOrEmpty(ModuleTbName))
{
Response.Write(msg);
Response.End();
}
TF_TABLE condObj1 = new TF_TABLE();
condObj1.TB_NAME = ModuleTbName;
SetRequest(condObj1);
bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList,
out otherValueList, out condList, ref msg);//获取数据域(不是显示域)
msg = "制定模块的数据模型未存在，请安装此模块";
if (!ret1)
{
Response.Write(msg);
Response.End();
}
//设置条件对象
SetRequest(condObj);
SetRequest(condList);
}
}
else
{
valObj = new ITableImplementHelper(conn).Factory("TF_TABLE");
condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();//
}
#endregion
title = valObj._ZhName + "管理";
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (Request["submit"] != null)
{
}
if (!IsPostBack)
{
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //.WebCtrls
//txtPageSize.Value = "2";
aspPager.PageSize = 30;
//if (pid == "" || pid == "0")
//{
// a_top.Visible = false;
//}
#endregion
#region//条件
BindCondition();
#endregion
#region//数据初始化
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
#endregion
BindList(1);
}
//Lit_ToolLeftButton;
}
catch (Exception ex)
{
HandleError(ex);
}
}
//抽象封装
private string getTree(ITableImplement val, AttributeItem pid, AttributeItem sortAttr, AttributeItem a)
{
return "";
}
/// <summary>
/// 从取值对象中获得属性，从条件对象中获得值
/// </summary>
/// <param name="valObj"></param>
/// <param name="condObj"></param>
/// <returns></returns>
public List<DataBaseField> Parse(ITableImplement valObj, ITableImplement condObj)
{
List<DataBaseField> list2 = new List<DataBaseField>();
List<AttributeItem> list = new List<AttributeItem>();
list.AddRange(valObj.af_GetAvailableAttributeItem());
if (list.Count == 0)
list.AddRange(valObj.af_AttributeItemList);
string tbName = valObj._TableName.ToLower();
if (tbName == ITableImplement.defaultTableName.ToLower())
tbName = list[0].TableName;
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
if (dt1 == null)
{
ConsoleService.Warn(tbName + " 数据表不存在");
return new List<DataBaseField>();
}
#endregion
foreach (AttributeItem item in list)
{
string fieldName = item.FieldName.ToLower();
#region 列操作
DataBaseField f1 = null;
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ConsoleService.Warn(string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName));
continue;
}
if (f1.Desc.CtrlType == BaseCtrlType.Text || f1.Desc.CtrlType == BaseCtrlType.HTML
|| f1.Desc.CtrlType == BaseCtrlType.SmallText)
continue;
if (condObj != null && condObj.IsNotNull())
f1.Value = condObj.GetString(item);
#endregion
list2.Add(f1);
}
return list2;
}
protected void Page_Load(object sender, EventArgs e)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
if (!string.IsNullOrEmpty(ModuleName))
{
pageAttr1 = AttributeItem.Factory(valObj.DataBaseTable.IDField);
condObj.af_PageBy(pageAttr1, Order.Desc);
//condObj111._TableName = valObj111._TableName;
finderObj._TableName = valObj._TableName;
DataBaseField[] ds1 = valObj.af_GetAvailableDataBaseField();
foreach (DataBaseField f1 in ds1)
{
if (!f1.Desc.af_Enable || !f1.Desc.af_Visable)
{
continue;
}
fieldList.Add(f1);
}
}
title = valObj._ZhName + "管理";
Page.Title = title;
if (!IsPostBack)
{
//从数据库获取配置的取值对象和条件对象，作为视图。jinsj
Ec_View cond1 = new Ec_View();
cond1.ModuleName = valObj._TableName;
Ec_View v1 = BLLTable <Ec_View> .GetRowData(cond1);
if (v1 != null && v1.IsNotNull())
{
if (v1.ValueJsonString != "")
{
valObj = JsonServiceBase.FromJson <ITableImplement>(v1.ValueJsonString);
}
if (v1.ConditionJsonString != "")
{
condObj = JsonServiceBase.FromJson <ITableImplement>(v1.ConditionJsonString);
}
string viewName = v1.ViewName;
}
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
txtPageSize.Value = "30";
aspPager.PageSize = 30;
#endregion
#region //数据初始化
#endregion
BindList(1);
}
if (hidCondition.Value != "")
{
//condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
}
if (hidFind.Value != "")
{
finderObj = JsonServiceBase.FromJson <ITableImplement>(hidFind.Value);
}
if (hidVal.Value != "")
{
//valObj111 = JsonServiceBase.FromJson<ITableImplement>(hidVal.Value);
}
if (valObj.IsNull())
{
//valObj111.LoadAllAttributes(true);
}
}
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager)
{
int recount = -1;
asppager.PageSize = 20;
switch (asppager.ID)
{
case "aspAllCusPager":
case "aspContractedPager":
V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER;
if (vcrmscCon == null)
{
return;
}
if (asppager.ID == "aspAllCusPager")
{
hidAllCus.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon);
}
else
{
hidContracted.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon);
}
vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER();
valsc._SID = "";
valsc.Cus_ID = 0;
valsc.CompanyName = "";
valsc.ShopName = "";
valsc.Cus_Name = "";
valsc.CustQQ = "";
valsc.WangWangId = "";
valsc.LastContactTime = DateTime.MinValue;
valsc.SNAME = "";
valsc.CustStatus = 0;
if (vcrmscCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性，则用主键属性排序
{
vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc);
}
List <V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable <V_CRM_STAFF_CUSTOMER> .Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscList.Count > 0)
{
FormHelper.Bind(Page, vcrmscList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspAllCusPager")
{
repAllCusList.DataSource = vcrmscList;
repAllCusList.DataBind();
}
else
{
lit_ContractedCusCount.Text = recount.ToString();
repContractedList.DataSource = vcrmscList;
repContractedList.DataBind();
}
asppager.RecordCount = recount;
break;
case "aspToDayMustConPager":
case "aspExpiredPager":
case "aspWillInHighSeasPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT;
if (vcrmscnCon == null)
{
return;
}
if (asppager.ID == "aspToDayMustConPager")
{
hidToDayMustCon.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
}
else if (asppager.ID == "aspExpiredPager")
{
hidExpired.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
}
else
{
hidWillInHighSeas.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
}
vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valscn.STAFF_ID = 0;
valscn.Cus_ID = 0;
valscn.CompanyName = "";
valscn.ShopName = "";
valscn.Cus_Name = "";
valscn.CustQQ = "";
valscn.WangWangId = "";
valscn.LastContactTime = DateTime.MinValue;
valscn.NextContactTime = DateTime.MinValue;
valscn.SNAME = "";
valscn.CustStatus = 0;
if (vcrmscnCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性，则用主键属性排序
{
vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc);
}
List <V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscnList.Count > 0)
{
FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspToDayMustConPager")
{
lit_todayConCusCount.Text = recount.ToString();
repToDayMustConList.DataSource = vcrmscnList;
repToDayMustConList.DataBind();
}
else if (asppager.ID == "aspExpiredPager")
{
lit_ExpiredUnConCusCount.Text = recount.ToString();
repExpiredList.DataSource = vcrmscnList;
repExpiredList.DataBind();
}
else
{
lit_WillInHighSeasCusCount.Text = recount.ToString();
repWillInHighSeasList.DataSource = vcrmscnList;
repWillInHighSeasList.DataBind();
}
asppager.RecordCount = recount;
break;
default:
break;
}
}
private void SetRequest(ITableImplement condRequest)
{
foreach (AttributeItem attr in condRequest.af_AttributeItemList)
{
if (!string.IsNullOrEmpty(Request[attr.FieldCtrlName]))
condRequest.SetValue(attr, Request[attr.FieldCtrlName]);
else if (!string.IsNullOrEmpty(Request[attr.FieldName]))
condRequest.SetValue(attr, Request[attr.FieldName]);
}
}
/// <summary>
/// 相关子表
/// </summary>
/// <returns></returns>
protected string getSubForm()
{
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//父表的id
object id1 = resultObj.GetValue(valObj.DataBaseTable.IDField);
string tableName1 = "关系表1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
int count2 = 0;//计数
foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
{
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List <Relation> lstRel = new List <Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List <ITableImplement> lstCond = new List <ITableImplement>();
lstCond.Add(cond2);
List <ITableImplement> lstOther = new List <ITableImplement>();
count1 = -1;
//显示明显表的 父表的信息
//value2.setConn(conn).setModule("WEC_QC_CARS");
List <ITableImplement> list2 = BLLTable <ITableImplement> .Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex, ref count1);
int num = count1 / pageSize;
if (list2.Count > 0)
{
sb.Append("<script type=\"text/javascript\">");
sb.Append("$(function () {");
sb.Append("$(\"#tbl" + tableName1 + "Title\").click(function () {");
sb.Append("$(\"#tbl" + tableName1 + "\").toggleClass(\"hide\");");
sb.Append("$(\"#tbl" + tableName1 + "Img\").toggleClass(\"showUp\");");
sb.Append("});");
//sb.Append("$(\"ul >li >a[name="+count2+"]\").click(function () {" +
// "alert($(this).attr(\"rel\"))" +
// "});");
// sb.Append("$(\"ul >li >a[name=" + count2 + "]\").click(function () {" +
// //"$(\"ul >li >a[name=" + count2 + "]\").parent().removeClass(\"active\");"+
// //"$(this).parent().addClass(\"active\");"+
// "var str = $(this).attr(\"rel\");" +
// "var strs = str.split(\".\");" +
// "var content=$(this).html();"+
// // "alert(content==\"下一页\");" +
// "if(content==\"下一页\"){"+
// "if((parseInt(strs[1])+1)<="+(num+1)+"){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);"+
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// " }else{"+
// "if((parseInt(strs[1])-1)>=1){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);"+
// "$(this).attr(\"rel\",prevStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// "}"+
// "$.ajax({" +
// "url:\"Back.aspx\"," +
// "type:\"post\"," +
// "data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":strs[1],\"num\":strs[0],\"id1\":"+id1+",\"paging\":\"true\"}," +
// "dataType:\"text\"," +
// "success: function (data) {" +
// "$(\"tbody[rel=\" + strs[0] + \"]\").html(data);" +
// "}," +
// "error: function (data) {" +
// "alert(data);" +
// "}" +
// "});" +
//"});");
sb.Append(" var options = {" +
"currentPage: 1," +
"totalPages: " + (count1 / 10 + 1) + "," +
"numberOfPages:5," +
"onPageChanged:function(event){" +
// "alert($(event.currentTarget).find(\"ul li.active a\").html());" +
"$.ajax({" +
"url:\"Back.aspx\"," +
"type:\"post\"," +
"data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":$(event.currentTarget).find(\"ul li.active a\").html(),\"num\":" + count2 + ",\"id1\":" + id1 + ",\"paging\":\"true\"}," +
"dataType:\"text\"," +
"success: function (data) {" +
"$(\"tbody[rel=" + count2 + "]\").html(data);" +
"}," +
"error: function (data) {" +
"alert(data);" +
"}" +
"});" +
"}" +
"};" +
"$('#page" + count2 + "').bootstrapPaginator(options);");
sb.Append("});");
sb.Append("</script>");
sb.Append("<div id='tbl" + tableName1 + "Title' class='showTitle'><span >" + value2._ZhName + "信息</span><span id='tbl" + tableName1 + "Img' class='showImg'></span></div>");
sb.Append("<div id='tbl" + tableName1 + "' class=\"tblist\">");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" id=\"tbList\" class=\"table table-hover\">");
sb.Append("<thead>");
sb.Append("<tr keyname=\"ID\">");
foreach (DataBaseField d2 in value2.af_GetAvailableDataBaseField())
{
sb.Append("<td data=\"{colname:'" + d2.LongAttributeName + "',show:1}\">" + d2.ZhName + "</td>");
}
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody rel=\"" + count2 + "\">");
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
//sb.Append("<div class=\"container\"><div><ul class=\"pager\">");
////for (int i = 0; i <= num;i++ )
////{
//// if (pageIndex == i + 1)
//// {
//// sb.Append("<li class=\"active\"><a href=\"javascript:;\" name=\""+count2+"\" rel="+count2+"."+(i+1)+">" + (i + 1) + "</a></li>");
//// }
//// else
//// {
//// sb.Append("<li><a href=\"javascript:;\" name=\""+count2+"\" rel=" + count2 + "." + (i + 1) + ">" + (i + 1) + "</a></li>");
//// }
////}
//sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 1 + ">上一页</a></li>");
//if (num==0)
//{
// sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">下一页</a></li>");
//}else{
// sb.Append("<li><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">下一页</a></li>");
//}
//sb.Append("</ul></div></div>");
sb.Append("<div id=\"page" + count2 + "\"></div>");
sb.Append("</div>");
count2++;
}
}
}
else if (valObj.DataBaseTable.SubTable_ExtField.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Many2Many.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MingXi.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MyTree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Tree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
}
}
catch (Exception ex)
{
}
return(sb.ToString());
}
private void getTemplateNameOptions()
{
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct= true;
conf.USER_ID =Convert.ToInt32(userBase.StaffID);
List<V_TF_TEMPLATE_TABLENAME> templateList = BLLTable<V_TF_TEMPLATE_TABLENAME>.Select(new V_TF_TEMPLATE_TABLENAME(), conf);
string html = "<option value='-1'>--无--</option>";
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
html += "<option value='" + temp.TABLE_NAME + "'>" + temp.CH_NAME + "</option>";
}
Response.Write("{\"html\":\"" + html + "\"}");
}
public JsonData Add(ITableImplement table, string tableName)
{
return(Add(tableName, table));
}
//抽象封装
private string getTree(ITableImplement val, AttributeItem pid, AttributeItem sortAttr, AttributeItem a)
{
return("");
}
int recount = -1; //��ѯ�ܼ�¼��
#endregion Fields
#region Methods
/// <summary>
/// ��ȡlistҳ������Դ
/// ֧����ģ�������
/// ֧��ö����
/// ֧��ʱ���ʽ
/// </summary>
/// <param name="f1"></param>
/// <returns></returns>
public string GetHtmlList(DataBaseField f1, ITableImplement this1)
{
string html = "";
try
{
DataBaseTable dt1 = f1.DataBaseTable;
if (f1 != dt1.IDField && f1 != dt1.NameField)
{
if (!f1.Desc.af_Enable) return "";//�Ƿ����
if (!f1.Desc.af_Visable) return "";//�Ƿ�ɼ�
}
AttributeItem attr1 = AttributeItem.Factory(f1);
object value1 = (this1.GetValue(attr1));
//DataBaseField f1;
DataBaseField id1 = dt1.IDField;
DataBaseField name1 = dt1.NameField;
if (f1 == dt1.IDField)//����ֶ�
{
//html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>";
}
else if (f1 == dt1.NameField)// != null && dt1.NameField.FieldName == f1.FieldName)//��ģ��name��ϸ����
{
string showUrl = "../" + f1.TableName + "/show.aspx";
if (!Exist(showUrl))
{
showUrl = "show.aspx";
}
html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + f1.TableName
+ "' target='_blank'>" + value1 + "</a>";
}
else if (isSelect(f1))//ö����
{
string str=Convert.ToString(value1);
if (str.Contains(",")) {
//��ѡ
string[] strs = str.Split(',');
List<object> valueList = new List<object>(strs);
List<object> nameList = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, valueList);
StringBuilder sb = new StringBuilder();
foreach(object s in nameList){
String ss=Convert.ToString(s);
sb.Append(ss+",");
}
html = sb.ToString();
html=html.Substring(0,html.LastIndexOf(","));
}
else {
//��ѡ
html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1);
}
}
else if (isChaZhao(f1))//����
{
DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField;
AttributeItem attr2 = AttributeItem.Factory(f2);
html = Convert.ToString(this1.GetValue(attr2));
//Ϊ�����ı��name��������
string showUrl = "../" + f1.TableName + "/show.aspx";
if (!Exist(showUrl))
{
showUrl = "show.aspx";
}
html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + f1.TableName
+ "' target='_blank'>" + html + "</a>";
}
else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage)
{
html = "<img src ='" + value1 + "' style='height:40px' />";
}
else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpUpDoc)
{//
if(!value1.Equals(" ")){
string val = Convert.ToString(value1);
string[] strs = val.Split(';');
for (int i = 0; i < strs.Length - 1; i++)
{
string[] ss=strs[i].Split(',');
string title = ss[0];
string url=ss[1];
html += "<span>" + title + " <a href='Back.aspx?moduleName="+ModuleName+"&download=true&filename="+url+"'>����</a></span>";
}
}
}
if (html == "")
{
html = Convert.ToString(value1);
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
}
return html;//.TrimEnd('\n').TrimEnd('\r').Trim();
}
protected void Page_Load(object sender, EventArgs e)
{
//base.Page_Init(sender, e);
//��ʼ��ģ����ز���
base.InitModule(ref valObj, ref KeyID, ref fieldList);
if (!string.IsNullOrEmpty(ModuleName))
{
condObj.af_PageBy(KeyID, Order.Desc);
finderObj._TableName = valObj._TableName;
}
title = valObj._ZhName + "����";
Page.Title = title;
if (!IsPostBack)
{
//�����ݿ��ȡ���õ�ȡֵ���������������Ϊ��ͼ��jinsj
Ec_View cond1 = new Ec_View();
cond1.ModuleName = valObj._TableName;
Ec_View v1 = BLLTable<Ec_View>.GetRowData(cond1);
if (v1 != null && v1.IsNotNull())
{
if (v1.ValueJsonString != "")
{
valObj = JsonServiceBase.FromJson<ITableImplement>(v1.ValueJsonString);
}
if (v1.ConditionJsonString != "")
{
condObj = JsonServiceBase.FromJson<ITableImplement>(v1.ConditionJsonString);
}
string viewName = v1.ViewName;
}
#region//Ĭ�����Գ�ʼ��
aspPager.CurrentPageIndex = 1;
txtPageSize.Value = "30";
aspPager.PageSize = 30;
#endregion
#region//���ݳ�ʼ��
#endregion
BindList(1);
}
if (hidCondition.Value != "")
{
//condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
}
if (hidFind.Value != "")
{
finderObj = JsonServiceBase.FromJson<ITableImplement>(hidFind.Value);
}
if (hidVal.Value != "")
{
//valObj111 = JsonServiceBase.FromJson<ITableImplement>(hidVal.Value);
}
if (valObj.IsNull())
{
//valObj111.LoadAllAttributes(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
#region �������������ģ�͡����ô˲���ģ��չʾ
if (Request["ModuleType"] != null)
{
string ModuleType = "";
if (Request["ModuleType"] != null)
{
ModuleType = Convert.ToString(Request["ModuleType"]);
}
//��ģ�飬������ ȡֵ���������� �ȡ�
if (ModuleType == "TF_TABLE")
{
msg = "δ�ƶ�����";
string ModuleTbName = Convert.ToString(Request["moduleName"]);
if (string.IsNullOrEmpty(ModuleTbName))
{
Response.Write(msg);
Response.End();
}
TF_TABLE condObj1 = new TF_TABLE();
condObj1.TB_NAME = ModuleTbName;
SetRequest(condObj1);
bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList,
out otherValueList, out condList, ref msg);//��ȡ������(������ʾ��)
msg = "�ƶ�ģ�������ģ��δ���ڣ��밲װ��ģ��";
if (!ret1)
{
Response.Write(msg);
Response.End();
}
//������������
SetRequest(condObj);
SetRequest(condList);
}
}
else
{
valObj = new ITableImplementHelper(conn).Factory("TF_TABLE");
condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();//
}
#endregion
title = valObj._ZhName + "����";
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (Request["submit"] != null)
{
}
if (!IsPostBack)
{
#region//Ĭ�����Գ�ʼ��
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//.WebCtrls
//txtPageSize.Value = "2";
aspPager.PageSize = 30;
//if (pid == "" || pid == "0")
//{
// a_top.Visible = false;
//}
#endregion
#region//����
BindCondition();
#endregion
#region//���ݳ�ʼ��
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
#endregion
BindList(1);
}
//Lit_ToolLeftButton;
}
catch (Exception ex)
{
HandleError(ex);
}
}
/// <summary>
/// ���ɱ�ǩģ�� + ����ֵ
/// </summary>
protected void TagBinding(Page page, List<Literal> lits, ITableImplement valObj, ITableImplement condObj, List<ITableImplement> listObj)
{
//isModule = true;
Content c1 = (Content)(page.FindControl("Content2"));
Literal Lit_Finder = (Literal)(page.FindControl("Lit_Finder"));
foreach (Literal lit in lits)
{
if (lit == null)
continue;
if (lit.ID == "Lit_Finder")
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj, condObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, condObj);
}
else if (lit.ID == "Lit_ListHeader")
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj);
}
else if (lit.ID == "Lit_RepList")
{
string old1 = lit.Text;
if (listObj.Count > 0)
{
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, listObj[0]);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, listObj);
}
else
lit.Text = "";
}
else
{
string old1 = lit.Text;
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj);
lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj);
}
}
}
private bool initParam()
{
if (string.IsNullOrEmpty(Request["template"]))//表名
DBTableName = Convert.ToString(Request["template"]);
if (string.IsNullOrEmpty(Request["template_id"]))//表的id
ID_FIELD = Convert.ToString(Request["template_id"]);
if (string.IsNullOrEmpty(Request["template_name"]))//表的名称
NAME_FIELD = Convert.ToString(Request["template_name"]);
if (string.IsNullOrEmpty(Request["template_pid"]))//表的父对象id
PID_FIELD = Convert.ToString(Request["template_pid"]);
if (string.IsNullOrEmpty(Request["template_type"]))//是否为树结构
IsTypeTree = Convert.ToString(Request["template_type"]);
itable = new ITableImplementHelper(conn).Factory(DBTableName);
if (string.IsNullOrEmpty(DBTableName)
||string.IsNullOrEmpty(ID_FIELD)
|| string.IsNullOrEmpty(NAME_FIELD)
||itable == null || itable.IsNull()
)
{
return false;
}
return true;
}
/// <summary>
/// TF_FORM 从配置中获得表单布局
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public bool Parse(TF_TABLE cond,
out ITableImplement valObj, out ITableImplement condObj, out List <Relation> relationList, out List <ITableImplement> otherValueList,
out List <ITableImplement> condList, ref string msg)
{
valObj = new ITableImplement();
condObj = new ITableImplement();
//载入关系
otherValueList = new List <ITableImplement>();
condList = new List <ITableImplement>();
relationList = new List <Relation>();
msg = "条件不存在";
if (string.IsNullOrEmpty(cond.TB_NAME))
{
return(false);
}
DataBaseTable tb1;
List <DataBaseField> listf1 = new List <DataBaseField>();
List <DataBaseTable> listTb1 = new List <DataBaseTable>();
bool ret = true; tb1 = null;
//TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond);
TF_TB_FIELD val1 = new TF_TB_FIELD();
TF_F_COLUMN val2 = new TF_F_COLUMN();
TF_TABLE val3 = new TF_TABLE();
TF_TB_FIELD cond1 = new TF_TB_FIELD();
TF_F_COLUMN cond2 = new TF_F_COLUMN();
TF_FORM cond3 = new TF_FORM();
List <ITableImplement> otherValueList1 = new List <ITableImplement>();
List <ITableImplement> condList1 = new List <ITableImplement>();
otherValueList1.Add(val2); otherValueList1.Add(val3);
condList1.Add(cond);
List <Relation> relationList1 = new List <Relation>();
relationList1.Add(RelationFactory.TF_TABLE_TF_FORM);
relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD);
relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN);
int pageSize = 100;
int pageIndex = 1;
int recount = -1;
string cachekey = null;
List <TF_TB_FIELD> list1 = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1,
pageSize, pageIndex, ref recount, out cachekey);
if (list1.Count == 0)
{
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME];
msg = cond.TB_NAME + " 数据表不存在";
if (dt1 == null)
{
ret = false;
ConsoleService.Warn(msg);
}
return(ret);
}
if (list1.Count > 90)
{
msg = "条件错误，所配置的字段记录超过90";
return(false);
}
//生成布局模版用
tb1 = new DataBaseTable();
foreach (TF_TB_FIELD item in list1)
{
string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower();
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
msg = tbName + " 数据表不存在"; ret = false;
if (dt1 == null)
{
ConsoleService.Warn(msg);
return(ret);
}
tb1 = dt1;
listTb1.Add(dt1);
//是否显示
object obj1 = null;
object obj2 = null;
object obj3 = null;
if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1))
{
dt1.IsVisable = true;
}
#endregion
string fieldName = item.FIELD_NAME.ToLower();
#region 列操作
DataBaseField f1 = null;
msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName);
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ret = false;
ConsoleService.Warn(msg);
continue;
}
//是否显示
obj1 = null; obj2 = null; obj3 = null;
if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1) &&
item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2) &&
item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3))
{
//f1.IsVisable = true;
}
#endregion
listf1.Add(f1);
}
//取值对象
valObj = ITableImplement.Factory(tb1);
//其他取值对象
foreach (DataBaseTable tb2 in listTb1)
{
if (tb2.TableName == tb1.TableName)
{
continue;
}
otherValueList.Add(ITableImplement.Factory(tb2));
}
//关系呢
return(ret);
}
/// <summary>
/// ����ӱ�
/// </summary>
/// <returns></returns>
protected string getSubForm()
{
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//�����id
object id1 = resultObj.GetValue(valObj.DataBaseTable.IDField);
string tableName1 = "��ϵ��1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
int count2 = 0;//����
foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
{
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List<Relation> lstRel = new List<Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List<ITableImplement> lstCond = new List<ITableImplement>();
lstCond.Add(cond2);
List<ITableImplement> lstOther = new List<ITableImplement>();
count1 = -1;
//��ʾ���Ա�� �������Ϣ
//value2.setConn(conn).setModule("WEC_QC_CARS");
List<ITableImplement> list2 = BLLTable<ITableImplement>.Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex,ref count1);
int num = count1 / pageSize;
if (list2.Count > 0)
{
sb.Append("<script type=\"text/javascript\">");
sb.Append("$(function () {");
sb.Append("$(\"#tbl" + tableName1 + "Title\").click(function () {");
sb.Append("$(\"#tbl" + tableName1 + "\").toggleClass(\"hide\");");
sb.Append("$(\"#tbl" + tableName1 + "Img\").toggleClass(\"showUp\");");
sb.Append("});");
//sb.Append("$(\"ul >li >a[name="+count2+"]\").click(function () {" +
// "alert($(this).attr(\"rel\"))" +
// "});");
// sb.Append("$(\"ul >li >a[name=" + count2 + "]\").click(function () {" +
// //"$(\"ul >li >a[name=" + count2 + "]\").parent().removeClass(\"active\");"+
// //"$(this).parent().addClass(\"active\");"+
// "var str = $(this).attr(\"rel\");" +
// "var strs = str.split(\".\");" +
// "var content=$(this).html();"+
// // "alert(content==\"��һҳ\");" +
// "if(content==\"��һҳ\"){"+
// "if((parseInt(strs[1])+1)<="+(num+1)+"){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);"+
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// " }else{"+
// "if((parseInt(strs[1])-1)>=1){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);"+
// "$(this).attr(\"rel\",prevStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// "}"+
// "$.ajax({" +
// "url:\"Back.aspx\"," +
// "type:\"post\"," +
// "data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":strs[1],\"num\":strs[0],\"id1\":"+id1+",\"paging\":\"true\"}," +
// "dataType:\"text\"," +
// "success: function (data) {" +
// "$(\"tbody[rel=\" + strs[0] + \"]\").html(data);" +
// "}," +
// "error: function (data) {" +
// "alert(data);" +
// "}" +
// "});" +
//"});");
sb.Append(" var options = {"+
"currentPage: 1,"+
"totalPages: "+(count1/10+1)+","+
"numberOfPages:5,"+
"onPageChanged:function(event){"+
// "alert($(event.currentTarget).find(\"ul li.active a\").html());" +
"$.ajax({" +
"url:\"Back.aspx\"," +
"type:\"post\"," +
"data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":$(event.currentTarget).find(\"ul li.active a\").html(),\"num\":" + count2 + ",\"id1\":" + id1 + ",\"paging\":\"true\"}," +
"dataType:\"text\"," +
"success: function (data) {" +
"$(\"tbody[rel="+count2+"]\").html(data);" +
"}," +
"error: function (data) {" +
"alert(data);" +
"}" +
"});" +
"}" +
"};"+
"$('#page"+count2+"').bootstrapPaginator(options);");
sb.Append("});");
sb.Append("</script>");
sb.Append("<div id='tbl" + tableName1 + "Title' class='showTitle'><span >" + value2._ZhName + "��Ϣ</span><span id='tbl" + tableName1 + "Img' class='showImg'></span></div>");
sb.Append("<div id='tbl" + tableName1 + "' class=\"tblist\">");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" id=\"tbList\" class=\"table table-hover\">");
sb.Append("<thead>");
sb.Append("<tr keyname=\"ID\">");
foreach (DataBaseField d2 in value2.af_GetAvailableDataBaseField())
{
sb.Append("<td data=\"{colname:'" + d2.LongAttributeName + "',show:1}\">" + d2.ZhName + "</td>");
}
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody rel=\""+count2+"\">");
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
//sb.Append("<div class=\"container\"><div><ul class=\"pager\">");
////for (int i = 0; i <= num;i++ )
////{
//// if (pageIndex == i + 1)
//// {
//// sb.Append("<li class=\"active\"><a href=\"javascript:;\" name=\""+count2+"\" rel="+count2+"."+(i+1)+">" + (i + 1) + "</a></li>");
//// }
//// else
//// {
//// sb.Append("<li><a href=\"javascript:;\" name=\""+count2+"\" rel=" + count2 + "." + (i + 1) + ">" + (i + 1) + "</a></li>");
//// }
////}
//sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 1 + ">��һҳ</a></li>");
//if (num==0)
//{
// sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">��һҳ</a></li>");
//}else{
// sb.Append("<li><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">��һҳ</a></li>");
//}
//sb.Append("</ul></div></div>");
sb.Append("<div id=\"page"+count2+"\"></div>");
sb.Append("</div>");
count2++;
}
}
}
else if (valObj.DataBaseTable.SubTable_ExtField.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Many2Many.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MingXi.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MyTree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Tree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
}
}
catch (Exception ex)
{
}
return sb.ToString();
}
/// <summary>
/// //自身为树，可以按照类型进行 树节点外观区别
/// //子相关对象
/// </summary>
/// <param name="p_tableTree"></param>
/// <param name="itables"></param>
private void setTree(ITableTree p_tableTree, List <ITableTree> ListTables)
{
string p_tableStr = p_tableTree.val.TableName();
ITableImplement p_table1 = ((ITableImplement)p_tableTree.val.Clone());
p_table1.LoadAllAttributes(true);
if (string.IsNullOrEmpty(p_table1.af_OrderByText) && p_tableTree.SORT_NO != null)
{
p_table1.OrderBy(p_tableTree.SORT_NO, Order.Asc);
}
#region 树 TF_TABLE
#region//显示子节点 TF_TABLE
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
string p_name = null;
string p_note = null;
string s_name = null;
string s_note = null;
if (nodetype == p_tableStr + "-root")
{
#region
ITableImplement obj = p_tableTree.val;
if (!obj.GetInitialized(p_tableTree.M_ID))
{
obj.SetValue(p_tableTree.M_ID, 0);
}
// p_table1.Top(1000);
List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(p_table1, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].GetValue(p_tableTree.ID)).Append("'");
sb.Append(",pid:'").Append("0").Append("',no:").Append((p_tableTree.SORT_NO != null)?lst[i].GetValue(p_tableTree.SORT_NO):"1");
p_name = Convert.ToString(lst[i].GetValue(p_tableTree.NAME));
if (string.IsNullOrEmpty(p_name))
{
p_name = p_note;
"".ToString();
}
else if (p_tableTree.NOTE != null)
{
p_note = Convert.ToString(lst[i].GetValue(p_tableTree.NOTE));
p_note = setNote(p_note, "", p_tableTree);
sb.Append(",note:'[").Append(p_note).Append("]'");
}
sb.Append(",name:'").Append(p_name).Append("'");
sb.Append(",sc:").Append("-1");
//CHG START 区分表管理和表单管理 jin-shenjian 2013/10/30
//sb.Append(",ntype:'" + p_tableStr + "'}");
if (p_tableStr.Equals("TF_FORM"))
{
//表单管理
sb.Append(",ntype:'" + p_tableStr + "_MANAGE'}");
}
else
{
//表管理
sb.Append(",ntype:'" + p_tableStr + "'}");
}
//CHG END 区分表管理和表单管理 jin-shenjian 2013/10/30
}
}
#endregion
}
//CHG START 增加树关系管理，布局管理，列表布局菜单 jin-shenjian 2013/10/30
//表单列表下添加三个管理菜单
else if (nodetype == p_tableStr + "_MANAGE")
{
sb.Append("{id:'").Append(id).Append("'");
sb.Append(",pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",name:'").Append("字段管理").Append("'");
sb.Append(",sc:").Append("-1");
sb.Append(",ntype:'" + p_tableStr + "'}");
sb.Append(",");
sb.Append("{id:'").Append(id).Append("'");
sb.Append(",pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",name:'").Append("关系管理").Append("'");
sb.Append(",sc:").Append("-1");
sb.Append(",ntype:'TF_TB_RELA'}");
sb.Append(",");
sb.Append("{id:'").Append(id).Append("'");
sb.Append(",pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",name:'").Append("布局管理").Append("'");
sb.Append(",sc:").Append("-1");
sb.Append(",ntype:'TF_FORM_DESIGN'}");
}
//布局管理下添加两个子菜单
else if (nodetype == p_tableStr + "_DESIGN")
{
sb.Append("{id:'").Append(id).Append("1'");
sb.Append(",pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",name:'").Append("列表布局").Append("'");
sb.Append(",sc:").Append("0");
sb.Append(",ntype:'TF_DESIGN_LIST'}");
sb.Append(",");
sb.Append("{id:'").Append(id).Append("2'");
sb.Append(",pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",name:'").Append("详细布局").Append("'");
sb.Append(",sc:").Append("0");
sb.Append(",ntype:'TF_DESIGN_DETAIL'}");
}
//ADD END 增加树关系管理，布局管理，列表布局菜单 jin-shenjian 2013/10/30
else if (nodetype == p_tableStr)//table1type.Contains(nodetype))
{
//if (nodetype == "TF_TABLE")//明细表，将不会再有子级的明细表。。。
{
#region
ITableImplement objTB = p_tableTree.val;
objTB.SetValue(p_tableTree.M_ID, int.Parse(id));
// p_table1.Top(1000);
List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(p_table1, objTB);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].GetValue(p_tableTree.ID)).Append("'");
sb.Append(",pid:'").Append(id).Append("',no:").Append((p_tableTree.SORT_NO != null)?lst[i].GetValue(p_tableTree.SORT_NO):"1");
p_name = Convert.ToString(lst[i].GetValue(p_tableTree.NAME));
if (string.IsNullOrEmpty(p_name))
{
p_name = p_note;
"".ToString();
}
else if (p_tableTree.NOTE != null)
{
p_note = Convert.ToString(lst[i].GetValue(p_tableTree.NOTE));
p_note = setNote(p_note, "", p_tableTree);
sb.Append(",note:'[").Append(p_note).Append("]'");
}
sb.Append(",name:'").Append(p_name).Append("'");
sb.Append(",sc:").Append("1");
sb.Append(",ntype:'" + p_tableStr + "'}");//TF_TABLE-mx
}
}
#endregion
}
#region
if (ListTables.Count > 0)
{
foreach (ITableTree s_tableTree1 in ListTables)
{
ITableImplement val1 = ((ITableImplement)s_tableTree1.val.Clone());
string table1 = val1.TableName();
if (string.IsNullOrEmpty(val1.af_OrderByText) && s_tableTree1.SORT_NO != null)
{
val1.OrderBy(s_tableTree1.SORT_NO, Order.Asc);
}
// val1.Top(1000);
ITableImplement condObj = ((ITableImplement)s_tableTree1.val.Clone());
condObj.SetValue(p_tableTree.ID, int.Parse(id));
List <ITableImplement> otherValue = new List <ITableImplement>();
otherValue.Add(p_table1);
List <ITableImplement> condtions = new List <ITableImplement>();
condtions.Add(condObj);
List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(val1, s_tableTree1.relations,
otherValue, condtions);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
ITableImplement table = lst[i];
sb.Append("{id:'").Append(table.GetValue(s_tableTree1.ID)).Append("'");
sb.Append(",pid:'").Append(table.GetValue(s_tableTree1.M_ID)).Append("',no:")
.Append((s_tableTree1.SORT_NO != null)?table.GetValue(s_tableTree1.SORT_NO):"1");
s_name = Convert.ToString(table.GetValue(s_tableTree1.NAME));
sb.Append(",name:'").Append(s_name).Append("'");
if (s_tableTree1.NOTE != null)
{
s_note = Convert.ToString(table.GetValue(s_tableTree1.NOTE));
if (s_tableTree1.NAME.TableName == "TF_TB_FIELD")
{
s_note = setNote(table.GetValue("TF_TABLE", "TB_NAME"), s_note, s_tableTree1);
}
sb.Append(",note:'[").Append(s_note).Append("]'");
}
sb.Append(",sc:").Append("0");
sb.Append(",ntype:'" + table1 + "'}");
}
}
}
}
#endregion
}
else
{
sb = new StringBuilder();
}
//sb.Append("{id:'").Append("1");
//sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
//sb.Append(",sc:").Append("1");
//sb.Append(",name:'").Append("aaaaa(aaa)").Append("',ntype:'TF_FORM'}");
if (sb.Length > 1)
{
sb.Append("]");
}
Response.Write(sb.ToString());
}
#endregion
#region//删除节点
if (Request["deleteNode"] != null)
{
string str = "";
string delID = Request["id"];
string ntype = Request["ntype"];
//CHG START 删除表单判断变更 jin-shenjian 2013/10/30
//if (ntype == p_tableStr)//if (ntype == "table" || ntype == "TF_TABLE-mx")
if (ntype == p_tableStr + "_MANAGE" || ntype == p_tableStr)//if (ntype == "table" || ntype == "TF_TABLE-mx")
//CHG END 删除表单判断变更 jin-shenjian 2013/10/30
{
#region //删除表
int re = 0;
string msg = "删除数据对象成功！"; // "删除数据库表成功！";
ITableImplement cccSub = ((ITableImplement)p_tableTree.val.Clone());
cccSub.SetValue(p_tableTree.M_ID, int.Parse(delID));
bool isAllowDel = true;
if (BLLTable <ITableImplement> .Count(cccSub) > 0)
{
isAllowDel = false;
msg = "存在明细对象，不能删除此对象";//"存在明细表，不能删除!";
}
else //相关子对象，相关子对象如果存在，能否被删除呢。级联删除。
{
if (ListTables.Count > 0)// "存在字段，不能删除此表";
{
foreach (ITableTree sub_table1 in ListTables)
{
ITableImplement hadcol = ((ITableImplement)sub_table1.val.Clone());
hadcol.SetValue(sub_table1.M_ID, int.Parse(delID));
if (BLLTable <ITableImplement> .Exists(hadcol))
{
msg = "存在相关对象（子对象），不能删除此对象";
isAllowDel = false;
break;
}
}
}
}
if (isAllowDel)
{
//外部条件
//TF_FORM useTB = new TF_FORM();
//useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'");
//if (BLLTable<TF_FORM>.Exists(useTB))
//{
// msg = "此表已倍表单使用，不能删除";
// goto _no_del;
//}
re = BLLTable <ITableImplement> .Factory(conn).Delete(p_tableTree.ID, delID);
if (re > 0)
{
//foreach (ITableTree sub_table1 in ListTables)
//{
// //???
// if (BLLTable<ITableImplement>.Factory(conn).Delete(sub_table1.M_ID, delID) < 0)
// {
// msg = "删除数据对象成功，但删除子对象信息失败！";
// }
// else
msg = "删除数据对象成功！";
//}
}
else
{
msg = "删除数据对象失败！";
}
//_no_del:
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else
{
if (ListTables.Count > 0)
{
foreach (ITableTree itable1 in ListTables)
{
if (ntype == itable1.val._TableName)//if (ntype == "field")
{
int re = 0;
string msg = "删除数据对象成功！";
#region//删除表字段
//ADD START 更新表字段是否使用状态 jin-shenjian 2013/10/28
//更新表字段是否使用状态
if (ntype.Equals("TF_F_COLUMN"))
{
TF_F_COLUMN objCond = new TF_F_COLUMN();
objCond.COLUMN_ID = Convert.ToInt32(delID);
TF_TB_FIELD objVal = new TF_TB_FIELD();
//字段未使用
objVal.CREATED = 0;
int ret2 = BLLTable <TF_TB_FIELD> .Factory(conn).Update(objVal, objCond, new Relation(TF_TB_FIELD.Attribute.FIELD_ID, TF_F_COLUMN.Attribute.FIELD_ID));
}
//ADD END 更新表字段是否使用状态 jin-shenjian 2013/10/28
int ret1 = BLLTable <ITableImplement> .Factory(conn).Delete(itable1.ID, delID);
if (ret1 <= 0)
{
msg = "删除数据对象失败！";
}
else
{
msg = "删除数据对象成功！";
}
#endregion
//CHG START 判断是否删除变量选错 jin-shenjian 2013/10/28
//str = "{re:" + re + ",msg:'" + msg + "'}";
str = "{re:" + ret1 + ",msg:'" + msg + "'}";
//CHG START 判断是否删除变量选错 jin-shenjian 2013/10/28
}
}
}
}
Response.Write(str);
}
#endregion
#endregion 树 TF_TABLE
}
//////////////////////////////////////////////////////////////////////////////////////////////
/// <summary>
/// 属性列表对象。适用于repList_ItemDataBound
/// </summary>
public string GetHTML(string templateList, ITableImplement valObj)
{
BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlValue);
bt.ConnectKey = conn;
string htmlEdit = bt.BuildByStr(templateList, "bs", valObj, @"c:\123.txt");
return htmlEdit;
}
protected void Page_Load(object sender, EventArgs e)
{
////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111&
// string id = HttpUtil.GetReqStrValue("id");
string pid = HttpUtil.GetReqStrValue("pid");
// string no = HttpUtil.GetReqStrValue("no");
// string name = HttpUtil.GetReqStrValue("name");
// string sc = HttpUtil.GetReqStrValue("sc");
// string ntype = HttpUtil.GetReqStrValue("ntype");
//DataBase db = DataBase.Factory(conn);
//foreach (DataBaseTable dt1 in db.DataTables_USER)
//{
// tableMap.Add(dt1.TableName,dt1.ZhName);
//}
TF_FORM conf1 = new TF_FORM();
conf1.FORM_ID = Convert.ToInt32(pid);
TF_FORM val1 = new TF_FORM();
val1.TB_ID = 1;
TF_FORM valObj1 = BLLTable <TF_FORM> .GetRowData(val1, conf1);
TF_TABLE conf2 = new TF_TABLE();
conf2.TB_ID = valObj1.TB_ID;
TF_TABLE val2 = new TF_TABLE();
val2.TB_NAME = "";
val2.CH_NAME = "";
val2.TB_ID = 0;
TF_TABLE valObj2 = BLLTable <TF_TABLE> .GetRowData(val2, conf2);
currTable = valObj2.TB_NAME;
currZhTable = valObj2.CH_NAME;
currTableId = valObj2.TB_ID;
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct = true;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
List <V_TF_TEMPLATE_TABLENAME> templateList = BLLTable <V_TF_TEMPLATE_TABLENAME> .Select(new V_TF_TEMPLATE_TABLENAME(), conf);
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
if (!tableMap.ContainsKey(temp.TABLE_NAME))
{
tableMap.Add(temp.TABLE_NAME, temp.CH_NAME);
}
}
TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE();
conf3.TABLE_NAME = valObj2.TB_NAME;
conf3.USER_ID = Convert.ToInt32(userBase.StaffID);
conf3.TYPE = 0;
List <TF_CUSTOM_TEMPLATE> templateList2 = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf3);
html = "<option value='-1'>--无--</option>";
foreach (TF_CUSTOM_TEMPLATE template in templateList2)
{
if (template.STATUS == 1)//被选中
{
selectedTempName = template.TEMPLATE_NAME;
html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>";
}
else
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
}
ITableImplement itable2 = new ITableImplement();
itable2.setConn(conn).setModule(valObj2.TB_NAME);
DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField();
fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf4 = new TF_TB_FIELD();
conf4.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val4 = BLLTable <TF_TB_FIELD> .GetRowData(conf4);
if (val4 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
// Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
//递归遍历
public List<Dictionary<string, object>> selectReverse(Dictionary<string, object> map, List<Dictionary<string, object>> mapList,ITableImplement table)
{
string tableName = "";
//取值视图配置
ITableImplement valObj = new ITableImplement();
//条件视图配置
ITableImplement condObj = new ITableImplement();
Dictionary<string, object> flagMap = new Dictionary<string, object>();
Dictionary<string, Dictionary<string, object>> nextMap = new Dictionary<string, Dictionary<string, object>>();
foreach(var item in map){
// Dictionary<string, object> temp2List = new Dictionary<string, object>();
if (item.Key.Equals("tableName"))
{
tableName = item.Value.ToString();
valObj.setConn(conn).setModule(item.Value.ToString(), false, true);
condObj.setConn(conn).setModule(item.Value.ToString(), false, true);
}else if (item.Key.Equals("condition")){
condObj.af_WhereSQL = " " + item.Value;
} else{
if (item.Value is string)
{
valObj[item.Key] = item.Value;
flagMap[item.Key]= item.Value;
}
else {
flagMap[item.Key]= new object();
// valObj[item.Key] = temp3List;
nextMap.Add(item.Key, (Dictionary<string, object>)item.Value);
}
}
}
if (table != null)
{
// foreach(ITableImplement table in tableList){
//条件视图配置 (这里要每次都new 一个 因为循环 每次都要同的条件)
ITableImplement condObj2 = new ITableImplement();
condObj2.setConn(conn).setModule(tableName.ToString(), false, true);
condObj2.af_WhereSQL = condObj.af_WhereSQL;
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
foreach (DataBaseField dataBaseField in dataBaseFields)
{
condObj2.af_WhereSQL = condObj2.af_WhereSQL.Replace("{" + dataBaseField.FieldName + "}", "'" + table[dataBaseField.FieldName].ToString() + "'");
}
condObj = condObj2;
}
List<ITableImplement> temp4List = BLLTable<ITableImplement>.Factory(conn).Select(valObj, condObj);
foreach (ITableImplement itable in temp4List)
{
Dictionary<string, object> tempMap = new Dictionary<string, object>();
foreach (var flag in flagMap)
{
if (flag.Value is string)
{
tempMap.Add(flag.Key, itable[flag.Key]);
}
else
{
tempMap.Add(flag.Key, selectReverse(nextMap[flag.Key], new List<Dictionary<string, object>>(), itable));
}
}
mapList.Add(tempMap);
}
return mapList;
}
protected void Page_Load(object sender, EventArgs e)
{
if(Request["deleteFile"]==null){
base.InitModule(ref valObj, ref KeyID, ref fieldList);
}
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelID"] != null)
{
valObj.SetValue(valObj.KeyID, Request["DelID"]);
int re = BLLTable<ITableImplement>.Factory(conn).Delete(valObj);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
ITableImplement cond = valObj;
cond.In(AttributeItem.Factory(cond.DataBaseTable.IDField), Request["DelKeyIDS"]);
int re = BLLTable<ITableImplement>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
valObj.SetValue(valObj.KeyID, Request["FieldKeyID"]);
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) {
valObj.SetValue(lstCol[i], Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable<ITableImplement>.Factory(conn).Update(valObj, valObj.KeyID);
Response.Write("�ļ�¼��Ϣ�ɹ�");
}
//ɾ�������ļ�
if (Request["deleteFile"] != null)
{
//string filepath=WebHelper.GetAppPath() + Request["fileName"];
string filepath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + Request["fileName"]; ;
if (File.Exists(filepath)) {
File.Delete(filepath);
}
}
//��ҳAJAX����
if(Request["paging"]!=null){
int pageSize = 10; int pageIndex = 1; int count1 = -1;
pageIndex = Convert.ToInt32(HttpUtil.GetReqStrValue("pageIndex"));
int num = Convert.ToInt32(HttpUtil.GetReqStrValue("num")); ;
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//�����id
object id1 = HttpUtil.GetReqStrValue("id1");
string tableName1 = "��ϵ��1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
// foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
//{
DataBaseTableRelation dr1 = valObj.DataBaseTable.SubTable_ChaZhao[num];
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List<Relation> lstRel = new List<Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List<ITableImplement> lstCond = new List<ITableImplement>();
lstCond.Add(cond2);
List<ITableImplement> lstOther = new List<ITableImplement>();
//��ʾ���Ա�� �������Ϣ
//value2.setConn(conn).setModule("WEC_QC_CARS");
List<ITableImplement> list2 = BLLTable<ITableImplement>.Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex, ref count1);
// BLLTable.SQL_Test.ToString();
if (list2.Count > 0)
{
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
}
}
}
}
catch (Exception ex)
{
}
Response.Write(sb.ToString());
}
//�����ļ�
if(Request["download"]!=null){
string filename = Request["filename"];
string fullpath =Request.PhysicalApplicationPath +filename;
Response.ContentType = "APPLICATION/OCTET-STREAM";
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename.Substring(filename.LastIndexOf("/") + 1));
FileStream fs = new FileStream(fullpath,FileMode.Open);
int len=(int)fs.Length;
byte[] buf = new byte[len];
int count;
int sum = 0;
while ((count = fs.Read(buf, 0, len)) > 0)
{
sum += count;
Response.OutputStream.Write(buf,0,count);
}
}
Response.End();
}
/// <summary>
/// TF_FORM 从配置中获得表单布局
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public bool Parse(TF_TABLE cond,
out ITableImplement valObj, out ITableImplement condObj, out List<Relation> relationList, out List<ITableImplement> otherValueList,
out List<ITableImplement> condList, ref string msg)
{
valObj = new ITableImplement();
condObj = new ITableImplement();
//载入关系
otherValueList = new List<ITableImplement>();
condList = new List<ITableImplement>();
relationList = new List<Relation>();
msg = "条件不存在";
if (string.IsNullOrEmpty(cond.TB_NAME))
return false;
DataBaseTable tb1;
List<DataBaseField> listf1 = new List<DataBaseField>();
List<DataBaseTable> listTb1 = new List<DataBaseTable>();
bool ret = true; tb1 = null;
//TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond);
TF_TB_FIELD val1 = new TF_TB_FIELD();
TF_F_COLUMN val2 = new TF_F_COLUMN();
TF_TABLE val3 = new TF_TABLE();
TF_TB_FIELD cond1 = new TF_TB_FIELD();
TF_F_COLUMN cond2 = new TF_F_COLUMN();
TF_FORM cond3 = new TF_FORM();
List<ITableImplement> otherValueList1 = new List<ITableImplement>();
List<ITableImplement> condList1 = new List<ITableImplement>();
otherValueList1.Add(val2); otherValueList1.Add(val3);
condList1.Add(cond);
List<Relation> relationList1 = new List<Relation>();
relationList1.Add(RelationFactory.TF_TABLE_TF_FORM);
relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD);
relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN);
int pageSize = 100;
int pageIndex = 1;
int recount = -1;
string cachekey = null;
List<TF_TB_FIELD> list1 = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1,
pageSize, pageIndex, ref recount, out cachekey);
if (list1.Count == 0)
{
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME];
msg = cond.TB_NAME + " 数据表不存在";
if (dt1 == null)
{
ret = false;
ConsoleService.Warn(msg);
}
return ret;
}
if (list1.Count > 90)
{
msg = "条件错误，所配置的字段记录超过90";
return false;
}
//生成布局模版用
tb1 = new DataBaseTable();
foreach (TF_TB_FIELD item in list1)
{
string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower();
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
msg = tbName + " 数据表不存在"; ret = false;
if (dt1 == null)
{
ConsoleService.Warn(msg);
return ret;
}
tb1 = dt1;
listTb1.Add(dt1);
//是否显示
object obj1 = null;
object obj2 = null;
object obj3 = null;
if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1))
{
dt1.IsVisable = true;
}
#endregion
string fieldName = item.FIELD_NAME.ToLower();
#region 列操作
DataBaseField f1 = null;
msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName);
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ret = false;
ConsoleService.Warn(msg);
continue;
}
//是否显示
obj1 = null; obj2 = null; obj3 = null;
if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1)
&& item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2)
&& item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3))
{
//f1.IsVisable = true;
}
#endregion
listf1.Add(f1);
}
//取值对象
valObj = ITableImplement.Factory(tb1);
//其他取值对象
foreach (DataBaseTable tb2 in listTb1)
{
if (tb2.TableName == tb1.TableName) continue;
otherValueList.Add(ITableImplement.Factory(tb2));
}
//关系呢
return ret;
}
public string GetTemplate(string template, ITableImplement valObj, ITableImplement condObj)
{
try
{
BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlTemplate);
bt.ConnectKey = conn;
string template1 = bt.BuildByStr(template, "bs", Parse(valObj, condObj), @"c:\123.txt");
return template1;
}
catch (Exception ex)
{
File.AppendAllText(Path.Combine(WebHelper.GetAppPath(), "abc.txt"), ex.ToString());
throw ex;
}
return "";
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
ITableImplement valdata = valObj;//.Clone();
foreach (DataBaseField f1 in valObj.af_GetAvailableDataBaseField())
{
if (f1.TableName.ToLower() == valObj._TableName.ToLower())//±¾±í×Ö¶Î
{
string fieldValue;
if (TryGetRequest(f1, out fieldValue))
{
AttributeItem attr1 = new AttributeItem(f1);
valdata.SetValue(attr1, fieldValue);
}
}
}
if (keyid != "")
{
valdata.SetValue(valdata.KeyID, Convert.ToDecimal(keyid));
count = BLLTable <ITableImplement> .Factory(conn).Update(valdata, valdata.KeyID);
}
else
{
count = BLLTable <ITableImplement> .Factory(conn).Insert(valdata, valdata.KeyID);
string ss = BLLTable.SQL_Test.ToString();
keyid = Convert.ToString(valdata.GetValue(valdata.KeyID));
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("{valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else
{
ViewState["sbData"] += "," + sbData.ToString();
}
Button btn = (Button)sender;
//if (btn.ID.IndexOf("btnOK")!=-1)//±£´æÍ˳ö
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"].ToString() + "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';};window.close();", true);
}
}
//else //½ö±£´æ
{
}
}
else
{
//ÈçºÎ´¦Àí
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//base.Page_Init(sender, e);
//��ʼ��ģ����ز���
base.InitModule(ref valObj, ref KeyID, ref fieldList);
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
resultObj.IsOnlyForModuleIDName = false;
valObj.IsOnlyForModuleIDName = false;
if (!string.IsNullOrEmpty(Request["ID"]))
{
AttributeItem id1 = AttributeItem.Factory(valObj.DataBaseTable.IDField);
ITableImplement cond1 = new ITableImplement(); cond1.SetValue(id1, Request["ID"]);
resultObj = BLLTable<ITableImplement>.Factory(conn).GetRowData(valObj, cond1);
if (resultObj == null)
{
ScriptHelper.Alert(this, "��¼������");
ScriptHelper.CloseMe(this);
return;
}
BLLTable.SQL_Test.ToArray();
object obj1 = resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE);
}
}
catch (Exception ex)
{
//litWarn.Text = ex.Message;
}
}
}
public JsonData Add(string tableName, ITableImplement table)
{
this.tableName = tableName;
this.table = table;
return(this);
}
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager)
{
int recount = -1;
asppager.PageSize = 20;
switch (asppager.ID)
{
case "aspAllCusPager":
case "aspContractedPager":
V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER;
if (vcrmscCon == null)
return;
if (asppager.ID == "aspAllCusPager")
hidAllCus.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon);
else
hidContracted.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon);
vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER();
valsc._SID = "";
valsc.Cus_ID = 0;
valsc.CompanyName = "";
valsc.ShopName = "";
valsc.Cus_Name = "";
valsc.CustQQ = "";
valsc.WangWangId = "";
valsc.LastContactTime = DateTime.MinValue;
valsc.SNAME = "";
valsc.CustStatus = 0;
List<V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable<V_CRM_STAFF_CUSTOMER>.Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscList.Count > 0)
{
FormHelper.Bind(Page, vcrmscList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspAllCusPager")
{
repAllCusList.DataSource = vcrmscList;
repAllCusList.DataBind();
}
else
{
lit_ContractedCusCount.Text = recount.ToString();
repContractedList.DataSource = vcrmscList;
repContractedList.DataBind();
}
asppager.RecordCount = recount;
break;
case "aspToDayMustConPager":
case "aspExpiredPager":
case "aspWillInHighSeasPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT;
if (vcrmscnCon == null)
return;
if (asppager.ID == "aspToDayMustConPager")
hidToDayMustCon.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
else if (asppager.ID == "aspExpiredPager")
hidExpired.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
else
hidWillInHighSeas.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valscn.STAFF_ID = 0;
valscn.Cus_ID = 0;
valscn.CompanyName = "";
valscn.ShopName = "";
valscn.Cus_Name = "";
valscn.CustQQ = "";
valscn.WangWangId = "";
valscn.LastContactTime = DateTime.MinValue;
valscn.NextContactTime = DateTime.MinValue;
valscn.SNAME = "";
valscn.CustStatus = 0;
List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscnList.Count > 0)
{
FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspToDayMustConPager")
{
lit_todayConCusCount.Text = recount.ToString();
repToDayMustConList.DataSource = vcrmscnList;
repToDayMustConList.DataBind();
}
else if (asppager.ID == "aspExpiredPager")
{
lit_ExpiredUnConCusCount.Text = recount.ToString();
repExpiredList.DataSource = vcrmscnList;
repExpiredList.DataBind();
}
else
{
lit_WillInHighSeasCusCount.Text = recount.ToString();
repWillInHighSeasList.DataSource = vcrmscnList;
repWillInHighSeasList.DataBind();
}
asppager.RecordCount = recount;
break;
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ID"]))
{
keyid = Request["ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["record"]))
{
keyid = Request["record"];
}
if (!IsPostBack)
{
try
{
if (string.IsNullOrEmpty(keyid))//����
{
}
else//��
{
ITableImplement cond1 = valObj.Clone(); cond1.SetValue(KeyID, keyid);
resultObj = BLLTable<ITableImplement>.Factory(conn).GetRowData(valObj, cond1);
if (resultObj == null)
{
ScriptHelper.Alert(this, "��¼������");
ScriptHelper.CloseMe(this); return;
}
//string html = Convert.ToString(resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE));
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
if (valObj.IsNull())
{
//valObj.LoadAllAttributes(true);
}
}
private void getTemplateOptionsAndField()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
List<TF_CUSTOM_TEMPLATE> templateList = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf);
string html = "<option value='-1'>--无--</option>";
if (tableName.Equals("-1"))
{
Response.Write("{\"html\":\"" + html + "\"}");
return;
}
foreach(TF_CUSTOM_TEMPLATE template in templateList){
html += "<option value='"+template.ID+"'>"+template.TEMPLATE_NAME+"</option>";
}
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField();
string fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val2 = BLLTable<TF_TB_FIELD>.GetRowData(conf2);
if (val2 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>";
}
else {
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
if (!string.IsNullOrEmpty(ModuleName))
{
pageAttr1 = AttributeItem.Factory(valObj.DataBaseTable.IDField);
condObj.af_PageBy(pageAttr1, Order.Desc);
//condObj111._TableName = valObj111._TableName;
finderObj._TableName = valObj._TableName;
DataBaseField[] ds1 = valObj.af_GetAvailableDataBaseField();
foreach (DataBaseField f1 in ds1)
{
if (!f1.Desc.af_Enable || !f1.Desc.af_Visable)
continue;
fieldList.Add(f1);
}
}
title = valObj._ZhName + "����";
Page.Title = title;
if (!IsPostBack)
{
//�����ݿ��ȡ���õ�ȡֵ���������������Ϊ��ͼ��jinsj
Ec_View cond1 = new Ec_View();
cond1.ModuleName = valObj._TableName;
Ec_View v1 = BLLTable<Ec_View>.GetRowData(cond1);
if (v1 != null && v1.IsNotNull())
{
if (v1.ValueJsonString != "")
{
valObj = JsonServiceBase.FromJson<ITableImplement>(v1.ValueJsonString);
}
if (v1.ConditionJsonString != "")
{
condObj = JsonServiceBase.FromJson<ITableImplement>(v1.ConditionJsonString);
}
string viewName = v1.ViewName;
}
#region//Ĭ�����Գ�ʼ��
aspPager.CurrentPageIndex = 1;
txtPageSize.Value = "30";
aspPager.PageSize = 30;
#endregion
#region//���ݳ�ʼ��
#endregion
BindList(1);
}
if (hidCondition.Value != "")
{
//condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
}
if (hidFind.Value != "")
{
finderObj = JsonServiceBase.FromJson<ITableImplement>(hidFind.Value);
}
if (hidVal.Value != "")
{
//valObj111 = JsonServiceBase.FromJson<ITableImplement>(hidVal.Value);
}
if (valObj.IsNull())
{
//valObj111.LoadAllAttributes(true);
}
}
//递归遍历
public List <Dictionary <string, object> > selectReverse(Dictionary <string, object> map, List <Dictionary <string, object> > mapList, ITableImplement table)
{
string tableName = "";
//取值视图配置
ITableImplement valObj = new ITableImplement();
//条件视图配置
ITableImplement condObj = new ITableImplement();
Dictionary <string, object> flagMap = new Dictionary <string, object>();
Dictionary <string, Dictionary <string, object> > nextMap = new Dictionary <string, Dictionary <string, object> >();
foreach (var item in map)
{
// Dictionary<string, object> temp2List = new Dictionary<string, object>();
if (item.Key.Equals("tableName"))
{
tableName = item.Value.ToString();
valObj.setConn(conn).setModule(item.Value.ToString(), false, true);
condObj.setConn(conn).setModule(item.Value.ToString(), false, true);
}
else if (item.Key.Equals("condition"))
{
condObj.af_WhereSQL = " " + item.Value;
}
else
{
if (item.Value is string)
{
valObj[item.Key] = item.Value;
flagMap[item.Key] = item.Value;
}
else
{
flagMap[item.Key] = new object();
// valObj[item.Key] = temp3List;
nextMap.Add(item.Key, (Dictionary <string, object>)item.Value);
}
}
}
if (table != null)
{
// foreach(ITableImplement table in tableList){
//条件视图配置 (这里要每次都new 一个 因为循环 每次都要同的条件)
ITableImplement condObj2 = new ITableImplement();
condObj2.setConn(conn).setModule(tableName.ToString(), false, true);
condObj2.af_WhereSQL = condObj.af_WhereSQL;
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
foreach (DataBaseField dataBaseField in dataBaseFields)
{
condObj2.af_WhereSQL = condObj2.af_WhereSQL.Replace("{" + dataBaseField.FieldName + "}", "'" + table[dataBaseField.FieldName].ToString() + "'");
}
condObj = condObj2;
}
List <ITableImplement> temp4List = BLLTable <ITableImplement> .Factory(conn).Select(valObj, condObj);
foreach (ITableImplement itable in temp4List)
{
Dictionary <string, object> tempMap = new Dictionary <string, object>();
foreach (var flag in flagMap)
{
if (flag.Value is string)
{
tempMap.Add(flag.Key, itable[flag.Key]);
}
else
{
tempMap.Add(flag.Key, selectReverse(nextMap[flag.Key], new List <Dictionary <string, object> >(), itable));
}
}
mapList.Add(tempMap);
}
return(mapList);
}
private void SaveState()
{
#region ��ȡ����
finderObj = new ITableImplement();
foreach (DataBaseField f1 in valObj.af_GetAvailableDataBaseField())
{
string fieldValue = null;
AttributeItem attr1 = null;
try
{
if (isChaZhao(f1))
{
if (TryGetRequest(f1.Desc.FieldCtrlName + "_NAME", out fieldValue))
{
attr1 = new AttributeItem(f1.TableName, f1.Desc.FieldCtrlName + "_NAME");
finderObj.SetValue(attr1, fieldValue);
}
}
if (TryGetRequest(f1, out fieldValue))
{
attr1 = new AttributeItem(f1);
finderObj.SetValue(attr1, fieldValue);
if (!string.IsNullOrEmpty(fieldValue))
condObj.Like(attr1, fieldValue);
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
litWarn.Text = ex.Message + ":" + attr1.LongName + "=" + fieldValue;
}
}
//hidVal.Value = valObj111.ToJson(20);
//hidCondition.Value = condObj111.ToJson(20);
hidFind.Value = finderObj.ToJson(20);
//if (hidCondition.Value != "")
//{
// condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
//}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["deleteFile"] == null)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
}
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelID"] != null)
{
valObj.SetValue(valObj.KeyID, Request["DelID"]);
int re = BLLTable <ITableImplement> .Factory(conn).Delete(valObj);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
ITableImplement cond = valObj;
cond.In(AttributeItem.Factory(cond.DataBaseTable.IDField), Request["DelKeyIDS"]);
int re = BLLTable <ITableImplement> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
valObj.SetValue(valObj.KeyID, Request["FieldKeyID"]);
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
valObj.SetValue(lstCol[i], Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <ITableImplement> .Factory(conn).Update(valObj, valObj.KeyID);
Response.Write("修改记录信息成功");
}
//删除本地文件
if (Request["deleteFile"] != null)
{
//string filepath=WebHelper.GetAppPath() + Request["fileName"];
string filepath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + Request["fileName"];;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
}
//分页AJAX请求
if (Request["paging"] != null)
{
int pageSize = 10; int pageIndex = 1; int count1 = -1;
pageIndex = Convert.ToInt32(HttpUtil.GetReqStrValue("pageIndex"));
int num = Convert.ToInt32(HttpUtil.GetReqStrValue("num"));;
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//父表的id
object id1 = HttpUtil.GetReqStrValue("id1");
string tableName1 = "关系表1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
// foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
//{
DataBaseTableRelation dr1 = valObj.DataBaseTable.SubTable_ChaZhao[num];
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List <Relation> lstRel = new List <Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List <ITableImplement> lstCond = new List <ITableImplement>();
lstCond.Add(cond2);
List <ITableImplement> lstOther = new List <ITableImplement>();
//显示明显表的 父表的信息
//value2.setConn(conn).setModule("WEC_QC_CARS");
List <ITableImplement> list2 = BLLTable <ITableImplement> .Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex, ref count1);
// BLLTable.SQL_Test.ToString();
if (list2.Count > 0)
{
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
}
}
}
}
catch (Exception ex)
{
}
Response.Write(sb.ToString());
}
//下载文件
if (Request["download"] != null)
{
string filename = Request["filename"];
string fullpath = Request.PhysicalApplicationPath + filename;
Response.ContentType = "APPLICATION/OCTET-STREAM";
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename.Substring(filename.LastIndexOf("/") + 1));
FileStream fs = new FileStream(fullpath, FileMode.Open);
int len = (int)fs.Length;
byte[] buf = new byte[len];
int count;
int sum = 0;
while ((count = fs.Read(buf, 0, len)) > 0)
{
sum += count;
Response.OutputStream.Write(buf, 0, count);
}
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111&
// string id = HttpUtil.GetReqStrValue("id");
string pid = HttpUtil.GetReqStrValue("pid");
// string no = HttpUtil.GetReqStrValue("no");
// string name = HttpUtil.GetReqStrValue("name");
// string sc = HttpUtil.GetReqStrValue("sc");
// string ntype = HttpUtil.GetReqStrValue("ntype");
//DataBase db = DataBase.Factory(conn);
//foreach (DataBaseTable dt1 in db.DataTables_USER)
//{
// tableMap.Add(dt1.TableName,dt1.ZhName);
//}
TF_FORM conf1 = new TF_FORM();
conf1.FORM_ID = Convert.ToInt32(pid);
TF_FORM val1 = new TF_FORM();
val1.TB_ID = 1;
TF_FORM valObj1 = BLLTable<TF_FORM>.GetRowData(val1, conf1);
TF_TABLE conf2 = new TF_TABLE();
conf2.TB_ID = valObj1.TB_ID;
TF_TABLE val2 = new TF_TABLE();
val2.TB_NAME = "";
val2.CH_NAME = "";
val2.TB_ID = 0;
TF_TABLE valObj2 = BLLTable<TF_TABLE>.GetRowData(val2, conf2);
currTable = valObj2.TB_NAME;
currZhTable = valObj2.CH_NAME;
currTableId = valObj2.TB_ID;
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct = true;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
List<V_TF_TEMPLATE_TABLENAME> templateList = BLLTable<V_TF_TEMPLATE_TABLENAME>.Select(new V_TF_TEMPLATE_TABLENAME(), conf);
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
if (!tableMap.ContainsKey(temp.TABLE_NAME))
{
tableMap.Add(temp.TABLE_NAME, temp.CH_NAME);
}
}
TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE();
conf3.TABLE_NAME = valObj2.TB_NAME;
conf3.USER_ID = Convert.ToInt32(userBase.StaffID);
conf3.TYPE = 0;
List<TF_CUSTOM_TEMPLATE> templateList2 = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf3);
html = "<option value='-1'>--无--</option>";
foreach (TF_CUSTOM_TEMPLATE template in templateList2)
{
if (template.STATUS == 1)//被选中
{
selectedTempName = template.TEMPLATE_NAME;
html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>";
}
else
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
}
ITableImplement itable2 = new ITableImplement();
itable2.setConn(conn).setModule(valObj2.TB_NAME);
DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField();
fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf4 = new TF_TB_FIELD();
conf4.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val4 = BLLTable<TF_TB_FIELD>.GetRowData(conf4);
if (val4 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
// Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
