public CView Convert(DataTable dataTable)
{
var view = new CView();
view.Column = new List <CColumn>();
foreach (var row2 in dataTable.Rows)
{
var row = row2 as DataRow;
view.ViewName = (string)row[4];
view.Schema = new CSchema {
SchemaName = (string)row[5]
};
var column = new CColumn(view)
{
ColumnName = (string)row[0],
ColumnTypeRaw = (string)row[1],
ColumnSqlDbType = SqlMapper.ParseValueAsSqlDbType((string)row[1]),
ColumnType = SqlMapper.GetDbType((string)row[1]),
ColumnLength = row[3] != DBNull.Value ? (int)row[3] : -1,
ColumnDescription = row[6] != DBNull.Value ? (string)row[6] : null
};
view.Column.Add(column);
}
return(view);
}
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;
}
}
}
private IEnumerable <string> GetColumnOperators(CColumn column)
{
var list = new List <string>();
string opString = string.Empty;
switch (GetMappingType(column.DbType.ToString()).ToString())
{
case "System.DateTime":
case "System.Int16":
case "System.Int32":
case "System.Int64":
case "System.Double":
opString = "=,<>,>,>=,<,<=,Is,Is Not";
break;
case "System.Boolean":
opString = "=,<>,Is,Is Not";
break;
default:
opString = "=,<>,Like,Is,Is Not";
break;
}
foreach (string op in opString.Split(new char[] { ',' }))
{
if (!list.Contains(op))
{
list.Add(op);
}
}
return(list);
}
void GetData()
{
string tid = Request["tid"];
if (string.IsNullOrEmpty(tid))
{
Response.End();
return;
}
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(tid));
if (table == null)
{
Response.End();
return;
}
string sData = "";
List <CBaseObject> lstObj = table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn col = (CColumn)obj;
sData += string.Format("{{ \"id\": \"{0}\",\"Name\":\"{1}\", \"Code\":\"{2}\", \"ColType\":\"{3}\" }},"
, col.Id, col.Name, col.Code, CColumn.ConvertColTypeToString(col.ColType));
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
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;
}
private void cbPNodeIDCol_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbPNodeIDCol.SelectedItem == null)
{
return;
}
DataItem item = (DataItem)cbPNodeIDCol.SelectedItem;
CColumn column = (CColumn)item.Data;
switch (column.ColType)
{
case ColumnType.int_type:
case ColumnType.long_type:
{
txtRootFilter.Text = string.Format("{0}=0", column.Code);
break;
}
case ColumnType.string_type:
{
txtRootFilter.Text = string.Format("({0}='' or {0} is null)", column.Code);
break;
}
case ColumnType.guid_type:
case ColumnType.ref_type:
{
txtRootFilter.Text = string.Format("{0}='{{00000000-0000-0000-0000-000000000000}}'", column.Code);
break;
}
}
}
public string GetColumnRefDefaultVal(CColumnDefaultValInViewDetail cdvivd, CColumn col)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
CBaseObjectMgr BaseObjectMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, Guid.Empty);
if (BaseObjectMgr == null)
{
BaseObjectMgr = new CBaseObjectMgr();
BaseObjectMgr.TbCode = RefTable.Code;
BaseObjectMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
}
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
List <CBaseObject> lstObjRef = BaseObjectMgr.GetList();
string defval = GetColumnDefaultVal(cdvivd, col).ToString();
foreach (CBaseObject objRef in lstObjRef)
{
string val = objRef.GetColValue(RefCol).ToString();
if (defval == val)
{
return(objRef.GetColValue(RefShowCol).ToString());
}
}
return("");
}
//设置文件上传路径
static public void SetUploadPath()
{
CContext ctx = GetCtx();
string sPath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["VirtualDir"]);
//设置默认文件上传路径
ctx.UploadPath = sPath + "\\UploadPath\\";
if (!Directory.Exists(ctx.UploadPath))
{
Directory.CreateDirectory(ctx.UploadPath);
}
//设置产品图片上传路径
string sUploadPath = sPath + "\\Store\\ProductImg\\";
if (!Directory.Exists(sUploadPath))
{
Directory.CreateDirectory(sUploadPath);
}
CTable table = ctx.TableMgr.FindByCode("SP_ProductImg");
if (table != null)
{
CColumn col = (CColumn)table.ColumnMgr.FindByCode("Url");
if (col != null)
{
col.UploadPath = sUploadPath;
}
}
}
private void listMasterColumn_ItemChecked(object sender, ItemCheckedEventArgs e)
{
CColumn column = (CColumn)e.Item.Tag;
if (e.Item.Checked)
{
CColumnInView civ = new CColumnInView();
civ.Ctx = Program.Ctx;
civ.FW_Column_id = column.Id;
civ.FW_Table_id = column.FW_Table_id;
civ.Caption = column.Name;
civ.UI_View_id = m_View.Id;
m_View.ColumnInViewMgr.AddNew(civ);
dataGridView.Rows.Add(1);
DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1];
rowNew.Cells[0].Value = column.Name;
rowNew.Cells[0].ReadOnly = true;
rowNew.Cells[1].Value = civ.Caption;
rowNew.Tag = civ;
}
else
{
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
CColumnInView civ = (CColumnInView)dataGridView.Rows[i].Tag;
if (civ.FW_Column_id == column.Id)
{
m_View.ColumnInViewMgr.Delete(civ);
dataGridView.Rows.RemoveAt(i);
break;
}
}
}
}
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()
{
listSelColumn.Items.Clear();
foreach (CBaseObject obj in m_Report.StatItemMgr.GetList())
{
CStatItem StatItem = (CStatItem)obj;
ListViewItem item = new ListViewItem();
if (StatItem.ItemType == CStatItem.enumItemType.Field)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(StatItem.FW_Table_id);
if (table == null)
{
continue;
}
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
item.Text = table.Name;
item.SubItems.Add(column.Name);
}
else
{
item.Text = StatItem.Name;
item.SubItems.Add(StatItem.Formula);
}
item.Tag = StatItem;
listSelColumn.Items.Add(item);
}
}
void LoadMasterColumn()
{
if (cbMasterTable.SelectedIndex == -1)
{
return;
}
DataItem item = (DataItem)cbMasterTable.SelectedItem;
CTable tb = (CTable)item.Data;
txtMasterTable.Text = tb.Name;
listMasterColumn.Items.Clear();
cbMasterColumn4.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;
listMasterColumn.Items.Add(it);
if (m_View.ColumnInViewMgr.FindByColumn(column.Id) != null)
{
it.Checked = true;
}
DataItem it2 = new DataItem(column.Name, column);
cbMasterColumn4.Items.Add(it2);
}
}
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 LoadData()
{
if (m_Report == null)
{
m_bIsNew = true;
m_Report = new CReport();
m_Report.Ctx = Program.Ctx;
m_Report.RPT_ReportCatalog_id = m_Catalog_id;
m_Report.B_Company_id = m_Company.Id;
}
txtName.Text = m_Report.Name;
dataGridStatItem.Rows.Clear();
foreach (CBaseObject obj in m_Report.StatItemMgr.GetList())
{
CStatItem StatItem = (CStatItem)obj;
if (StatItem.ItemType == CStatItem.enumItemType.Field)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(StatItem.FW_Table_id);
if (table == null)
{
continue;
}
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
if (column == null)
{
continue;
}
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = table.Name;
item.Cells[1].Value = column.Name;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
else
{
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = StatItem.Name;
item.Cells[1].Value = StatItem.Formula;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
}
txtFilter.Text = m_Report.Filter;
}
void LoadHeader()
{
if (Company == null)
{
return;
}
if (dataGridView == null)
{
return;
}
dataGridView.Columns.Clear();
List <CBaseObject> lstCol = Company.WorkflowDefMgr.Table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstCol)
{
CColumn col = (CColumn)obj;
//if (!col.IsVisible)
// continue;
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
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 trd()
{
timer1.Enabled = true;
m_baseMgr = new CBaseObjectMgr();
m_baseMgr.Ctx = Program.Ctx;
m_baseMgr.TbCode = "test5";
CTable tb = Program.Ctx.TableMgr.FindByCode("test5");
CColumn col = tb.ColumnMgr.FindByCode("val");
double dblCount = 0;
while (m_bIsStart)
{
//for (int i = 0; i < 100; i++)
//{
CBaseObject obj = new CBaseObject();
obj.Ctx = Program.Ctx;
obj.TbCode = "test5";
Random rand = new Random();
obj.SetColValue(col, rand.NextDouble() * 10);
m_baseMgr.AddNew(obj, true);
dblCount++;
this.Invoke(new myEventHandler(ChangeLabelText), new object[] { dblCount.ToString() });
//}
//m_baseMgr.Save(true);
}
}
private void button2_Click(object sender, EventArgs e)
{
CTable tb = Program.Ctx.TableMgr.FindByCode("test5");
CColumn col = tb.ColumnMgr.FindByCode("val");
DateTime now1 = DateTime.Now;
double dlbSum = 0;
List <CBaseObject> lst = m_baseMgr.GetList();
//foreach (CBaseObject obj in lst)
//{
// //dlbSum += obj.m_arrNewVal["val"].DoubleVal;
//}
int idx = lst[0].GetColIdx("val");
for (int i = 0; i < lst.Count; i++)
{
CBaseObject obj = lst[i];
dlbSum += obj.GetColValue2(idx).DoubleVal;
}
DateTime now2 = DateTime.Now;
TimeSpan span = now2 - now1;
string sText = string.Format("求和：{0} ,耗时：{1}", dlbSum, span.TotalSeconds);
MessageBox.Show(sText);
}
void LoadHeader()
{
if (BaseObjectMgr == null)
{
return;
}
if (dataGridView == null)
{
return;
}
dataGridView.Columns.Clear();
bool bHas = false;
if (View != null)
{
List <CBaseObject> lstCIV = View.ColumnInViewMgr.GetList();
if (lstCIV.Count > 0)
{
bHas = true;
foreach (CBaseObject obj in lstCIV)
{
CColumnInView civ = (CColumnInView)obj;
CColumn col = (CColumn)BaseObjectMgr.Table.ColumnMgr.Find(civ.FW_Column_id);
if (col == null)
{
continue;
}
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
}
if (!bHas)
{
List <CBaseObject> lstCol = baseObjectMgr.Table.ColumnMgr.GetList();
foreach (CColumn col in lstCol)
{
//if (!col.IsVisible)
// continue;
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
//工作流
if (m_bShowWorkflow)
{
DataGridViewTextBoxColumn columnWF = new DataGridViewTextBoxColumn();
columnWF.Name = "workflow";
columnWF.HeaderText = "工作流";
dataGridView.Columns.Add(columnWF);
}
}
void LoadHeader()
{
if (ViewDetail == null)
{
return;
}
if (dataGridView == null)
{
return;
}
dataGridView.Columns.Clear();
CTable table = (CTable)Program.Ctx.TableMgr.Find(ViewDetail.FW_Table_id);
if (table == null)
{
return;
}
bool bHas = false;
List <CBaseObject> lstCIVD = ViewDetail.ColumnInViewDetailMgr.GetList();
if (lstCIVD.Count > 0)
{
bHas = true;
foreach (CBaseObject obj in lstCIVD)
{
CColumnInViewDetail civd = (CColumnInViewDetail)obj;
CColumn col = (CColumn)table.ColumnMgr.Find(civd.FW_Column_id);
if (col == null)
{
continue;
}
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
if (!bHas)
{
List <CBaseObject> lstCol = table.ColumnMgr.GetList();
foreach (CColumn col in lstCol)
{
//if (!col.IsVisible)
// continue;
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
////工作流
//DataGridViewTextBoxColumn columnWF = new DataGridViewTextBoxColumn();
//columnWF.Name = "workflow";
//columnWF.HeaderText = "工作流";
//dataGridView.Columns.Add(columnWF);
}
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;
}
}
}
public virtual void IsDropOnColumn(CColumn column)
{
if (column == null || this.m_RectTransform == null)
{
return;
}
this.m_Column = column;
this.m_RectTransform.SetParent(this.m_Column.transform);
}
void GetCondiction()
{
string Table_id = Request["Table_id"];
string Column_id = Request["Column_id"];
string Val = Request["Val"];
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(Table_id));
if (table == null)
{
return;
}
CColumn col = (CColumn)table.ColumnMgr.Find(new Guid(Column_id));
if (col == null)
{
return;
}
if (col.ColType == ColumnType.int_type ||
col.ColType == ColumnType.long_type ||
col.ColType == ColumnType.numeric_type ||
col.ColType == ColumnType.bool_type)
{
if (Val == "")
{
Val = "0";
}
else
{
try { Convert.ToDouble(Val); }
catch
{
return;
}
}
}
else
{
if (Val == "")
{
Val = "''";
}
else
{
if (Val[0] != '\'')
{
Val = "\'" + Val;
}
if (Val[Val.Length - 1] != '\'')
{
Val += "\'";
}
}
}
Response.Write(Val);
}
public void SetColumnVisible(CColumn col, bool bVisible)
{
foreach (DataGridViewColumn column in dataGridView.Columns)
{
if (column.Name.Equals(col.Code, StringComparison.OrdinalIgnoreCase))
{
column.Visible = bVisible;
}
}
}
private void btOk_Click(object sender, EventArgs e)
{
if (listColumn.SelectedItems.Count == 0)
{
MessageBox.Show("请选择一项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
m_SelColumn = (CColumn)listColumn.SelectedItems[0].Tag;
DialogResult = DialogResult.OK;
}
//日期型字段是否显示时间部分
public string GetShowTimel(CColumn col)
{
if (m_sortShowTimeColumn.ContainsKey(col.Code))
{
return("true");
}
else
{
return("false");
}
}
private CQuerieResult GetFavoritesData()
{
CQuerieResult q = new CQuerieResult();
var db = Services.XServices.Instance.GetService <Services.XDatabase>();
List <string> favorites = db.GetFavorites();
CColumn[] columns = new CColumn[2];
CRow[] rows = new CRow[favorites.Count];
columns[0] = new CColumn()
{
DisplayDescription = "Name"
};
columns[1] = new CColumn()
{
DisplayDescription = "Description"
};
//columns[2] = new CColumn() { DisplayDescription = "Pic" };
q.Columns = columns;
q.Rows = rows;
int i = 0;
foreach (var item in favorites)
{
CRow row = new CRow();
CObject output = Newtonsoft.Json.JsonConvert.DeserializeObject <CObject>(item);
m_Query.SetMainObject(output);
row.Items = new CCell[2];
row.Items[0] = new CCell()
{
Text = output.Name, UID = output.UID, Picture = output.Picture
};
row.Items[1] = new CCell()
{
Text = output.Description, UID = output.UID, Picture = output.Picture
};
//row.Items[2] = new CCell() { Text = output.Picture, UID = output.UID, Picture = output.Picture };
row.UID = output.UID;
rows[i] = row;
i++;
}
m_Query.SetNavigator(this.Navigator.Database);
m_Query.Query = q;
m_Query.ShowListQuery();
return(q);
}
void LoadColumn()
{
cbColumn.Items.Clear();
List <CBaseObject> lstObj = m_Table.ColumnMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CColumn col = (CColumn)obj;
ListItem item = new ListItem(col.Name, col.Id.ToString());
cbColumn.Items.Add(item);
}
}
void PostData()
{
CUser user = (CUser)Session["User"];
COrg BaseObject = new COrg();
BaseObject.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
BaseObject.Creator = user.Id;
List <CBaseObject> lstCol = m_Table.ColumnMgr.GetList();
bool bHasVisible = false;
foreach (CBaseObject obj in lstCol)
{
CColumn col = (CColumn)obj;
if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase))
{
continue;
}
else if (col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase))
{
continue;
}
else if (col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase))
{
//BaseObject.SetColValue(col, Program.User.Id);
continue;
}
else if (col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase))
{
continue;
}
else if (col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase))
{
//BaseObject.SetColValue(col, Program.User.Id);
continue;
}
BaseObject.SetColValue(col, Request.Params[col.Code]);
bHasVisible = true;
}
if (!bHasVisible)
{
Response.Write("没有可修改字段！");
return;
}
if (!m_Company.OrgMgr.AddNew(BaseObject, true))
{
Response.Write("添加失败！");
return;
}
}
void LoadHeader()
{
if (BaseObjectMgr == null)
{
return;
}
if (dataGridView == null)
{
return;
}
dataGridView.Columns.Clear();
bool bHas = false;
if (TableInFormControl != null)
{
List <CBaseObject> lstCIWC = TableInFormControl.ColumnInTableInFormControlMgr.GetList();
if (lstCIWC.Count > 0)
{
bHas = true;
foreach (CBaseObject obj in lstCIWC)
{
CColumnInTableInFormControl ciwc = (CColumnInTableInFormControl)obj;
CColumn col = (CColumn)BaseObjectMgr.Table.ColumnMgr.Find(ciwc.FW_Column_id);
if (col == null)
{
continue;
}
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
}
if (!bHas)
{
List <CBaseObject> lstCol = baseObjectMgr.Table.ColumnMgr.GetList();
foreach (CColumn col in lstCol)
{
//if (!col.IsVisible)
// continue;
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = col.Code;
column.HeaderText = col.Name;
column.Tag = col;
dataGridView.Columns.Add(column);
}
}
}
