public static ModuleConfiguration InitModuleConfiguration(string Index)
{
ModuleConfiguration Model = Agent.CallLocalService("Yqun.BO.BusinessManager.dll", "InitModuleConfiguration", new object[] { Index }) as ModuleConfiguration;
Hashtable Infos = DepositoryModuleConfiguration.InitModelTableInfo(Index);
foreach (SheetConfiguration sheet in Model.Sheets)
{
sheet.DataTableSchema.Schema = Infos[sheet.Index] as TableDefineInfo;
}
return(Model);
}
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);
}
public static Boolean UpdateCache(String ModelIndex)
{
Boolean Result = false;
List <string> CacheTableNames = new List <string>();
CacheTableNames.Add("sys_columns");
List <IndexDescriptionPair> SheetList = DepositoryModuleConfiguration.InitModuleInfo(ModelIndex);
List <string> DataTables = new List <string>();
foreach (IndexDescriptionPair pair in SheetList)
{
DataTables.Add(pair.DataTable);
}
List <string> Wheres = new List <string>();
if (DataTables.Count > 0)
{
Wheres.Add("where TableName in ('" + string.Join("','", DataTables.ToArray()) + "')");
}
else
{
Wheres.Add("where 1<> 1");
}
foreach (string TableName in CacheTableNames)
{
int index = CacheTableNames.IndexOf(TableName);
string where = Wheres[index];
List <String> IDList = GetNewTableIDList(TableName, where);
List <String> ExistingIDList = GetExistingTableIDList(TableName, where);
Result = ExecuteDeletedCommand(TableName, IDList, ExistingIDList);
Result = Result & ExecuteUpdateCommand(TableName, IDList, ExistingIDList);
}
return(Result);
}
public static Boolean HaveModuleConfiguration(string Index)
{
return(DepositoryModuleConfiguration.HaveModuleConfiguration(Index));
}
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);
}
}