/// <summary> /// 获取表格的列定义 /// </summary> /// <returns></returns> public List <GridColumnEntity> GetGridColumns() { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@" select * from MobileBussinessDefined where ISNULL(ViewOrder,0)!=0 and IsDelete=0 and CustomerID='{0}' and TableName='{1}' and TypeId=1 order by ViewOrder asc", CurrentUserInfo.ClientID, _pTableName); DataTable dt = this.GetDefind(sql.ToString()).Tables[0]; List <GridColumnEntity> l = new List <GridColumnEntity>(); for (int i = 0; i < dt.Rows.Count; i++) { GridColumnEntity m = new GridColumnEntity(); m.ColumnText = Convert.ToString(dt.Rows[i]["ColumnDesc"]); m.DataIndex = Convert.ToString(dt.Rows[i]["ColumnName"]); m.ColumnControlType = Convert.ToInt32(dt.Rows[i]["ControlType"]); if (dt.Rows[i]["CorrelationValue"] != DBNull.Value) { m.CorrelationValue = Convert.ToString(dt.Rows[i]["CorrelationValue"]); } l.Add(m); } return(l); }
/// <summary> /// 获取表格的列定义 /// </summary> /// <returns></returns> public List <GridColumnEntity> GetGridColumns() { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@" select * from ClientBussinessDefined where isnull(ListOrder,0)!=0 and isdelete=0 and ClientID='{0}' and TableName='{1}' order by ListOrder asc ", _pUserInfo.ClientID, _pTableName); DataTable dt = _currentDAO.GetDefind(sql.ToString()).Tables[0]; List <GridColumnEntity> l = new List <GridColumnEntity>(); for (int i = 0; i < dt.Rows.Count; i++) { GridColumnEntity m = new GridColumnEntity(); if (dt.Rows[i]["ColumnDesc"] != DBNull.Value) { m.ColumnText = Convert.ToString(dt.Rows[i]["ColumnDesc"]); } if (dt.Rows[i]["GridWidth"] != DBNull.Value) { m.ColumnWdith = Convert.ToInt32(dt.Rows[i]["GridWidth"]); } if (dt.Rows[i]["ColumnName"] != DBNull.Value) { m.DataIndex = Convert.ToString(dt.Rows[i]["ColumnName"]); } if (dt.Rows[i]["ControlType"] != DBNull.Value) { m.ColumnControlType = Convert.ToInt32(dt.Rows[i]["ControlType"]); } if (dt.Rows[i]["CorrelationValue"] != DBNull.Value) { m.CorrelationValue = Convert.ToString(dt.Rows[i]["CorrelationValue"]); } if (!string.IsNullOrEmpty(dt.Rows[i]["IsMustDo"].ToString())) { m.IsMustDo = Convert.ToInt32(dt.Rows[i]["IsMustDo"]); } l.Add(m); } return(l); }