public static Boolean RemoveSheetConfiguration(ModuleConfiguration module, SheetConfiguration sheet) { module.Sheets.Remove(sheet); Boolean Result = Convert.ToBoolean(Agent.CallService("Yqun.BO.BusinessManager.dll", "UpdateSheetConfiguration", new object[] { module })); return(Result); }
public SheetReferenceDialog(int RowIndex, int ColumnIndex, DownListCellType CellType) { InitializeComponent(); this.SheetConfiguration = SheetConfiguration; this.RowIndex = RowIndex; this.ColumnIndex = ColumnIndex; this.CellType = CellType; DataFilter = new DataFilterCondition(); }
private void ShowSheetReferenceDialog() { if (FpSpread.ActiveSheet.ActiveCell.CellType is DownListCellType) { DownListCellType CellType = FpSpread.ActiveSheet.ActiveCell.CellType as DownListCellType; SheetConfiguration SheetConfiguration = FpSpread.ActiveSheet.Tag as SheetConfiguration; int RowIndex = FpSpread.ActiveSheet.ActiveRowIndex; int ColumnIndex = FpSpread.ActiveSheet.ActiveColumnIndex; //SheetReferenceDialog ReferenceDialog = new SheetReferenceDialog(SheetConfiguration, RowIndex, ColumnIndex, CellType); //ReferenceDialog.ShowDialog(); } }
public static bool Delete(string Code) { StringBuilder Sql_Select = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_Select.Append("Select * From sys_biz_Sheet Where Scdel=0 and CatlogCode like '"); Sql_Select.Append(Code); Sql_Select.Append("%'"); DataTable Data = Agent.CallService("Yqun.BO.LoginBO.dll", "GetDataTable", new object[] { Sql_Select.ToString() }) as DataTable; if (Data != null && Data.Rows.Count > 0) { foreach (DataRow Row in Data.Rows) { String Index = Row["ID"].ToString(); SheetConfiguration Configuration = DepositorySheetConfiguration.InitConfiguration(Index); DepositorySheetConfiguration.Delete(Configuration); } } //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,便于数据同步 2013-10-15 StringBuilder Sql_Delete = new StringBuilder(); //Sql_Delete.Append("Delete From sys_biz_SheetCatlog Where CatlogCode like '"); //Sql_Delete.Append(Code); //Sql_Delete.Append("%'"); Sql_Delete.Append("Update sys_biz_SheetCatlog Set Scts_1='" + DateTime.Now + "',Scdel=1"); Sql_Delete.Append(" Where CatlogCode like '"); Sql_Delete.Append(Code); Sql_Delete.Append("%'"); Boolean Result = false; try { object r = Agent.CallService("Yqun.BO.LoginBO.dll", "ExcuteCommand", new object[] { Sql_Delete.ToString() }); Result = (Convert.ToInt32(r) == 1); } catch { } return(Result); }
private void ConditionItemSelector_Load(object sender, EventArgs e) { String ErrorInfo = ""; ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); try { SheetInfo = DepositorySheetConfiguration.InitConfiguration(SheetIndex); ProgressScreen.Current.SetStatus = "正在初始化表单‘" + SheetInfo.Description + "’"; fpSpread1.Sheets.Clear(); SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), SheetInfo.SheetStyle, "SheetView") as SheetView; SheetView.SheetName = SheetInfo.Description; SheetView.OperationMode = OperationMode.ReadOnly; fpSpread1.Sheets.Add(SheetView); if (SheetInfo.DataTableSchema.Schema != null) { foreach (FieldDefineInfo field in SheetInfo.DataTableSchema.Schema.FieldInfos) { SheetView.Cells[field.RangeInfo].BackColor = Color.LightPink; SheetView.Cells[field.RangeInfo].Tag = field; } } } catch (Exception ex) { ErrorInfo = ex.Message; } this.RemoveOwnedForm(ProgressScreen.Current); ProgressScreen.Current.CloseSplashScreen(); Activate(); if (ErrorInfo != "") { MessageBox.Show("加载表单出错!\r\n原因:" + ErrorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool NewSheetConfiguration(SheetConfiguration Sheet) { StringBuilder Sql_Select = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_Select.Append("Select ID,SCTS,Scts_1,CatlogCode,Description,SheetStyle,DataTable From sys_biz_Sheet Where Scdel=0 and ID='"); Sql_Select.Append(Sheet.Index); Sql_Select.Append("'"); DataTable Data = GetDataTable(Sql_Select.ToString()); if (Data != null) { DataRow Row = Data.NewRow(); Row["ID"] = Sheet.Index; Row["SCTS"] = DateTime.Now.ToString(); Row["CatlogCode"] = Sheet.Code; Row["Description"] = Sheet.Description; Row["SheetStyle"] = Sheet.SheetStyle; Row["DataTable"] = ""; Row["Scts_1"] = DateTime.Now.ToString(); Data.Rows.Add(Row); } Boolean Result = false; try { object r = Update(Data); Result = (Convert.ToInt32(r) == 1); } catch { } return(Result); }
public void WriteTestFile() { var configuration = new SheetConfiguration() { Name = "Sheet A", Columns = new List <ColumnBase>() { new TextColumn("Title", nameof(Record.Name)), new BooleanColumn("Active", nameof(Record.IsActive)), new DateColumn("Edited on...", nameof(Record.LastEditTime)), new NumberColumn("Length", nameof(Record.Size)) }, Data = new List <object>() { new Record() { LastEditTime = DateTime.Now, IsActive = true, Name = "Test a", Size = 123.4 }, new Record() { LastEditTime = DateTime.MaxValue, IsActive = false, Name = "Test b", Size = 4 } } }; using (var stream = ExcelExporter.Generate(configuration)) { File.WriteAllBytes(TestFilePath, stream.ToArray()); } }
public List <String> IsReferenceSheet(SheetConfiguration sheet) { List <String> Result = new List <string>(); StringBuilder Sql_Command = new StringBuilder(); // 增加查询条件 Scdel=0 2013-10-19 Sql_Command.Append("Select ID,Description From sys_biz_Module Where Scdel=0 and Sheets like ',"); Sql_Command.Append(sheet.Index); Sql_Command.Append(",'"); DataTable Data = GetDataTable(Sql_Command.ToString()); if (Data != null && Data.Rows.Count > 0) { foreach (DataRow Row in Data.Rows) { String Description = Row["Description"].ToString(); Result.Add(Description); } } return(Result); }
void worker_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; BatchPrintClass Params = e.Argument as BatchPrintClass; ModuleConfiguration Model = Params.modelInfo; String DataCode = Params.dataCode; ModelDataManager DataManager = new ModelDataManager(); DataSet dataSet = new DataSet(); if (dataID != null) { dataSet = DataManager.GetData(Model, dataID, DataCode); } else { dataSet = DataManager.GetData(Model, DataCode); } FpSpread fpSpread = new MyCell(); PrintDialog Dialog = new PrintDialog(); Dialog.AllowSomePages = true; Dialog.PrinterSettings.PrintRange = PrintRange.SomePages; Dialog.PrinterSettings.FromPage = 1; Dialog.PrinterSettings.ToPage = 1; if (DialogResult.OK == Dialog.ShowDialog()) { //初始化模板样式 fpSpread.Sheets.Clear(); foreach (SheetConfiguration Sheet in Model.Sheets) { SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), Sheet.SheetStyle, "SheetView") as SheetView; SheetView.Tag = Sheet; SheetView.SheetName = Sheet.Description; fpSpread.Sheets.Add(SheetView); } fpSpread.LoadFormulas(true); //加载数据到模板样式 if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow Row in dataSet.Tables[0].Rows) { Application.DoEvents(); int Index = dataSet.Tables[0].Rows.IndexOf(Row); worker.ReportProgress((Index + 1) / dataSet.Tables[0].Rows.Count); String DataID = Row["ID"].ToString(); foreach (SheetView SheetView in fpSpread.Sheets) { SheetConfiguration SheetConfiguration = SheetView.Tag as SheetConfiguration; TableDefineInfo TableInfo = SheetConfiguration.DataTableSchema.Schema; if (TableInfo != null) { foreach (FieldDefineInfo FieldInfo in TableInfo.FieldInfos) { DataRow[] DataRows = dataSet.Tables[GetBracketName(TableInfo.Name)].Select("ID='" + DataID + "'"); SheetView.Cells[FieldInfo.RangeInfo].Value = DataRows[0][FieldInfo.FieldName]; } } } //批量打印 BatchPrintDocument Document = new BatchPrintDocument(fpSpread); Document.PrinterSettings = Dialog.PrinterSettings; Document.Print(); } e.Result = "已输出全部资料到打印机。"; } else { e.Result = string.Format("模板 {0} 中没有资料数据。", Model.Description); } fpSpread.Dispose(); fpSpread = null; } else { return; } }
public static List <String> IsReferenceSheet(SheetConfiguration Sheet) { List <String> Result = Agent.CallService("Yqun.BO.BusinessManager.dll", "IsReferenceSheet", new object[] { Sheet }) as List <String>; return(Result); }
public static bool Delete(SheetConfiguration Sheet) { Boolean Result = Convert.ToBoolean(Agent.CallService("Yqun.BO.BusinessManager.dll", "DeleteSheetConfiguration", new object[] { Sheet })); return(Result); }
private void StadiumItemSelector_Load(object sender, EventArgs e) { String ErrorInfo = ""; ProgressScreen.Current.ShowSplashScreen(); this.AddOwnedForm(ProgressScreen.Current); ProgressScreen.Current.SetStatus = "正在加载模板..."; ModelInfo = DepositoryModuleConfiguration.InitModuleConfiguration(ModelIndex); try { fpSpread1.Sheets.Clear(); foreach (SheetConfiguration Sheet in ModelInfo.Sheets) { if (Sheet == null) { continue; } ProgressScreen.Current.SetStatus = "正在初始化表单‘" + Sheet.Description + "’"; SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), Sheet.SheetStyle, "SheetView") as SheetView; SheetView.Tag = Sheet; SheetView.SheetName = Sheet.Description; SheetView.ZoomFactor = 1.0F; fpSpread1.Sheets.Add(SheetView); SheetConfiguration Configuration = SheetView.Tag as SheetConfiguration; if (Configuration.DataTableSchema.Schema == null) { continue; } foreach (FieldDefineInfo field in Configuration.DataTableSchema.Schema.FieldInfos) { SheetView.Cells[field.RangeInfo].BackColor = Color.LightPink; SheetView.Cells[field.RangeInfo].Tag = field; } } lView_ExtentDataItems.Items.Clear(); foreach (FieldDefineInfo fieldInfo in ModelInfo.ExtentDataSchema.FieldInfos) { ListViewItem Item = new ListViewItem(); Item.Text = fieldInfo.FieldName; Item.Tag = fieldInfo; Item.SubItems.Add(fieldInfo.Description); Item.SubItems.Add(fieldInfo.FieldType.Description); lView_ExtentDataItems.Items.Add(Item); } } catch (Exception ex) { ErrorInfo = ex.Message; } this.RemoveOwnedForm(ProgressScreen.Current); ProgressScreen.Current.CloseSplashScreen(); Activate(); label2.BackColor = Color.LightPink; if (ErrorInfo != "") { MessageBox.Show("加载模板出错!\r\n原因:" + ErrorInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool DeleteSheetConfiguration(SheetConfiguration Sheet) { //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,便于数据同步 2013-10-17 StringBuilder Sql_Sheet = new StringBuilder(); //Sql_Sheet.Append("Delete From sys_biz_Sheet Where ID ='"); //Sql_Sheet.Append(Sheet.Index); //Sql_Sheet.Append("'"); Sql_Sheet.Append("Update sys_biz_Sheet Set Scts_1=Getdate(),Scdel=1 Where ID ='"); Sql_Sheet.Append(Sheet.Index); Sql_Sheet.Append("'"); StringBuilder Sql_DataArea = new StringBuilder(); if (Sheet.DataTableSchema.Schema != null) { //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,便于数据同步 2013-10-17 //Sql_DataArea.Append("Delete From sys_biz_DataArea Where SheetID ='"); //Sql_DataArea.Append(Sheet.Index); //Sql_DataArea.Append("' and TableName='"); //Sql_DataArea.Append(Sheet.DataTableSchema.Schema.Name); //Sql_DataArea.Append("'"); Sql_DataArea.Append("Update sys_biz_DataArea Set Scts_1=Getdate(),Scdel=1 Where SheetID ='"); Sql_DataArea.Append(Sheet.Index); Sql_DataArea.Append("' and TableName='"); Sql_DataArea.Append(Sheet.DataTableSchema.Schema.Name); Sql_DataArea.Append("'"); } StringBuilder Sql_Column = new StringBuilder(); if (Sheet.DataTableSchema.Schema != null) { //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,便于数据同步 2013-10-17 //Sql_Column.Append("Delete From sys_columns Where TableName='"); //Sql_Column.Append(Sheet.DataTableSchema.Schema.Name); //Sql_Column.Append("'"); Sql_Column.Append("Update sys_columns Set Scts_1=Getdate(),Scdel=1 Where TableName='"); Sql_Column.Append(Sheet.DataTableSchema.Schema.Name); Sql_Column.Append("'"); } StringBuilder Sql_SheetDrop = new StringBuilder(); if (Sheet.DataTableSchema.Schema != null) { Sql_SheetDrop.Append("drop table [" + Sheet.DataTableSchema.Schema.Name + "]"); } List <string> sql_Commands = new List <string>(); sql_Commands.Add(Sql_Sheet.ToString()); if (Sheet.DataTableSchema.Schema != null) { sql_Commands.Add(Sql_DataArea.ToString()); sql_Commands.Add(Sql_Column.ToString()); sql_Commands.Add(Sql_SheetDrop.ToString()); } Boolean Result = false; IDbConnection Connection = GetConntion(); Transaction Transaction = new Transaction(Connection); try { object r = ExcuteCommands(sql_Commands.ToArray(), Transaction); int[] ints = (int[])r; for (int i = 0; i < ints.Length; i++) { if (i != 0) { Result = Result & (Convert.ToInt32(ints[i]) == 1); } else { Result = (Convert.ToInt32(ints[i]) == 1); } } if (Result) { Transaction.Commit(); } else { Transaction.Rollback(); } } catch { Transaction.Rollback(); } if (Sheet.DataTableSchema.Schema != null) { Result = Result & DataSchemaManager.DeleteTableStruct(Sheet.DataTableSchema.Schema.Name); } return(Result); }
public bool UpdateSheetConfiguration(SheetConfiguration Sheet) { Boolean Result = false; StringBuilder Sql_Sheets = new StringBuilder(); //2013-10-17 增加查询条件 Scdel=0 0未删除 1已删除 Sql_Sheets.Append("Select ID,SCTS,CatlogCode,Description,SheetStyle,DataTable,SCTS_1,Scdel From sys_biz_Sheet Where Scdel=0 and ID='"); Sql_Sheets.Append(Sheet.Index); Sql_Sheets.Append("'"); StringBuilder Sql_DataAreas = new StringBuilder(); //2013-10-17 增加查询条件 Scdel=0 0未删除 1已删除 Sql_DataAreas.Append("Select ID,SCTS,SheetID,TableName,ColumnName,Range,SCTS_1,Scdel From sys_biz_DataArea Where Scdel=0 and SheetID='"); Sql_DataAreas.Append(Sheet.Index); Sql_DataAreas.Append("'"); List <string> sql_Commands = new List <string>(); sql_Commands.Add(Sql_Sheets.ToString()); sql_Commands.Add(Sql_DataAreas.ToString()); DataSet dataset = GetDataSet(sql_Commands.ToArray()); if (dataset != null) { DataTable DataSheets = dataset.Tables["sys_biz_Sheet"]; DataTable DataAreas = dataset.Tables["sys_biz_DataArea"]; if (DataSheets != null) { if (DataSheets.Rows.Count > 0) { DataRow SheetRow = DataSheets.Rows[0]; SheetRow["ID"] = Sheet.Index; SheetRow["SCTS"] = DateTime.Now.ToString(); SheetRow["CatlogCode"] = Sheet.Code; SheetRow["Description"] = Sheet.Description; SheetRow["SheetStyle"] = Sheet.SheetStyle; SheetRow["SCTS_1"] = DateTime.Now.ToString(); if (Sheet.DataTableSchema.Schema != null) { foreach (FieldDefineInfo fieldInfo in Sheet.DataTableSchema.Schema.FieldInfos) { DataRow[] AreaRows = DataAreas.Select("SheetID='" + Sheet.Index + "' and TableName='" + Sheet.DataTableSchema.Schema.Name + "' and ColumnName='" + fieldInfo.FieldName + "'"); if (AreaRows.Length > 0) { AreaRows[0]["SheetID"] = Sheet.Index; AreaRows[0]["SCTS"] = DateTime.Now.ToString(); AreaRows[0]["TableName"] = Sheet.DataTableSchema.Schema.Name; AreaRows[0]["ColumnName"] = fieldInfo.FieldName; AreaRows[0]["Range"] = fieldInfo.RangeInfo; AreaRows[0]["SCTS_1"] = DateTime.Now.ToString(); } else { DataRow AreaRow = DataAreas.NewRow(); AreaRow["ID"] = Guid.NewGuid().ToString(); AreaRow["SCTS"] = DateTime.Now.ToString(); AreaRow["SheetID"] = Sheet.Index; AreaRow["TableName"] = Sheet.DataTableSchema.Schema.Name; AreaRow["ColumnName"] = fieldInfo.FieldName; AreaRow["Range"] = fieldInfo.RangeInfo; AreaRows[0]["SCTS_1"] = DateTime.Now.ToString(); DataAreas.Rows.Add(AreaRow); } } SheetRow["DataTable"] = Sheet.DataTableSchema.Schema.Name; } else { SheetRow["DataTable"] = ""; } } else { DataRow SheetRow = DataSheets.NewRow(); SheetRow["ID"] = Sheet.Index; SheetRow["SCTS"] = DateTime.Now.ToString(); SheetRow["CatlogCode"] = Sheet.Code; SheetRow["Description"] = Sheet.Description; SheetRow["SheetStyle"] = Sheet.SheetStyle; SheetRow["SCTS_1"] = DateTime.Now.ToString(); if (Sheet.DataTableSchema.Schema != null) { foreach (FieldDefineInfo fieldInfo in Sheet.DataTableSchema.Schema.FieldInfos) { DataRow[] AreaRows = DataAreas.Select("SheetID='" + Sheet.Index + "' and TableName='" + Sheet.DataTableSchema.Schema.Name + "' and ColumnName='" + fieldInfo.FieldName + "'"); if (AreaRows.Length > 0) { AreaRows[0]["SheetID"] = Sheet.Index; AreaRows[0]["SCTS"] = DateTime.Now.ToString(); AreaRows[0]["TableName"] = Sheet.DataTableSchema.Schema.Name; AreaRows[0]["ColumnName"] = fieldInfo.FieldName; AreaRows[0]["Range"] = fieldInfo.RangeInfo; AreaRows[0]["SCTS_1"] = DateTime.Now.ToString(); } else { DataRow AreaRow = DataAreas.NewRow(); AreaRow["ID"] = Guid.NewGuid().ToString(); AreaRow["SCTS"] = DateTime.Now.ToString(); AreaRow["SheetID"] = Sheet.Index; AreaRow["TableName"] = Sheet.DataTableSchema.Schema.Name; AreaRow["ColumnName"] = fieldInfo.FieldName; AreaRow["Range"] = fieldInfo.RangeInfo; AreaRows[0]["SCTS_1"] = DateTime.Now.ToString(); DataAreas.Rows.Add(AreaRow); } } SheetRow["DataTable"] = Sheet.DataTableSchema.Schema.Name; } else { SheetRow["DataTable"] = ""; } DataSheets.Rows.Add(SheetRow); } } IDbConnection Connection = GetConntion(); Transaction Transaction = new Transaction(Connection); try { object r = Update(dataset, Transaction); Result = (Convert.ToInt32(r) == 1); if (Result) { Transaction.Commit(); } else { Transaction.Rollback(); } } catch { Transaction.Rollback(); } } return(Result); }
public List <SheetConfiguration> InitSheetConfiguration(string[] Indexes) { SheetConfiguration[] Configurations = new SheetConfiguration[Indexes.Length]; StringBuilder Sql_Sheets = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_Sheets.Append("Select ID,Description,CatlogCode,SheetStyle,DataTable from sys_biz_Sheet where Scdel=0 and ID in ('"); Sql_Sheets.Append(string.Join("','", Indexes)); Sql_Sheets.Append("')"); StringBuilder Sql_Tables = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_Tables.Append("Select * from sys_Tables where Scdel=0 and TableName in ("); Sql_Tables.Append("Select DataTable from sys_biz_Sheet where Scdel=0 and ID in ('"); Sql_Tables.Append(string.Join("','", Indexes)); Sql_Tables.Append("'))"); StringBuilder Sql_FieldInfos = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_FieldInfos.Append("Select * from sys_Columns where Scdel=0 and TableName in ("); Sql_FieldInfos.Append("Select DataTable from sys_biz_Sheet where Scdel=0 and ID in ('"); Sql_FieldInfos.Append(string.Join("','", Indexes)); Sql_FieldInfos.Append("'))"); Sql_FieldInfos.Append(" order by scts"); StringBuilder Sql_DataAreas = new StringBuilder(); //增加查询条件Scdel=0 2013-10-19 Sql_DataAreas.Append("Select SheetID,TableName,ColumnName,Range From sys_biz_DataArea Where Scdel=0 and SheetID in ('"); Sql_DataAreas.Append(string.Join("','", Indexes)); Sql_DataAreas.Append("')"); List <string> sql_Commands = new List <string>(); sql_Commands.Add(Sql_Sheets.ToString()); sql_Commands.Add(Sql_Tables.ToString()); sql_Commands.Add(Sql_FieldInfos.ToString()); sql_Commands.Add(Sql_DataAreas.ToString()); DataSet dataset = GetDataSet(sql_Commands.ToArray()); if (dataset != null) { DataTable DataSheets = dataset.Tables["sys_biz_Sheet"]; DataTable DataTables = dataset.Tables["sys_Tables"]; DataTable DataFields = dataset.Tables["sys_Columns"]; DataTable DataAreas = dataset.Tables["sys_biz_DataArea"]; foreach (DataRow SheetRow in DataSheets.Rows) { SheetConfiguration Configuration = new SheetConfiguration(); Configuration.Index = SheetRow["ID"].ToString(); Configuration.Code = SheetRow["CatlogCode"].ToString(); Configuration.SheetStyle = SheetRow["SheetStyle"].ToString(); Configuration.Description = SheetRow["Description"].ToString(); string DataTable = SheetRow["DataTable"].ToString(); if (!string.IsNullOrEmpty(DataTable)) { DataRow[] TableRows = DataTables.Select("TableName = '" + DataTable + "'"); if (TableRows.Length > 0) { Configuration.DataTableSchema.Schema = new TableDefineInfo(); Configuration.DataTableSchema.Schema.Name = DataTable; Configuration.DataTableSchema.Schema.Description = TableRows[0]["DESCRIPTION"].ToString(); Configuration.DataTableSchema.Schema.Index = TableRows[0]["ID"].ToString(); DataRow[] FieldRows = DataFields.Select("TableName = '" + DataTable + "'", "colname"); foreach (DataRow FieldRow in FieldRows) { FieldDefineInfo FieldInfo = new FieldDefineInfo(Configuration.DataTableSchema.Schema); FieldInfo.Index = FieldRow["ID"].ToString(); FieldInfo.Description = FieldRow["DESCRIPTION"].ToString(); FieldInfo.FieldName = FieldRow["COLNAME"].ToString(); FieldInfo.IsKeyField = (FieldRow["IsKeyField"] != DBNull.Value ? Convert.ToBoolean(FieldRow["IsKeyField"]) : false); String scpt = FieldRow["scpt"].ToString(); FieldInfo.IsNotNull = ((scpt.Length > 0 ? scpt.Substring(0, 1) : "0") == "1" ? true : false); FieldInfo.IsNotCopy = ((scpt.Length > 1 ? scpt.Substring(1, 1) : "0") == "1" ? true : false); FieldInfo.IsPingxing = ((scpt.Length > 2 ? scpt.Substring(2, 1) : "0") == "1" ? true : false); FieldInfo.IsReadOnly = ((scpt.Length > 3 ? scpt.Substring(3, 1) : "0") == "1" ? true : false); String ColType = FieldRow["COLType"].ToString(); FieldInfo.FieldType = FieldType.GetFieldType(ColType); DataRow[] dataAreas = DataAreas.Select("SheetID='" + Configuration.Index + "' and TableName='" + DataTable + "' and ColumnName='" + FieldInfo.FieldName + "'"); if (dataAreas.Length > 0) { FieldInfo.RangeInfo = dataAreas[0]["Range"].ToString(); } } } } int Index = Array.IndexOf(Indexes, Configuration.Index); Configurations[Index] = Configuration; } } return(new List <SheetConfiguration>(Configurations)); }
private void ButtonOk_Click(object sender, EventArgs e) { if (modelInfo == null) { return; } modelIndex = modelInfo.Index; modelText = modelInfo.Description; ModelFields.Clear(); if (CheckBox_ModelIndex.Checked) { ModelFields.Add(string.Concat("'", modelIndex, "'")); } if (CheckBox_ModelName.Checked) { ModelFields.Add(string.Concat("'", modelText, "'")); } if (CheckBox_SCTS.Checked) { ModelFields.Add(string.Concat("biz_norm_extent_", modelIndex, ".SCTS")); } if (CheckBox_SCPT.Checked) { ModelFields.Add(string.Concat("biz_norm_extent_", modelIndex, ".SCPT")); } if (CheckBox_SCCT.Checked) { ModelFields.Add(string.Concat("biz_norm_extent_", modelIndex, ".SCCT")); } foreach (SheetView Sheet in FpSpread.Sheets) { if (Sheet.Tag is SheetConfiguration) { SheetConfiguration sheetConfiguration = Sheet.Tag as SheetConfiguration; TableDefineInfo TableSchema = sheetConfiguration.DataTableSchema.Schema; if (TableSchema != null) { foreach (FieldDefineInfo FieldInfo in TableSchema.FieldInfos) { if (Sheet.Cells[FieldInfo.RangeInfo].BackColor == Color.Blue) { ModelFields.Add(string.Concat("[", TableSchema.Name, "].[", FieldInfo.FieldName, "]")); } } } } else { foreach (Row Row in Sheet.Rows) { if (Row.BackColor == Color.Blue) { ModelFields.Add(string.Concat("[", Sheet.Tag.ToString(), "].[", Sheet.Cells[Row.Index, 0].Text, "]")); } } } } this.DialogResult = DialogResult.OK; Close(); }