protected void Page_Load(object sender, EventArgs e)
{
SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"]));
SYS_BILL_BLL billExd = new SYS_BILL_BLL(int.Parse(Request["BillID"]));
litView.Text = billExd.HtmlEditForm();
hidAppPath.Value = WebHelper.GetAppPath();
List <SYS_BILL_COL> cols = bill.GetColList();
Dictionary <string, int> tbkeynum = new Dictionary <string, int>();
if (cols != null)
{
for (int i = 0; i < cols.Count; i++)
{
if (!tbkeynum.ContainsKey(cols[i].TABLE_NAME))
{
tbkeynum.Add(cols[i].TABLE_NAME, 0);
}
if (cols[i].ISPK == "1")
{
tbkeynum[cols[i].TABLE_NAME] += 1;
}
}
}
//foreach (KeyValuePair<string, int> key in tbkeynum) {
// //Response.Write(key.Key);
// if (key.Value == 0)
// {
// if (key.Key != bill.Base.TABLE_NAME)
// {
// litWarn.Text += "主表单里未配置外部关联表" + key.Key + "的主键，无法与外部表信息同步。";
// }
// else {
// litWarn.Text += key.Key + "未配置主键。";
// }
// }
// else if (key.Value > 1)
// {
// if (key.Key != bill.Base.TABLE_NAME)
// {
// litWarn.Text += "主表单里配置了多个外部关联表"+key.Key + "的主键，可能导致信息同步异常。";
// }
// }
//}
litList.Text = billExd.HtmlList(null);
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_BILL_EXD bill = new SYS_BILL_EXD(int.Parse(Request["BillID"]));
SYS_BILL_BLL billExd = new SYS_BILL_BLL(int.Parse(Request["BillID"]));
litView.Text = billExd.HtmlEditForm();
hidAppPath.Value = WebHelper.GetAppPath();
List<SYS_BILL_COL> cols = bill.GetColList();
Dictionary<string, int> tbkeynum = new Dictionary<string, int>();
if (cols != null)
{
for (int i = 0; i < cols.Count; i++)
{
if (!tbkeynum.ContainsKey(cols[i].TABLE_NAME))
{
tbkeynum.Add(cols[i].TABLE_NAME, 0);
}
if (cols[i].ISPK == "1")
{
tbkeynum[cols[i].TABLE_NAME] += 1;
}
}
}
//foreach (KeyValuePair<string, int> key in tbkeynum) {
// //Response.Write(key.Key);
// if (key.Value == 0)
// {
// if (key.Key != bill.Base.TABLE_NAME)
// {
// litWarn.Text += "主表单里未配置外部关联表" + key.Key + "的主键，无法与外部表信息同步。";
// }
// else {
// litWarn.Text += key.Key + "未配置主键。";
// }
// }
// else if (key.Value > 1)
// {
// if (key.Key != bill.Base.TABLE_NAME)
// {
// litWarn.Text += "主表单里配置了多个外部关联表"+key.Key + "的主键，可能导致信息同步异常。";
// }
// }
//}
litList.Text = billExd.HtmlList(null);
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
SYS_BILL valObj = new SYS_BILL();
if (txtBILL_ID.Value != "")
{
valObj.BILL_ID = Convert.ToInt32(txtBILL_ID.Value);
}
if (txtBILL_NAME.Value != "")
{
valObj.BILL_NAME = txtBILL_NAME.Value;
}
if (txtBILL_TYPE.Value != "")
{
valObj.BILL_TYPE = Convert.ToString(txtBILL_TYPE.Value);
}
if (txtBILL_SQL.Value != "")
{
valObj.BILL_SQL = Convert.ToString(txtBILL_SQL.Value);
}
valObj.EDITIME = DateTime.Now;
if (txtADDER.Value != "")
{
valObj.ADDER = Convert.ToString(txtADDER.Value);
}
if (txtTABLE_NAME.Value != "")
{
valObj.TABLE_NAME = txtTABLE_NAME_PRE.Value.Trim() + txtTABLE_NAME.Value.Trim();
}
if (!DataBase.Factory(conn).DataTables.Contains(ViewState["TABLE_NAME"].ToString()))
{
litWarn.Text = "表" + ViewState["TABLE_NAME"] + "不存在，请刷新列表！";
btnOK.Enabled = false;
btnSave.Enabled = false;
_btnOK.Enabled = false;
_btnSave.Enabled = false;
return;
return;
}
valObj.CONN_SOURCE = Request["selDEVTB"];
valObj.P_BILL_ID = Convert.ToInt32(pid);
valObj.IS_TABLE_EXISTS = txtTAVLE_EXISTS.Checked == true ? "1" : "0";
if (valObj.IS_TABLE_EXISTS == "0")
{
if (DataBase.Factory(conn).DataTables.Contains(valObj.TABLE_NAME))
{
valObj.IS_TABLE_EXISTS = "1";
}
}
try
{
if (keyid != "")
{
//valObj.BILL_ID = Convert.ToInt32(keyid);
valObj.EDITIME = DateTime.Now;
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
count = billExd.DB_UpdateName(ViewState["TABLE_NAME"].ToString());
}
else
{
valObj.STATUS = "0";
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
string msg = "";
count = billExd.DB_CreateTable(ckDTL.Checked == true, ref msg) == true ? 1 : 0;
keyid = count.ToString();
}
}
catch (Exception ee)
{
Response.Write("操作失败，请重新选择节点！");
Response.End();
}
string txt = valObj.TABLE_NAME.ToLower().IndexOf("u_") == 0 ? "[系统表]" : "[客户表]";
if (count > 0)
{
ViewState["TABLE_NAME"] = valObj.TABLE_NAME;
litWarn.Text = "保存" + txt + "成功！";
if (Request["tree"] != null)
{
string dev = ".";
if (Request["tbs"] != null)
{
dev = InMTable(Request["tbs"], valObj.TABLE_NAME);
if (dev == ".")
{
return;
}
}
StringBuilder sb = new StringBuilder("{");
string[] arr = dev.Split('.');
sb.Append("id:'").Append(valObj.TABLE_NAME);
sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
sb.Append(",sc:").Append("1,dev:'" + arr[0] + "',tb:'" + arr[1] + "'");
sb.Append(",name:'").Append(valObj.TABLE_NAME).Append("',note:'[" + valObj._ZhName + "]'").Append(",ntype:'" + (valObj.P_BILL_ID > 0 ? "bill-mx" : "bill") + "'}");
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");", false);
}
}
else
{
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
{
txtBILL_NAME.Value = "";
txtBILL_TYPE.Value = "";
txtADDER.Value = "";
txtTABLE_NAME.Value = "";
}
}
}
else
{
litWarn.Text = "保存" + txt + "失败！";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
#region////��ʾ�ӽڵ�
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
if (nodetype == "bill-root")
{
#region
SYS_BILL obj = new SYS_BILL();
SYS_BILL val = new SYS_BILL();
obj.P_BILL_ID = 0;
//obj.STATUS = "1";
bool fromtb = Request["TB"] != null;
if (Request["TB"] == null)
{
obj.Where("STATUS<>'0'");
}
val.af_PageBy(SYS_BILL.Attribute.BILL_ID, Order.Asc);
List<SYS_BILL> lst = BLLTable<SYS_BILL>.Factory(conn).Select(val, 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].BILL_ID);
sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].BILL_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].BILL_NAME + (lst[i].STATUS=="11"?"(��ɾ)":"")).Append("',note:''").Append(",ntype:'bill'}");
}
}
#endregion
}
if (nodetype == "bill" || nodetype == "bill-mx")
{
if (nodetype == "bill")
{
#region ������ϸ���
SYS_BILL objTB = new SYS_BILL();
SYS_BILL valTB = new SYS_BILL();
objTB.P_BILL_ID = int.Parse(id);
valTB.OrderBy(SYS_BILL.Attribute.BILL_ID, Order.Asc);
List<SYS_BILL> lstTB = BLLTable<SYS_BILL>.Factory(conn).Select(valTB, objTB);
if (lstTB.Count != null)
{
for (int i = 0; i < lstTB.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstTB[i].BILL_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].BILL_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstTB[i].BILL_NAME).Append("',note:''").Append(",ntype:'bill-mx'}");
}
}
#endregion
}
#region ������
SYS_BILL_COL obj = new SYS_BILL_COL();
SYS_BILL_COL val = new SYS_BILL_COL();
obj.BILL_ID = int.Parse(id);
//obj.Where("COL_NAME not in('MX_ID','BILL_ID')");
val.af_PageBy(SYS_BILL_COL.Attribute.SORT_NO, Order.Asc);
List<SYS_BILL_COL> lst = BLLTable<SYS_BILL_COL>.Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COL_ID.ToString());
sb.Append("',pid:'").Append(lst[i].BILL_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].COL_NAME).Append("',note:'[" + lst[i].COL_NOTE + "]'").Append(",ntype:'col'}");
}
}
#endregion
}//ѡ���˱����
if (nodetype == "col")
{
SYS_BILL_COL_SYN obj = new SYS_BILL_COL_SYN();
SYS_BILL_COL_SYN val = new SYS_BILL_COL_SYN();
obj.COL_ID = int.Parse(id);
//obj.Where("COL_NAME not in('MX_ID','BILL_ID')");
//val.af_PageBy(SYS_BILL_COL_SYN.Attribute.SORT_NO, Order.Asc);
List<SYS_BILL_COL_SYN> lst = BLLTable<SYS_BILL_COL_SYN>.Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COL_SYNID.ToString());
sb.Append("',pid:'").Append(lst[i].COL_ID.ToString()).Append("',no:").Append("0");
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append("[" + lst[i].DB_SRC + "].[" + lst[i].TABLE_NAME + "].[" + lst[i].COL_NAME + "]").Append("',note:'[" + lst[i].COL_NOTE + "]'").Append(",ntype:'syncol'}");
}
}
}
//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.Delete(out msg);
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "col")
{
#region//ɾ�����ֶ�
string msg = "ɾ�����ݿ���ֶγɹ���";
SYS_BILL_EXD bllexd = new SYS_BILL_EXD(int.Parse(Request["pid"]));
int re = bllexd.DeleteCol(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
#region//�����ֶ�
if (Request["intbCols"] != null)
{
string pid = Request["pid"];
string id = Request["id"];
string billid = Request["billid"];
DataBaseTable tbllext = DataBase.Factory(conn).DataTables[pid];// new DataBaseTable(_Base.TABLE_NAME, "", dbROG);
DataBaseFieldCollection fields = tbllext.DataFields;
string keys = "";
DataBaseField fs = fields[id];
if (fs.IsKeyID == true)
{
keys += keys == "" ? fs.FieldName : "," + fs.FieldName;
}
SYS_BILL_COL col = AgileFrame.AppInOne.SYS.SysDataBaseHelper.FieldToCol(fs, int.Parse(billid));
SYS_BILL_COL ccc = new SYS_BILL_COL();
ccc.BILL_ID = int.Parse(billid);
ccc.COL_NAME = fs.FieldName.ToUpper();
int re = 1;
SYS_BILL_COL oldCol = BLLTable<SYS_BILL_COL>.Factory(conn).GetRowData(new SYS_BILL_COL(), ccc);
int colid = 0;
if (oldCol == null)
{
re = BLLTable<SYS_BILL_COL>.Factory(conn).Insert(col, SYS_BILL_COL.Attribute.COL_ID);
colid = col.COL_ID;
}
else {
colid = oldCol.COL_ID;
}
if (re > 0)
{
SYS_BILL_COL_SYN valObj = new SYS_BILL_COL_SYN();
valObj.BILL_ID = Convert.ToInt32(Request["billid"]);
valObj.COL_NAME = fs.FieldName.ToUpper();
valObj.TABLE_NAME = Request["tb"];
valObj.COL_ID = colid;
valObj.ISPK = fs.IsKeyID == true ? "1" : "0";
valObj.COL_NOTE = fs.Desc.ZhName;
valObj.DATA_TYPE = fs.DataType.TypeNameString;
valObj.DATA_LEN = fs.DataType.DataLen;
valObj.DATA_ACC = fs.DataType.Scale;
valObj.IS_AUTO = fs.IsAutoIncrease == true ? "1" : "0";
valObj.DVAL = fs.DefaultValue;
valObj.DB_SRC = Request["dev"];
valObj.PK_VALCODE = "";
BLLTable<SYS_BILL_COL_SYN>.InsertReturnID(valObj);
}
//��¼���������
if (keys != "")
{
BLLTable<SYS_BILL>.Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, billid, SYS_BILL.Attribute.KEYS, keys);
}
Response.Write("ok");
}
#endregion
#region
if (Request["addSynCols"] != null)
{
string[]aaa=StringHelper.GetStringArray(Request["ids"],',');
for (int i = 0; i < aaa.Length; i++) {
string[] bbb = aaa[i].Split('.');
if (bbb[2] != "col") {
continue;
}
DataBaseTable tbllext = DataBase.Factory(conn).DataTables[bbb[0]];
DataBaseField fs = tbllext.DataFields[bbb[1]];
SYS_BILL_COL_SYN valObj = new SYS_BILL_COL_SYN();
valObj.BILL_ID = Convert.ToInt32(Request["billid"]);
valObj.COL_ID = Convert.ToInt32(Request["colid"]);
valObj.COL_NAME = fs.FieldName;
if (!BLLTable<SYS_BILL_COL_SYN>.Exists(valObj))
{
valObj.TABLE_NAME = tbllext.TableName;
valObj.ISPK = fs.IsKeyID == true ? "1" : "0";
valObj.COL_NOTE = fs.Desc.ZhName;
valObj.DATA_TYPE = fs.DataType.TypeNameString.Replace("_","") ;
valObj.DATA_LEN = fs.DataType.DataLen;
valObj.DATA_ACC = fs.DataType.Scale;
valObj.IS_AUTO = fs.IsAutoIncrease == true ? "1" : "0";
valObj.DVAL = fs.DefaultValue;
valObj.DB_SRC = bbb[0];
valObj.PK_VALCODE = "";
BLLTable<SYS_BILL_COL_SYN>.InsertReturnID(valObj);
}
}
Response.Write("ok");
}
#endregion
#region//����ɾ�����
if (Request["clearBill"] != null)
{
#region//ɾ����
string str = "";
string delID = Request["id"];
SYS_BILL_EXD eee = new SYS_BILL_EXD(int.Parse(delID));
string msg="";
int re = eee.Delete(out 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();
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
SYS_BILL valObj = new SYS_BILL();
if (txtBILL_ID.Value != "")
valObj.BILL_ID = Convert.ToInt32(txtBILL_ID.Value);
if (txtBILL_NAME.Value != "")
valObj.BILL_NAME = txtBILL_NAME.Value;
//if(txtBILL_TYPE.Value !="" )
// valObj.BILL_TYPE = Convert.ToString(txtBILL_TYPE.Value);
if (txtBILL_SQL.Value != "")
valObj.BILL_SQL = Convert.ToString(txtBILL_SQL.Value);
valObj.EDITIME = DateTime.Now;
if (txtADDER.Value != "")
valObj.ADDER = Convert.ToString(txtADDER.Value);
if (txtTABLE_NAME.Value != "")
valObj.TABLE_NAME = txtTABLE_NAME.Value;
valObj.CONN_SOURCE = Request["selDEVTB"];
if (!string.IsNullOrEmpty(valObj.CONN_SOURCE) && valObj.CONN_SOURCE.Length > 0)
{
if (valObj.CONN_SOURCE.Substring(0, 1) == ",")
{
valObj.CONN_SOURCE.Substring(1);
}
}
valObj.P_BILL_ID = Convert.ToInt32(pid);
valObj.IS_TABLE_EXISTS = "1";
if (keyid != "")
{
valObj.EDITIME = DateTime.Now;
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
count = BLLTable<SYS_BILL>.Factory(conn).Update(valObj, SYS_BILL.Attribute.BILL_ID);// billExd.AD_Update(ViewState["TABLE_NAME"].ToString());
}
else
{
valObj.STATUS = "1";
//SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
//count = billExd.AD_Add();
count = BLLTable<SYS_BILL>.Factory(conn).Insert(valObj, SYS_BILL.Attribute.BILL_ID);
keyid = valObj.BILL_ID.ToString();// count.ToString();
if (count > 0)
{
//DataBaseTable tbllext = DataBase.Factory(conn).DataTables[valObj.TABLE_NAME];// new DataBaseTable(_Base.TABLE_NAME, "", dbROG);
//DataBaseFieldCollection fields = tbllext.DataFields;
//if (fields != null)
//{
// string keys = "";
// for (int i = 0; i < fields.Count; i++)
// {
// DataBaseField f = fields[i];
// if (f.IsKey == true)
// {
// keys += keys == "" ? f.FieldName : "," + f.FieldName;
// }
// SYS_BILL_COL col = DataBaseHelper.FieldToCol(f, valObj.BILL_ID);
// BLLTable<SYS_BILL_COL>.Factory(conn).Insert(col, SYS_BILL_COL.Attribute.COL_ID);
// }
// //��¼���������
// BLLTable<SYS_BILL>.Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, valObj.BILL_ID, SYS_BILL.Attribute.KEYS, keys);
//}
}
}
int saveSuccessCount = 0;
if (count > 0)
{
#region//����豸��ҵ����
//�½�����������Ѿ����� ������
//�༭ʱ�ȼ�¼��ԭ�����õľ�����ֵ䣬����ֵ����еĵ������������û������ɾ���ֵ�����Ǹ�������
Dictionary<string, string> dicDelOldDEVS = new Dictionary<string, string>();
if (ViewState["CONN_SOURCE"] != null)
{
string[] arr = StringHelper.GetStringArray(ViewState["CONN_SOURCE"].ToString(), ',');
if (arr != null)
{
for (int i = 0; i < arr.Length; i++)
{
string[] aaa = arr[i].Split('.');
if (aaa.Length > 2)
{
dicDelOldDEVS.Add(arr[i], aaa[2]);
}
}
}
}
if (!string.IsNullOrEmpty(valObj.CONN_SOURCE))
{
string[] arr = StringHelper.GetStringArray(valObj.CONN_SOURCE, ',');
string newSrc = "";
if (arr != null)
{
//DataBase.Factory(conn).Load(true);
for (int i = 0; i < arr.Length; i++)
{
string[] aaa = arr[i].Split('.');
newSrc += "," + arr[i];
if (aaa[0] == "AIO")
{
continue;
}
if (aaa.Length > 2)
{
//ԭ���Ѿ�����������Ϣ
if (dicDelOldDEVS.ContainsKey(arr[i]))
{
dicDelOldDEVS.Remove(arr[i]);
}
continue;
}
string tbname = "ERP_"+aaa[0]+"_" + aaa[1];
DataBaseTable addTB = GetAddTable(aaa[0], aaa[1], ref tbname);
if (addTB != null)
{
string msg = "";
if (DataBase.Factory(conn).AddTable(addTB, ref msg))
{
newSrc += "." + tbname;
saveSuccessCount++;
}
}
else
newSrc += "." + tbname;
}
}
if (newSrc != "") {
newSrc = newSrc.Substring(1);
}
BLLTable<SYS_BILL>.Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, keyid, SYS_BILL.Attribute.CONN_SOURCE, newSrc);
}
int delSuccessCount = 0;
if (dicDelOldDEVS.Count > 0)
{
string msg = "";
foreach (KeyValuePair<string, string> ppp in dicDelOldDEVS)
{
delSuccessCount += DataBase.Factory(conn).DeleteTable(ppp.Value, true, ref msg) ? 1 : 0;
}
}
#endregion
litWarn.Text = "���������ɹ���:" + saveSuccessCount + (dicDelOldDEVS.Count > 0 ? (",ɾ�������ɹ���" + delSuccessCount) : "");
if (Request["tree"] != null)
{
//Response.Write(keyid);
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.BILL_ID).Append(",sc:1,name:'");
if (valObj.P_BILL_ID > 0)
{
sb.Append(valObj.BILL_NAME).Append("',ntype:'bill-mx'}");
}
else
{
sb.Append(valObj.BILL_NAME).Append("',ntype:'bill'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");", false);
}
}
else
{
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
{
txtBILL_NAME.Value = "";
//txtBILL_TYPE.Value = "";
txtADDER.Value = "";
txtTABLE_NAME.Value = "";
}
}
}
else
{
litWarn.Text = "����ʧ�ܣ�";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
protected void Page_Load(object sender, EventArgs e)
{
#region////显示子节点
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
if (nodetype == "bill-root")
{
#region
SYS_BILL obj = new SYS_BILL();
SYS_BILL val = new SYS_BILL();
obj.P_BILL_ID = 0;
//obj.STATUS = "1";
bool fromtb = Request["TB"] != null;
if (Request["TB"] == null)
{
obj.Where("STATUS<>'0'");
}
val.af_PageBy(SYS_BILL.Attribute.BILL_ID, Order.Asc);
List <SYS_BILL> lst = BLLTable <SYS_BILL> .Factory(conn).Select(val, 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].BILL_ID);
sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].BILL_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].BILL_NAME + (lst[i].STATUS == "11"?"(已删)":"")).Append("',note:''").Append(",ntype:'bill'}");
}
}
#endregion
}
if (nodetype == "bill" || nodetype == "bill-mx")
{
if (nodetype == "bill")
{
#region 载入明细表单
SYS_BILL objTB = new SYS_BILL();
SYS_BILL valTB = new SYS_BILL();
objTB.P_BILL_ID = int.Parse(id);
valTB.OrderBy(SYS_BILL.Attribute.BILL_ID, Order.Asc);
List <SYS_BILL> lstTB = BLLTable <SYS_BILL> .Factory(conn).Select(valTB, objTB);
if (lstTB.Count != null)
{
for (int i = 0; i < lstTB.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstTB[i].BILL_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].BILL_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstTB[i].BILL_NAME).Append("',note:''").Append(",ntype:'bill-mx'}");
}
}
#endregion
}
#region 载入列
SYS_BILL_COL obj = new SYS_BILL_COL();
SYS_BILL_COL val = new SYS_BILL_COL();
obj.BILL_ID = int.Parse(id);
//obj.Where("COL_NAME not in('MX_ID','BILL_ID')");
val.af_PageBy(SYS_BILL_COL.Attribute.SORT_NO, Order.Asc);
List <SYS_BILL_COL> lst = BLLTable <SYS_BILL_COL> .Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COL_ID.ToString());
sb.Append("',pid:'").Append(lst[i].BILL_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].COL_NAME).Append("',note:'[" + lst[i].COL_NOTE + "]'").Append(",ntype:'col'}");
}
}
#endregion
}//选中了表单列
if (nodetype == "col")
{
SYS_BILL_COL_SYN obj = new SYS_BILL_COL_SYN();
SYS_BILL_COL_SYN val = new SYS_BILL_COL_SYN();
obj.COL_ID = int.Parse(id);
//obj.Where("COL_NAME not in('MX_ID','BILL_ID')");
//val.af_PageBy(SYS_BILL_COL_SYN.Attribute.SORT_NO, Order.Asc);
List <SYS_BILL_COL_SYN> lst = BLLTable <SYS_BILL_COL_SYN> .Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COL_SYNID.ToString());
sb.Append("',pid:'").Append(lst[i].COL_ID.ToString()).Append("',no:").Append("0");
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append("[" + lst[i].DB_SRC + "].[" + lst[i].TABLE_NAME + "].[" + lst[i].COL_NAME + "]").Append("',note:'[" + lst[i].COL_NOTE + "]'").Append(",ntype:'syncol'}");
}
}
}
//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.Delete(out msg);
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "col")
{
#region//删除表字段
string msg = "删除数据库表字段成功！";
SYS_BILL_EXD bllexd = new SYS_BILL_EXD(int.Parse(Request["pid"]));
int re = bllexd.DeleteCol(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
#region//导入字段
if (Request["intbCols"] != null)
{
string pid = Request["pid"];
string id = Request["id"];
string billid = Request["billid"];
DataBaseTable tbllext = DataBase.Factory(conn).DataTables[pid];// new DataBaseTable(_Base.TABLE_NAME, "", dbROG);
DataBaseFieldCollection fields = tbllext.DataFields;
string keys = "";
DataBaseField fs = fields[id];
if (fs.IsKeyID == true)
{
keys += keys == "" ? fs.FieldName : "," + fs.FieldName;
}
SYS_BILL_COL col = AgileFrame.AppInOne.SYS.SysDataBaseHelper.FieldToCol(fs, int.Parse(billid));
SYS_BILL_COL ccc = new SYS_BILL_COL();
ccc.BILL_ID = int.Parse(billid);
ccc.COL_NAME = fs.FieldName.ToUpper();
int re = 1;
SYS_BILL_COL oldCol = BLLTable <SYS_BILL_COL> .Factory(conn).GetRowData(new SYS_BILL_COL(), ccc);
int colid = 0;
if (oldCol == null)
{
re = BLLTable <SYS_BILL_COL> .Factory(conn).Insert(col, SYS_BILL_COL.Attribute.COL_ID);
colid = col.COL_ID;
}
else
{
colid = oldCol.COL_ID;
}
if (re > 0)
{
SYS_BILL_COL_SYN valObj = new SYS_BILL_COL_SYN();
valObj.BILL_ID = Convert.ToInt32(Request["billid"]);
valObj.COL_NAME = fs.FieldName.ToUpper();
valObj.TABLE_NAME = Request["tb"];
valObj.COL_ID = colid;
valObj.ISPK = fs.IsKeyID == true ? "1" : "0";
valObj.COL_NOTE = fs.Desc.ZhName;
valObj.DATA_TYPE = fs.DataType.TypeNameString;
valObj.DATA_LEN = fs.DataType.DataLen;
valObj.DATA_ACC = fs.DataType.Scale;
valObj.IS_AUTO = fs.IsAutoIncrease == true ? "1" : "0";
valObj.DVAL = fs.DefaultValue;
valObj.DB_SRC = Request["dev"];
valObj.PK_VALCODE = "";
BLLTable <SYS_BILL_COL_SYN> .InsertReturnID(valObj);
}
//记录主键到表单
if (keys != "")
{
BLLTable <SYS_BILL> .Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, billid, SYS_BILL.Attribute.KEYS, keys);
}
Response.Write("ok");
}
#endregion
#region
if (Request["addSynCols"] != null)
{
string[] aaa = StringHelper.GetStringArray(Request["ids"], ',');
for (int i = 0; i < aaa.Length; i++)
{
string[] bbb = aaa[i].Split('.');
if (bbb[2] != "col")
{
continue;
}
DataBaseTable tbllext = DataBase.Factory(conn).DataTables[bbb[0]];
DataBaseField fs = tbllext.DataFields[bbb[1]];
SYS_BILL_COL_SYN valObj = new SYS_BILL_COL_SYN();
valObj.BILL_ID = Convert.ToInt32(Request["billid"]);
valObj.COL_ID = Convert.ToInt32(Request["colid"]);
valObj.COL_NAME = fs.FieldName;
if (!BLLTable <SYS_BILL_COL_SYN> .Exists(valObj))
{
valObj.TABLE_NAME = tbllext.TableName;
valObj.ISPK = fs.IsKeyID == true ? "1" : "0";
valObj.COL_NOTE = fs.Desc.ZhName;
valObj.DATA_TYPE = fs.DataType.TypeNameString.Replace("_", "");
valObj.DATA_LEN = fs.DataType.DataLen;
valObj.DATA_ACC = fs.DataType.Scale;
valObj.IS_AUTO = fs.IsAutoIncrease == true ? "1" : "0";
valObj.DVAL = fs.DefaultValue;
valObj.DB_SRC = bbb[0];
valObj.PK_VALCODE = "";
BLLTable <SYS_BILL_COL_SYN> .InsertReturnID(valObj);
}
}
Response.Write("ok");
}
#endregion
#region//彻底删除表单
if (Request["clearBill"] != null)
{
#region//删除表
string str = "";
string delID = Request["id"];
SYS_BILL_EXD eee = new SYS_BILL_EXD(int.Parse(delID));
string msg = "";
int re = eee.Delete(out 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();
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
SYS_BILL valObj = new SYS_BILL();
if (txtBILL_ID.Value != "")
valObj.BILL_ID = Convert.ToInt32(txtBILL_ID.Value);
if (txtBILL_NAME.Value != "")
valObj.BILL_NAME = txtBILL_NAME.Value;
if (txtBILL_TYPE.Value != "")
valObj.BILL_TYPE = Convert.ToString(txtBILL_TYPE.Value);
if (txtBILL_SQL.Value != "")
valObj.BILL_SQL = Convert.ToString(txtBILL_SQL.Value);
valObj.EDITIME = DateTime.Now;
if (txtADDER.Value != "")
valObj.ADDER = Convert.ToString(txtADDER.Value);
if (txtTABLE_NAME.Value != "")
valObj.TABLE_NAME = txtTABLE_NAME_PRE.Value.Trim() + txtTABLE_NAME.Value.Trim();
if (!DataBase.Factory(conn).DataTables.Contains(ViewState["TABLE_NAME"].ToString()))
{
litWarn.Text = "��" + ViewState["TABLE_NAME"] + "�����ڣ���ˢ���б��";
btnOK.Enabled = false;
btnSave.Enabled = false;
_btnOK.Enabled = false;
_btnSave.Enabled = false;
return;
return;
}
valObj.CONN_SOURCE = Request["selDEVTB"];
valObj.P_BILL_ID = Convert.ToInt32(pid);
valObj.IS_TABLE_EXISTS = txtTAVLE_EXISTS.Checked == true ? "1" : "0";
if (valObj.IS_TABLE_EXISTS == "0")
{
if (DataBase.Factory(conn).DataTables.Contains(valObj.TABLE_NAME))
{
valObj.IS_TABLE_EXISTS = "1";
}
}
try
{
if (keyid != "")
{
//valObj.BILL_ID = Convert.ToInt32(keyid);
valObj.EDITIME = DateTime.Now;
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
count = billExd.DB_UpdateName(ViewState["TABLE_NAME"].ToString());
}
else
{
valObj.STATUS = "0";
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
string msg = "";
count = billExd.DB_CreateTable(ckDTL.Checked == true, ref msg) == true ? 1 : 0;
keyid = count.ToString();
}
}
catch (Exception ee)
{
Response.Write("����ʧ�ܣ�������ѡ��ڵ㣡");
Response.End();
}
string txt = valObj.TABLE_NAME.ToLower().IndexOf("u_") == 0 ? "[ϵͳ��]" : "[�ͻ���]";
if (count > 0)
{
ViewState["TABLE_NAME"] = valObj.TABLE_NAME;
litWarn.Text = "����" + txt + "�ɹ���";
if (Request["tree"] != null)
{
string dev = ".";
if (Request["tbs"] != null)
{
dev = InMTable(Request["tbs"], valObj.TABLE_NAME);
if (dev == ".")
{
return;
}
}
StringBuilder sb = new StringBuilder("{");
string[] arr = dev.Split('.');
sb.Append("id:'").Append(valObj.TABLE_NAME);
sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
sb.Append(",sc:").Append("1,dev:'" + arr[0] + "',tb:'" + arr[1] + "'");
sb.Append(",name:'").Append(valObj.TABLE_NAME).Append("',note:'[" + valObj._ZhName + "]'").Append(",ntype:'" + (valObj.P_BILL_ID > 0 ? "bill-mx" : "bill") + "'}");
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");", false);
}
}
else
{
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
{
txtBILL_NAME.Value = "";
txtBILL_TYPE.Value = "";
txtADDER.Value = "";
txtTABLE_NAME.Value = "";
}
}
}
else
{
litWarn.Text = "����" + txt + "ʧ�ܣ�";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
SYS_BILL valObj = new SYS_BILL();
if (txtBILL_ID.Value != "")
{
valObj.BILL_ID = Convert.ToInt32(txtBILL_ID.Value);
}
if (txtBILL_NAME.Value != "")
{
valObj.BILL_NAME = txtBILL_NAME.Value;
}
//if(txtBILL_TYPE.Value !="" )
// valObj.BILL_TYPE = Convert.ToString(txtBILL_TYPE.Value);
if (txtBILL_SQL.Value != "")
{
valObj.BILL_SQL = Convert.ToString(txtBILL_SQL.Value);
}
valObj.EDITIME = DateTime.Now;
if (txtADDER.Value != "")
{
valObj.ADDER = Convert.ToString(txtADDER.Value);
}
if (txtTABLE_NAME.Value != "")
{
valObj.TABLE_NAME = txtTABLE_NAME.Value;
}
valObj.CONN_SOURCE = Request["selDEVTB"];
if (!string.IsNullOrEmpty(valObj.CONN_SOURCE) && valObj.CONN_SOURCE.Length > 0)
{
if (valObj.CONN_SOURCE.Substring(0, 1) == ",")
{
valObj.CONN_SOURCE.Substring(1);
}
}
valObj.P_BILL_ID = Convert.ToInt32(pid);
valObj.IS_TABLE_EXISTS = "1";
if (keyid != "")
{
valObj.EDITIME = DateTime.Now;
SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
count = BLLTable <SYS_BILL> .Factory(conn).Update(valObj, SYS_BILL.Attribute.BILL_ID);// billExd.AD_Update(ViewState["TABLE_NAME"].ToString());
}
else
{
valObj.STATUS = "1";
//SYS_BILL_EXD billExd = new SYS_BILL_EXD(valObj);
//count = billExd.AD_Add();
count = BLLTable <SYS_BILL> .Factory(conn).Insert(valObj, SYS_BILL.Attribute.BILL_ID);
keyid = valObj.BILL_ID.ToString();// count.ToString();
if (count > 0)
{
//DataBaseTable tbllext = DataBase.Factory(conn).DataTables[valObj.TABLE_NAME];// new DataBaseTable(_Base.TABLE_NAME, "", dbROG);
//DataBaseFieldCollection fields = tbllext.DataFields;
//if (fields != null)
//{
// string keys = "";
// for (int i = 0; i < fields.Count; i++)
// {
// DataBaseField f = fields[i];
// if (f.IsKey == true)
// {
// keys += keys == "" ? f.FieldName : "," + f.FieldName;
// }
// SYS_BILL_COL col = DataBaseHelper.FieldToCol(f, valObj.BILL_ID);
// BLLTable<SYS_BILL_COL>.Factory(conn).Insert(col, SYS_BILL_COL.Attribute.COL_ID);
// }
// //记录主键到表单
// BLLTable<SYS_BILL>.Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, valObj.BILL_ID, SYS_BILL.Attribute.KEYS, keys);
//}
}
}
int saveSuccessCount = 0;
if (count > 0)
{
#region//相关设备表业务处理
//新建镜像表，如果已经存在 则不建立。
//编辑时先记录下原来配置的镜像表字典，如果字典里有的但是新配置里的没有吗，则删除字典里的那个镜像表。
Dictionary <string, string> dicDelOldDEVS = new Dictionary <string, string>();
if (ViewState["CONN_SOURCE"] != null)
{
string[] arr = StringHelper.GetStringArray(ViewState["CONN_SOURCE"].ToString(), ',');
if (arr != null)
{
for (int i = 0; i < arr.Length; i++)
{
string[] aaa = arr[i].Split('.');
if (aaa.Length > 2)
{
dicDelOldDEVS.Add(arr[i], aaa[2]);
}
}
}
}
if (!string.IsNullOrEmpty(valObj.CONN_SOURCE))
{
string[] arr = StringHelper.GetStringArray(valObj.CONN_SOURCE, ',');
string newSrc = "";
if (arr != null)
{
//DataBase.Factory(conn).Load(true);
for (int i = 0; i < arr.Length; i++)
{
string[] aaa = arr[i].Split('.');
newSrc += "," + arr[i];
if (aaa[0] == "AIO")
{
continue;
}
if (aaa.Length > 2)
{
//原来已经存的物理表信息
if (dicDelOldDEVS.ContainsKey(arr[i]))
{
dicDelOldDEVS.Remove(arr[i]);
}
continue;
}
string tbname = "ERP_" + aaa[0] + "_" + aaa[1];
DataBaseTable addTB = GetAddTable(aaa[0], aaa[1], ref tbname);
if (addTB != null)
{
string msg = "";
if (DataBase.Factory(conn).AddTable(addTB, ref msg))
{
newSrc += "." + tbname;
saveSuccessCount++;
}
}
else
{
newSrc += "." + tbname;
}
}
}
if (newSrc != "")
{
newSrc = newSrc.Substring(1);
}
BLLTable <SYS_BILL> .Factory(conn).Update(SYS_BILL.Attribute.BILL_ID, keyid, SYS_BILL.Attribute.CONN_SOURCE, newSrc);
}
int delSuccessCount = 0;
if (dicDelOldDEVS.Count > 0)
{
string msg = "";
foreach (KeyValuePair <string, string> ppp in dicDelOldDEVS)
{
delSuccessCount += DataBase.Factory(conn).DeleteTable(ppp.Value, true, ref msg) ? 1 : 0;
}
}
#endregion
litWarn.Text = "保存物理表成功数:" + saveSuccessCount + (dicDelOldDEVS.Count > 0 ? (",删除物理表成功数" + delSuccessCount) : "");
if (Request["tree"] != null)
{
//Response.Write(keyid);
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.BILL_ID).Append(",sc:1,name:'");
if (valObj.P_BILL_ID > 0)
{
sb.Append(valObj.BILL_NAME).Append("',ntype:'bill-mx'}");
}
else
{
sb.Append(valObj.BILL_NAME).Append("',ntype:'bill'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");", false);
}
}
else
{
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
{
txtBILL_NAME.Value = "";
//txtBILL_TYPE.Value = "";
txtADDER.Value = "";
txtTABLE_NAME.Value = "";
}
}
}
else
{
litWarn.Text = "保存失败！";
}
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
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();
}
