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); } }