public static string GetDataGridTemplate(DataTable table, DataGridColumnType columns) { string m_ValidTreeJson = ""; string[] m_ColumnText = columns.ColumnText; // = new string[] { "KeyID", "number", "Energy" }; int[] m_ColumnWidth = columns.ColumnWidth; // = new int[] { 180, 230, 130 }; string[] m_FormatString = columns.ColumnType; // = new string[] { "", "\"type\":\"text\"", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}" };//"\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "", "", "\"type\":\"checkbox\", \"options\":{\"on\":\"True\",\"off\":\"False\"}", "\"type\":\"text\"" }; DataTable m_DataTableUserInfo = table; List <Model_GridColumnType> m_Model_GridColumnTypeList = new List <Model_GridColumnType>(1); for (int i = 0; i < m_DataTableUserInfo.Columns.Count; i++) { Model_GridColumnType m_Model_GridColumnType = new Model_GridColumnType(); m_Model_GridColumnType.ColumnText = m_ColumnText[i]; m_Model_GridColumnType.ColumnWidth = m_ColumnWidth[i]; m_Model_GridColumnType.FormatString = m_FormatString[i]; m_Model_GridColumnTypeList.Add(m_Model_GridColumnType); } m_ValidTreeJson = DataTableConvertJson.DataTableToJson(m_DataTableUserInfo, m_Model_GridColumnTypeList); return(m_ValidTreeJson); }
public static string GetFormulaYearReportTemplate(DataTable table) { string m_ValidTreeJson = ""; string[] m_ColumnText = new string[] { "KeyID", "Number", "层次码", "工序名称", "峰期电耗", "尖峰期电耗", "谷期电耗", "平期电耗", "总计" }; int[] m_ColumnWidth = new int[] { 80, 230, 130, 130, 130, 130, 130, 130, 130 }; string[] m_FormatString = new string[] { "", "\"type\":\"text\"", "\"type\":\"text\"", "\"type\":\"text\"", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}" };//"\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "", "", "\"type\":\"checkbox\", \"options\":{\"on\":\"True\",\"off\":\"False\"}", "\"type\":\"text\"" }; DataTable m_DataTableUserInfo = table; List <Model_GridColumnType> m_Model_GridColumnTypeList = new List <Model_GridColumnType>(1); for (int i = 0; i < m_DataTableUserInfo.Columns.Count; i++) { Model_GridColumnType m_Model_GridColumnType = new Model_GridColumnType(); m_Model_GridColumnType.ColumnText = m_ColumnText[i]; m_Model_GridColumnType.ColumnWidth = m_ColumnWidth[i]; m_Model_GridColumnType.FormatString = m_FormatString[i]; m_Model_GridColumnTypeList.Add(m_Model_GridColumnType); } m_ValidTreeJson = DataTableConvertJson.DataTableToJson(m_DataTableUserInfo, m_Model_GridColumnTypeList); return(m_ValidTreeJson); }
public static string GetDataGridTemplate(DataTable table, DataGridColumnType columns) { string m_ValidTreeJson = ""; string[] m_ColumnText = columns.ColumnText;// = new string[] { "KeyID", "number", "Energy" }; int[] m_ColumnWidth = columns.ColumnWidth;// = new int[] { 180, 230, 130 }; string[] m_FormatString = columns.ColumnType;// = new string[] { "", "\"type\":\"text\"", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}" };//"\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "", "", "\"type\":\"checkbox\", \"options\":{\"on\":\"True\",\"off\":\"False\"}", "\"type\":\"text\"" }; DataTable m_DataTableUserInfo = table; List<Model_GridColumnType> m_Model_GridColumnTypeList = new List<Model_GridColumnType>(1); for (int i = 0; i < m_DataTableUserInfo.Columns.Count; i++) { Model_GridColumnType m_Model_GridColumnType = new Model_GridColumnType(); m_Model_GridColumnType.ColumnText = m_ColumnText[i]; m_Model_GridColumnType.ColumnWidth = m_ColumnWidth[i]; m_Model_GridColumnType.FormatString = m_FormatString[i]; m_Model_GridColumnTypeList.Add(m_Model_GridColumnType); } m_ValidTreeJson = DataTableConvertJson.DataTableToJson(m_DataTableUserInfo, m_Model_GridColumnTypeList); return m_ValidTreeJson; }
public static string GetFormulaYearReportTemplate(DataTable table) { string m_ValidTreeJson = ""; string[] m_ColumnText = new string[] { "KeyID", "Number", "层次码", "工序名称", "峰期电耗", "尖峰期电耗", "谷期电耗", "平期电耗", "总计" }; int[] m_ColumnWidth = new int[] { 80, 230, 130, 130, 130, 130, 130, 130, 130 }; string[] m_FormatString = new string[] { "", "\"type\":\"text\"", "\"type\":\"text\"", "\"type\":\"text\"", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}","\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}","\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}" };//"\"type\":\"numberbox\", \"options\":{\"precision\":\"2\"}", "", "", "\"type\":\"checkbox\", \"options\":{\"on\":\"True\",\"off\":\"False\"}", "\"type\":\"text\"" }; DataTable m_DataTableUserInfo = table; List<Model_GridColumnType> m_Model_GridColumnTypeList = new List<Model_GridColumnType>(1); for (int i = 0; i < m_DataTableUserInfo.Columns.Count; i++) { Model_GridColumnType m_Model_GridColumnType = new Model_GridColumnType(); m_Model_GridColumnType.ColumnText = m_ColumnText[i]; m_Model_GridColumnType.ColumnWidth = m_ColumnWidth[i]; m_Model_GridColumnType.FormatString = m_FormatString[i]; m_Model_GridColumnTypeList.Add(m_Model_GridColumnType); } m_ValidTreeJson = DataTableConvertJson.DataTableToJson(m_DataTableUserInfo, m_Model_GridColumnTypeList); return m_ValidTreeJson; }