public static bool Delete(string Code) { StringBuilder Sql_Select = new StringBuilder(); //增加字段Scdel=0 2013-10-19 Sql_Select.Append("Select * From sys_biz_Module 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(); ModuleConfiguration Configuration = DepositoryModuleConfiguration.InitModuleConfiguration(Index); DepositoryModuleConfiguration.Delete(Configuration); } } //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,便于数据同步 2013-10-15 StringBuilder Sql_Delete = new StringBuilder(); //Sql_Delete.Append("Delete From sys_biz_ModuleCatlog Where CatlogCode like '"); //Sql_Delete.Append(Code); //Sql_Delete.Append("%'"); Sql_Delete.Append("Update sys_biz_ModuleCatlog 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 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); } }