private void btDown0_Click(object sender, EventArgs e)
{
if (listViewDetail.SelectedItems.Count == 0)
{
MessageBox.Show("请选择一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (listViewDetail.SelectedItems[0].Index == listViewDetail.Items.Count - 1)
{
return;
}
int idx = listViewDetail.SelectedItems[0].Index;
ListViewItem row = listViewDetail.SelectedItems[0];
ListViewItem row2 = listViewDetail.Items[idx + 1];
listViewDetail.Items.Remove(row2);
listViewDetail.Items.Insert(idx, row2);
CViewDetail vd = (CViewDetail)row.Tag;
vd.Idx++;
CViewDetail vd2 = (CViewDetail)row2.Tag;
vd2.Idx--;
LoadDetailTable();
}
bool ValidatePage2()
{
bool bHas = false;
for (int i = 0; i < listMasterColumn.Items.Count; i++)
{
if (listMasterColumn.Items[i].Selected)
{
bHas = true;
break;
}
}
if (!bHas)
{
RegisterStartupScript("starup", "<script>alert('请选择主表字段！');</script>");
return(false);
}
List <CBaseObject> lstObj = m_View.ViewDetailMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CViewDetail vd = (CViewDetail)obj;
if (vd.ColumnInViewDetailMgr.GetList().Count == 0)
{
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(vd.FW_Table_id);
string strMsg = string.Format("请选择从表 {0} 字段！", table.Name);
RegisterStartupScript("starup", string.Format("<script>alert('{0}');</script>", strMsg));
return(false);
}
}
return(true);
}
void LoadDetailColumn()
{
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
if (ViewDetail == null)
{
return;
}
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(ViewDetail.FW_Table_id);
txtDetailTable.Text = table.Name;
listDetailColumn.Items.Clear();
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn column = (CColumn)obj;
ListItem it = new ListItem(column.Name, column.Id.ToString());
listDetailColumn.Items.Add(it);
if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null)
{
it.Selected = true;
}
}
}
void LoadDetailColumn()
{
if (cbDetailTable2.SelectedIndex == -1)
{
return;
}
m_bIsLoadingData = true;//避免触发Item_Checked事件
DataItem item = (DataItem)cbDetailTable2.SelectedItem;
CTable table = (CTable)item.Data;
CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id);
listDetailColumn.Items.Clear();
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn column = (CColumn)obj;
ListViewItem it = new ListViewItem();
it.Text = column.Name;
it.Tag = column;
listDetailColumn.Items.Add(it);
if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null)
{
it.Checked = true;
}
}
m_bIsLoadingData = false;
}
void PostDetailData()
{
string GridData2 = Request["GridData2"];
if (string.IsNullOrEmpty(GridData2))
{
Response.Write("从表字段不能空！");
return;
}
string table_id = Request["table_id"];
if (string.IsNullOrEmpty(table_id))
{
Response.Write("从表不能空！");
return;
}
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.FindByTable(new Guid(table_id));
string[] arr1 = GridData2.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < arr1.Length; i++)
{
string[] arr2 = arr1[i].Split(":".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
CColumnInViewDetail civd = (CColumnInViewDetail)ViewDetail.ColumnInViewDetailMgr.Find(new Guid(arr2[0]));
civd.Caption = arr2[1];
civd.Idx = i;
ViewDetail.ColumnInViewDetailMgr.Update(civd);
}
}
void LoadDetailColumn()
{
if (cbDetailTable.SelectedIndex == -1)
{
return;
}
DataItem item = (DataItem)cbDetailTable.SelectedItem;
CTable tb = (CTable)item.Data;
txtDetailTable.Text = tb.Name;
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
listDetailColumn.Items.Clear();
List <CBaseObject> lstObj = tb.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn column = (CColumn)obj;
ListViewItem it = new ListViewItem();
it.Text = column.Name;
it.Tag = column;
listDetailColumn.Items.Add(it);
if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null)
{
it.Checked = true;
}
}
}
void viewGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (View == null)
{
return;
}
if (viewGrid.dataGridView.CurrentRow == null)
{
return;
}
CViewDetail vd = (CViewDetail)View.ViewDetailMgr.GetFirstObj();
viewDetailGrid.ViewDetail = vd;
CTable table = (CTable)Program.Ctx.TableMgr.Find(vd.FW_Table_id);
if (table == null)
{
return;
}
CBaseObject obj = (CBaseObject)viewGrid.dataGridView.CurrentRow.Tag;
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, obj.Id);
if (objMgr == null)
{
objMgr = obj.GetSubObjectMgr(table.Code, typeof(CBaseObjectMgr));
}
if (objMgr == null)
{
CColumn colP = (CColumn)obj.Table.ColumnMgr.Find(vd.PrimaryKey);
if (colP == null)
{
return;
}
CColumn colF = (CColumn)table.ColumnMgr.Find(vd.ForeignKey);
if (colF == null)
{
return;
}
object objVal = obj.GetColValue(colP);
string sVal = objVal.ToString();
bool bIsStr = false;
if (colP.ColType == ColumnType.string_type ||
colP.ColType == ColumnType.text_type ||
colP.ColType == ColumnType.ref_type ||
colP.ColType == ColumnType.guid_type ||
colP.ColType == ColumnType.datetime_type)
{
sVal = string.Format("'{0}'", sVal);
bIsStr = true;
}
objMgr = new CBaseObjectMgr();
objMgr.Ctx = Program.Ctx;
objMgr.TbCode = table.Code;
objMgr.m_Parent = obj;
string sWhere = string.Format(" {0}={1}", colF.Code, bIsStr ? sVal : objVal);
objMgr.Load(sWhere, false);
}
viewDetailGrid.BaseObjectMgr = objMgr;
}
void LoadData()
{
txtName.Text = m_View.Name;
//默认表
for (int i = 0; i < cbMasterTable.Items.Count; i++)
{
if (cbMasterTable.Items[i].Value == m_View.FW_Table_id.ToString())
{
cbMasterTable.SelectedIndex = i;
cbMasterTable_SelectedIndexChanged(null, null);
break;
}
}
listViewDetail.Items.Clear();
List <CBaseObject> lstObj = m_View.ViewDetailMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CViewDetail ViewDetail = (CViewDetail)obj;
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(ViewDetail.FW_Table_id);
if (table == null)
{
continue;
}
ListItem item = new ListItem(table.Name, ViewDetail.Id.ToString());
listViewDetail.Items.Add(item);
}
}
void LoadDetailColumn()
{
if (cbDetailTable.SelectedIndex == -1)
{
return;
}
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(cbDetailTable.SelectedItem.Value));
CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id);
m_bIsLoadingData = true;
listDetailColumn.Items.Clear();
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn column = (CColumn)obj;
ListItem it = new ListItem(column.Name, column.Id.ToString());
listDetailColumn.Items.Add(it);
if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null)
{
it.Selected = true;
}
}
m_bIsLoadingData = false;
}
protected void cbForeignKey_SelectedIndexChanged(object sender, EventArgs e)
{
if (listViewDetail.SelectedIndex == -1)
{
return;
}
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.Find(new Guid(listViewDetail.SelectedItem.Value));
if (cbPrimaryKey.SelectedIndex == -1)
{
ViewDetail.PrimaryKey = Guid.Empty;
}
else
{
ViewDetail.PrimaryKey = new Guid(cbPrimaryKey.SelectedItem.Value);
}
if (cbForeignKey.SelectedIndex == -1)
{
ViewDetail.ForeignKey = Guid.Empty;
}
else
{
ViewDetail.ForeignKey = new Guid(cbForeignKey.SelectedItem.Value);
}
}
protected void listViewDetail_SelectedIndexChanged(object sender, EventArgs e)
{
LoadForeignKey();
if (listViewDetail.SelectedIndex == -1)
{
return;
}
string sVdId = listViewDetail.SelectedItem.Value;
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.Find(new Guid(sVdId));
for (int i = 0; i < cbPrimaryKey.Items.Count; i++)
{
if (cbPrimaryKey.Items[i].Value == ViewDetail.PrimaryKey.ToString())
{
cbPrimaryKey.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbForeignKey.Items.Count; i++)
{
if (cbForeignKey.Items[i].Value == ViewDetail.ForeignKey.ToString())
{
cbForeignKey.SelectedIndex = i;
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.End();
}
m_User = (CUser)Session["User"];
string vid = Request["vid"];
if (string.IsNullOrEmpty(vid))
{
Response.End();
}
string vdid = Request["vdid"];
if (string.IsNullOrEmpty(vdid))
{
Response.End();
}
m_View = (CView)Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.Find(new Guid(vid));
if (m_View == null)
{
Response.End();
}
m_ViewDetail = (CViewDetail)m_View.ViewDetailMgr.Find(new Guid(vdid));
if (m_ViewDetail == null)
{
Response.End();
}
m_Table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(m_ViewDetail.FW_Table_id);
//检查权限
if (!CheckAccess())
{
Response.End();
}
if (Session["EditMultMasterDetailViewRecord"] == null)
{
Response.End();
}
SortedList <Guid, CBaseObject> arrP = (SortedList <Guid, CBaseObject>)Session["EditMultMasterDetailViewRecord"];
CBaseObject objP = (CBaseObject)arrP.Values[0];
m_BaseObjectMgr = objP.GetSubObjectMgr(m_Table.Code, typeof(CBaseObjectMgr));
if (Request.Params["Action"] == "GetData")
{
GetData();
Response.End();
}
else if (Request.Params["Action"] == "Delete")
{
Delete();
Response.End();
}
}
void LoadData()
{
if (m_View == null) //新建
{
m_bIsNew = true;
m_View = new CView();
m_View.Ctx = Program.Ctx;
m_View.VType = enumViewType.MultMasterDetail;
m_View.Creator = Program.User.Id;
return;
}
m_bIsLoadingData = true;
txtName.Text = m_View.Name;
//默认表
for (int i = 0; i < cbMasterTable.Items.Count; i++)
{
DataItem item = (DataItem)cbMasterTable.Items[i];
CTable tb = (CTable)item.Data;
if (tb.Id == m_View.FW_Table_id)
{
cbMasterTable.SelectedIndex = i;
cbMasterTable_SelectedIndexChanged(null, null);
break;
}
}
List <CBaseObject> lstObj = m_View.ViewDetailMgr.GetList();
List <CViewDetail> sortObj = new List <CViewDetail>();
foreach (CBaseObject obj in lstObj)
{
CViewDetail vd = (CViewDetail)obj;
sortObj.Add(vd);
}
sortObj.Sort();
listViewDetail.Items.Clear();
foreach (CViewDetail ViewDetail in sortObj)
{
ListViewItem it = new ListViewItem();
it.Text = ViewDetail.Name;
it.Tag = ViewDetail;
listViewDetail.Items.Add(it);
CTable table = (CTable)Program.Ctx.TableMgr.Find(ViewDetail.FW_Table_id);
DataItem itT = new DataItem(table.Name, table);
cbDetailTable2.Items.Add(itT);
DataItem itT2 = new DataItem(table.Name, table);
cbDetailTable3.Items.Add(itT2);
}
LoadGridView();
LoadGridView4();
m_bIsLoadingData = false;
}
void LoadGridView()
{
if (cbTable.SelectedIndex == -1)
{
return;
}
DataItem item = (DataItem)cbTable.SelectedItem;
CTable table = (CTable)item.Data;
m_SelTable = table;
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
dataGridView.Rows.Clear();
foreach (CBaseObject obj in lstObj)
{
CColumn col = (CColumn)obj;
if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase))
{
continue;
}
if (table.Id == m_View.FW_Table_id) //主表
{
CColumnDefaultValInView cdviv = m_View.ColumnDefaultValInViewMgr.FindByColumn(col.Id);
dataGridView.Rows.Add(1);
DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1];
rowNew.Cells[0].Value = col.Name;
rowNew.Cells[0].ReadOnly = true;
if (cdviv != null)
{
rowNew.Cells[1].Value = cdviv.DefaultVal;
rowNew.Cells[2].Value = cdviv.ReadOnly;
}
rowNew.Tag = col;
}
else //从表
{
CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id);
CColumnDefaultValInViewDetail cdvivd = ViewDetail.ColumnDefaultValInViewDetailMgr.FindByColumn(col.Id);
dataGridView.Rows.Add(1);
DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1];
rowNew.Cells[0].Value = col.Name;
rowNew.Cells[0].ReadOnly = true;
if (cdvivd != null)
{
rowNew.Cells[1].Value = cdvivd.DefaultVal;
rowNew.Cells[2].Value = cdvivd.ReadOnly;
}
rowNew.Tag = col;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.End();
}
m_User = (CUser)Session["User"];
string vid = Request["vid"];
if (string.IsNullOrEmpty(vid))
{
Response.End();
}
string vdid = Request["vdid"];
if (string.IsNullOrEmpty(vdid))
{
Response.End();
}
m_View = (CView)Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.Find(new Guid(vid));
if (m_View == null)
{
Response.End();
}
m_ViewDetail = (CViewDetail)m_View.ViewDetailMgr.Find(new Guid(vdid));
if (m_ViewDetail == null)
{
Response.End();
}
m_Table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(m_ViewDetail.FW_Table_id);
//检查权限
if (!CheckAccess())
{
Response.End();
}
string ParentId = Request["ParentId"];
if (!string.IsNullOrEmpty(ParentId))
{
m_guidParentId = new Guid(ParentId);
}
if (Request.Params["Action"] == "GetData")
{
GetData();
Response.End();
}
else if (Request.Params["Action"] == "Delete")
{
Delete();
Response.End();
}
}
void GetDetail()
{
string table_id = Request["table_id"];
if (string.IsNullOrEmpty(table_id))
{
return;
}
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.FindByTable(new Guid(table_id));
if (ViewDetail == null)
{
return;
}
List <CBaseObject> lstObj = ViewDetail.ColumnInViewDetailMgr.GetList();
List <CColumnInViewDetail> sortObj = new List <CColumnInViewDetail>();
foreach (CBaseObject obj in lstObj)
{
CColumnInViewDetail civd = (CColumnInViewDetail)obj;
sortObj.Add(civd);
}
sortObj.Sort();
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(ViewDetail.FW_Table_id);
string sData = "";
int iCount = 0;
foreach (CColumnInViewDetail civd in sortObj)
{
CColumn col = (CColumn)table.ColumnMgr.Find(civd.FW_Column_id);
if (col == null)
{
continue;
}
sData += string.Format("{{ \"id\": \"{0}\",\"ColName\":\"{1}\",\"Caption\":\"{2}\"}},"
, civd.Id, col.Name, civd.Caption);
iCount++;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, iCount);
Response.Write(sJson);
}
void GetData()
{
string table_id = Request["table_id"];
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(table_id));
string sData = "";
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
int iCount = 0;
foreach (CBaseObject obj in lstObj)
{
CColumn col = (CColumn)obj;
if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase) ||
col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase))
{
continue;
}
if (table.Id == m_View.FW_Table_id) //主表
{
CColumnDefaultValInView cdviv = m_View.ColumnDefaultValInViewMgr.FindByColumn(col.Id);
string DefaultVal = cdviv != null ? cdviv.DefaultVal : "";
string ReadOnly = (cdviv != null && cdviv.ReadOnly) ? "1" : "0";
sData += string.Format("{{ \"id\": \"{0}\",\"ColName\":\"{1}\",\"DefaultVal\":\"{2}\",\"ReadOnly\":\"{3}\"}},"
, col.Id, col.Name, DefaultVal, ReadOnly);
}
else //从表
{
CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id);
CColumnDefaultValInViewDetail cdvivd = ViewDetail.ColumnDefaultValInViewDetailMgr.FindByColumn(col.Id);
string DefaultVal = cdvivd != null ? cdvivd.DefaultVal : "";
string ReadOnly = (cdvivd != null && cdvivd.ReadOnly) ? "1" : "0";
sData += string.Format("{{ \"id\": \"{0}\",\"ColName\":\"{1}\",\"DefaultVal\":\"{2}\",\"ReadOnly\":\"{3}\"}},"
, col.Id, col.Name, DefaultVal, ReadOnly);
}
iCount++;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, iCount);
Response.Write(sJson);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("../Login.aspx");
Response.End();
}
string id = Request["id"];
if (!string.IsNullOrEmpty(id))
{
m_View = (CView)Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.Find(new Guid(id));
}
else
{
m_bIsNew = true;
if (Session["NewMasterDetailView"] == null)
{
m_View = new CView();
m_View.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
m_View.VType = enumViewType.MasterDetail;
CViewDetail ViewDetail = new CViewDetail();
ViewDetail.Ctx = m_View.Ctx;
ViewDetail.UI_View_id = m_View.Id;
m_View.ViewDetailMgr.AddNew(ViewDetail);
SortedList <Guid, CView> sortObj = new SortedList <Guid, CView>();
sortObj.Add(m_View.Id, m_View);
Session["NewMasterDetailView"] = sortObj;
}
else
{
SortedList <Guid, CView> sortObj = (SortedList <Guid, CView>)Session["NewMasterDetailView"];
m_View = sortObj.Values[0];
}
}
string catalog_id = Request["catalog_id"];
if (!string.IsNullOrEmpty(catalog_id))
{
m_Catalog_id = new Guid(catalog_id);
}
if (!IsPostBack)
{
LoadCatalog();
LoadTable();
LoadData();
}
}
private void cbDetailTable_SelectedIndexChanged(object sender, EventArgs e)
{
if (!m_bIsLoadingData)
{
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
if (ViewDetail != null)
{
ViewDetail.ColumnInViewDetailMgr.RemoveAll();
}
}
LoadForeignKey();
LoadDetailColumn();
LoadGridView2();
}
bool SavePage1()
{
string sName = txtName.Text.Trim();
if (!sName.Equals(m_View.Name))
{
CView view2 = Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.FindByName(sName);
if (view2 != null)
{
RegisterStartupScript("starup", "<script>alert('名称重复！');</script>");
txtName.Focus();
return(false);
}
}
m_View.Name = sName;
if (cbCatalog.SelectedIndex > 0)
{
string catalog_id = cbCatalog.SelectedItem.Value;
CViewCatalog catalog = (CViewCatalog)Global.GetCtx(Session["TopCompany"].ToString()).ViewCatalogMgr.Find(new Guid(catalog_id));
m_View.UI_ViewCatalog_id = catalog.Id;
}
else
{
m_View.UI_ViewCatalog_id = Guid.Empty;
}
//如果是修改，并修改了主表，则清空旧字段
Guid guidMT = new Guid(cbMasterTable.SelectedItem.Value);
if (!m_bIsNew && guidMT != m_View.FW_Table_id)
{
m_View.ColumnInViewMgr.RemoveAll();
}
m_View.FW_Table_id = guidMT;
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
//如果是修改，并修改了从表，则清空旧字段
Guid guidDT = new Guid(cbDetailTable.SelectedItem.Value);
if (!m_bIsNew && guidDT != ViewDetail.FW_Table_id)
{
ViewDetail.ColumnInViewDetailMgr.RemoveAll();
}
ViewDetail.FW_Table_id = guidDT;
ViewDetail.PrimaryKey = new Guid(cbPrimaryKey.SelectedItem.Value);
ViewDetail.ForeignKey = new Guid(cbForeignKey.SelectedItem.Value);
m_View.ViewDetailMgr.Update(ViewDetail);
return(true);
}
bool SavePage1()
{
string sName = txtName.Text.Trim();
if (!sName.Equals(m_View.Name))
{
CView view2 = Program.Ctx.ViewMgr.FindByName(sName);
if (view2 != null)
{
MessageBox.Show("名称重复！");
txtName.Focus();
return(false);
}
}
m_View.Name = sName;
if (cbCatalog.SelectedIndex > 0)
{
DataItem item = (DataItem)cbCatalog.SelectedItem;
CViewCatalog catalog = (CViewCatalog)item.Data;
m_View.UI_ViewCatalog_id = catalog.Id;
}
else
{
m_View.UI_ViewCatalog_id = Guid.Empty;
}
DataItem itemP = (DataItem)cbMasterTable.SelectedItem;
CTable tableP = (CTable)itemP.Data;
m_View.FW_Table_id = tableP.Id;
DataItem itemF = (DataItem)cbDetailTable.SelectedItem;
CTable tableF = (CTable)itemF.Data;
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
ViewDetail.FW_Table_id = tableF.Id;
DataItem itemPK = (DataItem)cbPrimaryKey.SelectedItem;
CColumn columnPK = (CColumn)itemPK.Data;
ViewDetail.PrimaryKey = columnPK.Id;
DataItem itemFK = (DataItem)cbForeignKey.SelectedItem;
CColumn columnFK = (CColumn)itemFK.Data;
ViewDetail.ForeignKey = columnFK.Id;
m_View.ViewDetailMgr.Update(ViewDetail);
return(true);
}
void LoadTable()
{
cbTable.Items.Clear();
CTable table = (CTable)Program.Ctx.TableMgr.Find(m_View.FW_Table_id);
DataItem item = new DataItem(table.Name, table);
cbTable.Items.Add(item);
List <CBaseObject> lstObj = m_View.ViewDetailMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CViewDetail ViewDetail = (CViewDetail)obj;
CTable tableD = (CTable)Program.Ctx.TableMgr.Find(ViewDetail.FW_Table_id);
DataItem item2 = new DataItem(tableD.Name, tableD);
cbTable.Items.Add(item2);
}
}
private void cbMasterTable_SelectedIndexChanged(object sender, EventArgs e)
{
if (!m_bIsLoadingData)
{
m_View.ColumnInViewMgr.RemoveAll();
List <CBaseObject> lstObj = m_View.ViewDetailMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CViewDetail vd = (CViewDetail)obj;
vd.PrimaryKey = Guid.Empty;
}
}
LoadPrimaryKey();
LoadMasterColumn();
LoadGridView();
LoadGridView4();
}
void viewGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (View == null)
{
return;
}
if (viewGrid.dataGridView.CurrentRow == null)
{
return;
}
CViewDetail vd = (CViewDetail)View.ViewDetailMgr.GetFirstObj();
CTable table = (CTable)Program.Ctx.TableMgr.Find(vd.FW_Table_id);
CBaseObject obj = (CBaseObject)viewGrid.dataGridView.CurrentRow.Tag;
viewTab.View = View;
viewTab.ParentObject = obj;
}
private void btAddDetailTable_Click(object sender, EventArgs e)
{
if (cbDetailTable.SelectedIndex == -1)
{
MessageBox.Show("请选择从表！");
return;
}
DataItem item = (DataItem)cbDetailTable.SelectedItem;
CTable table = (CTable)item.Data;
for (int i = 0; i < listViewDetail.Items.Count; i++)
{
CViewDetail vd = (CViewDetail)listViewDetail.Items[i].Tag;
if (vd.FW_Table_id == table.Id)
{
MessageBox.Show("从表已经存在！");
return;
}
}
if (cbMasterTable.SelectedIndex != -1)
{
DataItem itM = (DataItem)cbMasterTable.SelectedItem;
CTable tbM = (CTable)itM.Data;
if (tbM.Id == table.Id)
{
MessageBox.Show("从表不能与主表相同！");
return;
}
}
CViewDetail ViewDetail = new CViewDetail();
ViewDetail.Ctx = Program.Ctx;
ViewDetail.FW_Table_id = table.Id;
ViewDetail.Name = table.Name;
ViewDetail.UI_View_id = m_View.Id;
ViewDetail.Idx = listViewDetail.Items.Count;
m_View.ViewDetailMgr.AddNew(ViewDetail);
ListViewItem it = new ListViewItem();
it.Text = ViewDetail.Name;
it.Tag = ViewDetail;
listViewDetail.Items.Add(it);
LoadDetailTable();
}
void LoadData()
{
txtName.Text = m_View.Name;
//默认表
for (int i = 0; i < cbMasterTable.Items.Count; i++)
{
if (cbMasterTable.Items[i].Value == m_View.FW_Table_id.ToString())
{
cbMasterTable.SelectedIndex = i;
cbMasterTable_SelectedIndexChanged(null, null);
break;
}
}
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
if (ViewDetail != null)
{
for (int i = 0; i < cbDetailTable.Items.Count; i++)
{
if (cbDetailTable.Items[i].Value == ViewDetail.FW_Table_id.ToString())
{
cbDetailTable.SelectedIndex = i;
cbDetailTable_SelectedIndexChanged(null, null);
break;
}
}
for (int i = 0; i < cbPrimaryKey.Items.Count; i++)
{
if (cbPrimaryKey.Items[i].Value == ViewDetail.PrimaryKey.ToString())
{
cbPrimaryKey.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbForeignKey.Items.Count; i++)
{
if (cbForeignKey.Items[i].Value == ViewDetail.ForeignKey.ToString())
{
cbForeignKey.SelectedIndex = i;
break;
}
}
}
}
void LoadGridView2()
{
if (cbDetailTable.SelectedIndex == -1)
{
return;
}
DataItem item = (DataItem)cbDetailTable.SelectedItem;
CTable tb = (CTable)item.Data;
txtDetailTable2.Text = tb.Name;
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
List <CBaseObject> lstObj = ViewDetail.ColumnInViewDetailMgr.GetList();
dataGridView2.Rows.Clear();
foreach (CBaseObject obj in lstObj)
{
CColumnInViewDetail civd = (CColumnInViewDetail)obj;
if (!civd.IsVirtual)
{
CColumn column = (CColumn)tb.ColumnMgr.Find(civd.FW_Column_id);
if (column == null)
{
continue;
}
dataGridView2.Rows.Add(1);
DataGridViewRow rowNew = dataGridView2.Rows[dataGridView2.Rows.Count - 1];
rowNew.Cells[0].Value = column.Name;
rowNew.Cells[0].ReadOnly = true;
rowNew.Cells[1].Value = civd.Caption;
rowNew.Tag = civd;
}
else
{
dataGridView2.Rows.Add(1);
DataGridViewRow rowNew = dataGridView2.Rows[dataGridView2.Rows.Count - 1];
rowNew.Cells[0].Value = civd.Caption;
rowNew.Cells[0].ReadOnly = true;
rowNew.Cells[1].Value = civd.Caption;
rowNew.Tag = civd;
}
}
}
bool SavePage1()
{
string sName = txtName.Text.Trim();
if (!sName.Equals(m_View.Name))
{
CView view2 = Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.FindByName(sName);
if (view2 != null)
{
RegisterStartupScript("starup", "<script>alert('名称重复！');</script>");
txtName.Focus();
return(false);
}
}
m_View.Name = sName;
if (cbCatalog.SelectedIndex > 0)
{
string catalog_id = cbCatalog.SelectedItem.Value;
CViewCatalog catalog = (CViewCatalog)Global.GetCtx(Session["TopCompany"].ToString()).ViewCatalogMgr.Find(new Guid(catalog_id));
m_View.UI_ViewCatalog_id = catalog.Id;
}
else
{
m_View.UI_ViewCatalog_id = Guid.Empty;
}
//如果是修改，并修改了主表，则清空旧字段
Guid guidMT = new Guid(cbMasterTable.SelectedItem.Value);
if (!m_bIsNew && guidMT != m_View.FW_Table_id)
{
m_View.ColumnInViewMgr.RemoveAll();
}
m_View.FW_Table_id = guidMT;
for (int i = 0; i < listViewDetail.Items.Count; i++)
{
CViewDetail vd = (CViewDetail)m_View.ViewDetailMgr.Find(new Guid(listViewDetail.Items[i].Value));
vd.Idx = i;
m_View.ViewDetailMgr.Update(vd);
}
return(true);
}
protected void btAdd_Click(object sender, EventArgs e)
{
if (cbMasterTable.SelectedIndex == -1)
{
RegisterStartupScript("starup", "<script>alert('请选择主表！');</script>");
return;
}
if (cbDetailTable.SelectedIndex == -1)
{
RegisterStartupScript("starup", "<script>alert('请选择从表！');</script>");
return;
}
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(cbDetailTable.SelectedItem.Value));
for (int i = 0; i < listViewDetail.Items.Count; i++)
{
if (listViewDetail.Items[i].Value == table.Id.ToString())
{
RegisterStartupScript("starup", "<script>alert('从表已经存在！');</script>");
return;
}
}
if (cbMasterTable.SelectedIndex != -1)
{
if (cbMasterTable.SelectedItem.Value == table.Id.ToString())
{
RegisterStartupScript("starup", "<script>alert('从表不能与主表相同！');</script>");
return;
}
}
CViewDetail ViewDetail = new CViewDetail();
ViewDetail.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
ViewDetail.FW_Table_id = table.Id;
ViewDetail.Name = table.Name;
ViewDetail.UI_View_id = m_View.Id;
ViewDetail.Idx = listViewDetail.Items.Count;
m_View.ViewDetailMgr.AddNew(ViewDetail);
ListItem it = new ListItem(ViewDetail.Name, ViewDetail.Id.ToString());
listViewDetail.Items.Add(it);
}
void GetDetail()
{
CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
if (ViewDetail == null)
{
return;
}
List <CBaseObject> lstObj = ViewDetail.ColumnInViewDetailMgr.GetList();
List <CColumnInViewDetail> sortObj = new List <CColumnInViewDetail>();
foreach (CBaseObject obj in lstObj)
{
CColumnInViewDetail civd = (CColumnInViewDetail)obj;
sortObj.Add(civd);
}
sortObj.Sort();
string sData = "";
int iCount = 0;
foreach (CColumnInViewDetail civd in sortObj)
{
CColumn col = (CColumn)m_DTable.ColumnMgr.Find(civd.FW_Column_id);
if (col == null)
{
continue;
}
sData += string.Format("{{ \"id\": \"{0}\",\"ColName\":\"{1}\",\"Caption\":\"{2}\"}},"
, civd.Id, col.Name, civd.Caption);
iCount++;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, iCount);
Response.Write(sJson);
}