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