private void Init1(string dev1)
{
string connectStr = BillBase.GetConnByDevKey(dev1);
Title = Convert.ToString(dev1) + "数据源" + "管理" + connectStr;
DataBase db = new DataBase(DataBaseConnectStringHelper.GetDataBaseType(connectStr, ""), connectStr);
DataBaseTableCollection tbs = db.DataTables;
if (tbs != null)
{
repCus.DataSource = tbs;
repCus.DataBind();
}
if (txtDEV.Items.Count > 0)
{
txtDEV.SelectedValue = dev1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string dev1 = null;
if (Request["DEV2"] != null)
{
dev1 = Request["DEV2"];
}
#region////显示子节点
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
DataBase m_db = null;
if (dev1 == null)
{
m_db = DataBase.Factory(conn);
}
else
{
m_db = DataBase.Factory(BillBase.GetConnByDevKey(dev1));
}
if (nodetype == "bill-root")
{
#region
m_db.Load(true);
DataBaseTableCollection lst = m_db.DataTables;
if (lst != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (lst[i].TableName.IndexOf("U_") != 0)
{
DataBaseFieldCollection lstFie = lst[i].DataFields;
bool haveClientField = false;
if (lstFie.Count > 0)
{
for (int j = 0; j < lstFie.Count; j++)
{
if (lstFie[j].FieldName.IndexOf("U_") == 0)
{
haveClientField = true;
break;
}
}
}
if (!haveClientField)
{
continue;
}
}
string dev = ".";
if (Request["tbs"] != null)
{
dev = InMTable(Request["tbs"], lst[i].TableName);
if (dev == ".")
{
continue;
}
//if (Request["tbs"].IndexOf(lst[i].TableName)== -1)
//{
// continue;
//}
}
if (sb.Length > 2)
{
sb.Append(",");
}
string[] arr = dev.Split('.');
sb.Append("{id:'").Append(lst[i].TableName);
sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
sb.Append(",sc:").Append("1,dev:'" + arr[0] + "',tb:'" + arr[1] + "'");
sb.Append(",name:'").Append(lst[i].TableName).Append("',note:'[" + lst[i].Desc.ZhName + "]'").Append(",ntype:'bill'}");
}
}
#endregion
}
if (nodetype == "bill")
{
#region
if (m_db.DataTables.Contains(id))
{
DataBaseTable tb = m_db.DataTables[id];
DataBaseFieldCollection lst = tb.DataFields;
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (lst[i].FieldName.IndexOf("U_") != 0)
{
continue;
}
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FieldName.ToString());
sb.Append("',pid:'").Append(id).Append("',no:").Append("1");
sb.Append(",sc:").Append("0,dev:'" + Request["dev"] + "',tb:'" + Request["tb"] + "'");
sb.Append(",name:'").Append(lst[i].FieldName).Append("',note:'[" + lst[i].Desc.ZhName + "]'").Append(",ntype:'col'}");
//< > <>
}
}
}
#endregion
}
//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:'table'}");
sb.Append("]");
Response.Write(sb.ToString());
}
#endregion
#region//删除节点
if (Request["deleteNode"] != null)
{
string str = "";
string delID = Request["id"];
string ntype = Request["ntype"];
if (ntype == "bill" || ntype == "bill-mx")
{
#region//删除表
SYS_BILL_EXD eee = new SYS_BILL_EXD(int.Parse(delID));
string msg = "";
int re = eee.DB_DeleteTable(true, ref msg) == true ? 1 : 0;
#endregion
str = "{re:" + re + ",msg:'" + (re > 0 ? "删除成功" : "删除失败！") + "！'}";
}
else if (ntype == "col")
{
#region//删除表字段
//string msg = "删除数据库表字段成功！";
//SYS_BILL_EXD bllexd = new SYS_BILL_EXD(int.Parse(Request["pid"]));
//int re = bllexd.AD_DelCol(int.Parse(delID));// TF_TABLEHelper.DelField(delID);// ;
//if (re > 0)
//{
// msg = "删除数据库表字段成功！";
//}
//else
//{
// msg = "删除数据库表字段失败！";
//}
#endregion
str = "";// "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "syncol")
{
#region//删除表字段
string msg = "删除同步字段成功！";
int re = BLLTable <SYS_BILL_COL_SYN> .Factory(conn).Delete(SYS_BILL_COL_SYN.Attribute.COL_SYNID, delID);
if (re > 0)
{
msg = "删除同步字段成功！";
}
else
{
msg = "删除同步字段失败！";
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
Response.Write(str);
}
#endregion
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelBILL_ID"] != null)
{
int re = BLLTable <SYS_BILL> .Factory(conn).Delete(SYS_BILL.Attribute.BILL_ID, Request["DelBILL_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
SYS_BILL cond = new SYS_BILL();
cond.In(SYS_BILL.Attribute.BILL_ID, Request["DelKeyIDS"]);
int re = BLLTable <SYS_BILL> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
SYS_BILL val = new SYS_BILL();
val.BILL_ID = int.Parse(Request["FieldKeyID"]);
List <AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <SYS_BILL> .Factory(conn).Update(val, SYS_BILL.Attribute.BILL_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}