public ProgramBuilderCache GetSet(Guid id)
{
object obj = Opation.Get(15.ToString() + id.ToString("N"));
if (obj != null)
{
return((ProgramBuilderCache)obj);
}
ProgramBuilderCache programBuilderCache = new ProgramBuilderCache();
RoadFlow.Data.Model.ProgramBuilder programBuilder = Get(id);
if (programBuilder == null)
{
return(null);
}
programBuilderCache.Program = programBuilder;
programBuilderCache.Fields = (from p in new ProgramBuilderFields().GetAll(id)
orderby p.Sort
select p).ToList();
programBuilderCache.Querys = (from p in new ProgramBuilderQuerys().GetAll(id)
orderby p.Sort
select p).ToList();
programBuilderCache.Buttons = (from p in new ProgramBuilderButtons().GetAll(id)
orderby p.Sort
select p).ToList();
programBuilderCache.Validates = new ProgramBuilderValidates().GetAll(id);
programBuilderCache.Export = (from p in new ProgramBuilderExport().GetAll(id)
orderby p.Sort
select p).ToList();
AddToCache(programBuilderCache);
return(programBuilderCache);
}
public string GetQueryButtonHtml(RoadFlow.Data.Model.ProgramBuilder pb)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<input type=\"submit\" name=\"searchbutton\" value=\" 查 询 \" class=\"mybutton\"/>");
return(stringBuilder.ToString());
}
public List <string> GetFields(Guid id)
{
RoadFlow.Data.Model.ProgramBuilder programBuilder = this.Get(id);
if (programBuilder == null)
{
return(new List <string>());
}
return(new DBConnection().GetFieldsBySQL(programBuilder.DBConnID, programBuilder.SQL));
}
public void DeleteAllSet(Guid id)
{
RoadFlow.Data.Model.ProgramBuilder programBuilder = Get(id);
if (programBuilder != null)
{
programBuilder.Status = 2;
Update(programBuilder);
Log.Add("删除了应用程序设计", id.ToString());
}
}
public void DeleteAllSet(Guid id)
{
RoadFlow.Data.Model.ProgramBuilder model = this.Get(id);
if (model == null)
{
return;
}
model.Status = 2;
this.Update(model);
Log.Add("删除了应用程序设计", id.ToString(), Log.Types.其它分类, "", "", (RoadFlow.Data.Model.Users)null);
}
public ProgramBuilderCache GetSet(Guid id)
{
object obj = Opation.Get(Keys.CacheKeys.ProgramBuilder.ToString() + id.ToString("N"));
if (obj != null)
{
return((ProgramBuilderCache)obj);
}
ProgramBuilderCache pb = new ProgramBuilderCache();
RoadFlow.Data.Model.ProgramBuilder programBuilder = this.Get(id);
if (programBuilder == null)
{
return((ProgramBuilderCache)null);
}
pb.Program = programBuilder;
pb.Fields = new ProgramBuilderFields().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderFields, int>((Func <RoadFlow.Data.Model.ProgramBuilderFields, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderFields>();
pb.Querys = new ProgramBuilderQuerys().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderQuerys, int>((Func <RoadFlow.Data.Model.ProgramBuilderQuerys, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderQuerys>();
pb.Buttons = new ProgramBuilderButtons().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderButtons, int>((Func <RoadFlow.Data.Model.ProgramBuilderButtons, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderButtons>();
pb.Validates = new ProgramBuilderValidates().GetAll(id);
pb.Export = new ProgramBuilderExport().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderExport, int>((Func <RoadFlow.Data.Model.ProgramBuilderExport, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderExport>();
this.AddToCache(pb);
return(pb);
}
public int InDataFormExcel(Guid programID, string table, string file, out string msg, string numberFiled = "")
{
int num = 0;
msg = "";
if (table.IsNullOrEmpty())
{
msg = "没有选择表";
return(num);
}
DBConnection dbConnection = new DBConnection();
RoadFlow.Data.Model.ProgramBuilder programBuilder = this.Get(programID);
if (programBuilder == null)
{
msg = "未找到应用程序设计";
return(num);
}
RoadFlow.Data.Model.DBConnection conn = dbConnection.Get(programBuilder.DBConnID, true);
if (conn == null)
{
msg = "未找到相应的数据库连接";
return(num);
}
List <RoadFlow.Data.Model.ProgramBuilderFields> all = new ProgramBuilderFields().GetAll(programID);
if (all.Count == 0)
{
msg = "应用程序未设置列表字段";
return(num);
}
try
{
DataTable dataTable = NPOIHelper.ReadToDataTable(file, 1);
if (dataTable.Rows.Count == 0)
{
msg = "未发现要导入的数据";
return(num);
}
List <string> fieldsBySql = dbConnection.GetFieldsBySQL(programBuilder.DBConnID, "select * from " + table + " where 1=0");
DataTable dt = new DataTable(table);
string str = DateTimeNew.Now.ToString("yyyyMMddHHmmssfffff");
foreach (RoadFlow.Data.Model.ProgramBuilderFields programBuilderFields in all)
{
RoadFlow.Data.Model.ProgramBuilderFields filed = programBuilderFields;
if (!filed.Field.IsNullOrEmpty() && fieldsBySql.Find((Predicate <string>)(p => p.Equals(filed.Field, StringComparison.CurrentCultureIgnoreCase))) != null)
{
dt.Columns.Add(filed.Field);
}
}
if (!numberFiled.IsNullOrEmpty())
{
dt.Columns.Add(numberFiled);
}
foreach (DataRow row1 in (InternalDataCollectionBase)dataTable.Rows)
{
DataRow row2 = dt.NewRow();
foreach (DataColumn column in (InternalDataCollectionBase)dt.Columns)
{
DataColumn col = column;
RoadFlow.Data.Model.ProgramBuilderFields programBuilderFields = all.Find((Predicate <RoadFlow.Data.Model.ProgramBuilderFields>)(p => p.Field.Equals(col.ColumnName)));
if (programBuilderFields != null)
{
row2[col.ColumnName] = row1[programBuilderFields.ShowTitle];
}
}
if (!numberFiled.IsNullOrEmpty())
{
row2[numberFiled] = (object)str;
}
dt.Rows.Add(row2);
}
num = dbConnection.DataTableToDB(conn, dt);
Log.Add("通过应用程序导入了数据-表(" + table + ")标识(" + str + ")", file, Log.Types.其它分类, "", "", (RoadFlow.Data.Model.Users)null);
return(num);
}
catch (Exception ex)
{
msg = ex.Message;
return(num);
}
}
public int Update(RoadFlow.Data.Model.ProgramBuilder model)
{
return(this.dataProgramBuilder.Update(model));
}
public int Add(RoadFlow.Data.Model.ProgramBuilder model)
{
return(this.dataProgramBuilder.Add(model));
}
public bool Publish(Guid id, bool isMvc = false)
{
RoadFlow.Data.Model.ProgramBuilder model1 = this.Get(id);
if (model1 == null || model1.Name.IsNullOrEmpty() || model1.SQL.IsNullOrEmpty())
{
return(false);
}
AppLibrary appLibrary = new AppLibrary();
RoadFlow.Data.Model.AppLibrary model2 = appLibrary.GetByCode(id.ToString(), true);
bool flag1 = false;
using (TransactionScope transactionScope = new TransactionScope())
{
if (model2 == null)
{
flag1 = true;
model2 = new RoadFlow.Data.Model.AppLibrary();
model2.ID = Guid.NewGuid();
}
model2.Address = !isMvc ? "/Platform/ProgramBuilder/Run.aspx?programid=" + id.ToString() : "/ProgramBuilder/Run?programid=" + id.ToString();
model2.Code = id.ToString();
model2.OpenMode = 0;
model2.Title = model1.Name;
model2.Type = model1.Type;
if (flag1)
{
appLibrary.Add(model2);
}
else
{
appLibrary.Update(model2);
}
model1.Status = 1;
this.Update(model1);
List <RoadFlow.Data.Model.ProgramBuilderButtons> all = new ProgramBuilderButtons().GetAll(model1.ID);
AppLibraryButtons1 appLibraryButtons1_1 = new AppLibraryButtons1();
List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppId = appLibraryButtons1_1.GetAllByAppID(model2.ID);
List <RoadFlow.Data.Model.AppLibraryButtons1> appLibraryButtons1List = new List <RoadFlow.Data.Model.AppLibraryButtons1>();
foreach (RoadFlow.Data.Model.ProgramBuilderButtons programBuilderButtons in all)
{
RoadFlow.Data.Model.ProgramBuilderButtons button = programBuilderButtons;
RoadFlow.Data.Model.AppLibraryButtons1 model3 = allByAppId.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == button.ID));
bool flag2 = false;
if (model3 == null)
{
model3 = new RoadFlow.Data.Model.AppLibraryButtons1();
flag2 = true;
}
model3.AppLibraryID = model2.ID;
model3.ButtonID = button.ButtonID;
model3.Events = button.ClientScript;
model3.Ico = button.Ico ?? "";
model3.ID = button.ID;
model3.Name = button.ButtonName;
model3.ShowType = button.ShowType;
model3.Sort = button.Sort;
model3.Type = 0;
model3.IsValidateShow = button.IsValidateShow;
if (flag2)
{
appLibraryButtons1_1.Add(model3);
}
else
{
appLibraryButtons1_1.Update(model3);
}
appLibraryButtons1List.Add(model3);
}
foreach (RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons1_2 in allByAppId)
{
RoadFlow.Data.Model.AppLibraryButtons1 button = appLibraryButtons1_2;
if (appLibraryButtons1List.Find((Predicate <RoadFlow.Data.Model.AppLibraryButtons1>)(p => p.ID == button.ID)) == null)
{
appLibraryButtons1_1.Delete(button.ID);
}
}
transactionScope.Complete();
}
new AppLibrary().ClearCache();
new Menu().ClearAllDataTableCache();
new AppLibraryButtons1().ClearCache();
new AppLibrarySubPages().ClearCache();
this.AddToCache(new ProgramBuilderCache()
{
Program = model1,
Fields = new ProgramBuilderFields().GetAll(model1.ID).OrderBy <RoadFlow.Data.Model.ProgramBuilderFields, int>((Func <RoadFlow.Data.Model.ProgramBuilderFields, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderFields>(),
Querys = new ProgramBuilderQuerys().GetAll(model1.ID).OrderBy <RoadFlow.Data.Model.ProgramBuilderQuerys, int>((Func <RoadFlow.Data.Model.ProgramBuilderQuerys, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderQuerys>(),
Buttons = new ProgramBuilderButtons().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderButtons, int>((Func <RoadFlow.Data.Model.ProgramBuilderButtons, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderButtons>(),
Validates = new ProgramBuilderValidates().GetAll(id),
Export = new ProgramBuilderExport().GetAll(id).OrderBy <RoadFlow.Data.Model.ProgramBuilderExport, int>((Func <RoadFlow.Data.Model.ProgramBuilderExport, int>)(p => p.Sort)).ToList <RoadFlow.Data.Model.ProgramBuilderExport>()
});
return(true);
}
private List <RoadFlow.Data.Model.ProgramBuilder> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.ProgramBuilder> list = new List <RoadFlow.Data.Model.ProgramBuilder>();
RoadFlow.Data.Model.ProgramBuilder programBuilder = null;
while (dataReader.Read())
{
programBuilder = new RoadFlow.Data.Model.ProgramBuilder();
programBuilder.ID = dataReader.GetGuid(0);
programBuilder.Name = dataReader.GetString(1);
programBuilder.Type = dataReader.GetGuid(2);
programBuilder.CreateTime = dataReader.GetDateTime(3);
if (!dataReader.IsDBNull(4))
{
programBuilder.PublishTime = dataReader.GetDateTime(4);
}
programBuilder.CreateUser = dataReader.GetGuid(5);
programBuilder.SQL = dataReader.GetString(6);
programBuilder.IsAdd = dataReader.GetInt32(7);
programBuilder.DBConnID = dataReader.GetGuid(8);
programBuilder.Status = dataReader.GetInt32(9);
if (!dataReader.IsDBNull(10))
{
programBuilder.FormID = dataReader.GetString(10);
}
if (!dataReader.IsDBNull(11))
{
programBuilder.EditModel = dataReader.GetInt32(11);
}
if (!dataReader.IsDBNull(12))
{
programBuilder.Width = dataReader.GetString(12);
}
if (!dataReader.IsDBNull(13))
{
programBuilder.Height = dataReader.GetString(13);
}
if (!dataReader.IsDBNull(14))
{
programBuilder.ButtonLocation = dataReader.GetInt32(14);
}
if (!dataReader.IsDBNull(15))
{
programBuilder.IsPager = dataReader.GetInt32(15);
}
if (!dataReader.IsDBNull(16))
{
programBuilder.ClientScript = dataReader.GetString(16);
}
if (!dataReader.IsDBNull(17))
{
programBuilder.ExportTemplate = dataReader.GetString(17);
}
if (!dataReader.IsDBNull(18))
{
programBuilder.ExportHeaderText = dataReader.GetString(18);
}
if (!dataReader.IsDBNull(19))
{
programBuilder.ExportFileName = dataReader.GetString(19);
}
if (!dataReader.IsDBNull(20))
{
programBuilder.TableStyle = dataReader.GetString(20);
}
if (!dataReader.IsDBNull(21))
{
programBuilder.TableHead = dataReader.GetString(21);
}
if (!dataReader.IsDBNull(22))
{
programBuilder.TableName = dataReader.GetString(22);
}
if (!dataReader.IsDBNull(23))
{
programBuilder.InDataNumberFiledName = dataReader.GetString(23);
}
list.Add(programBuilder);
}
return(list);
}
public int Update(RoadFlow.Data.Model.ProgramBuilder model)
{
string sql = "UPDATE ProgramBuilder SET \r\n\t\t\t\tName=@Name,Type=@Type,CreateTime=@CreateTime,PublishTime=@PublishTime,CreateUser=@CreateUser,SQL=@SQL,IsAdd=@IsAdd,DBConnID=@DBConnID,Status=@Status,FormID=@FormID,EditModel=@EditModel,Width=@Width,Height=@Height,ButtonLocation=@ButtonLocation,IsPager=@IsPager,ClientScript=@ClientScript,ExportTemplate=@ExportTemplate,ExportHeaderText=@ExportHeaderText,ExportFileName=@ExportFileName,TableStyle=@TableStyle,TableHead=@TableHead,TableName=@TableName,InDataNumberFiledName=@InDataNumberFiledName \r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] parameter = new SqlParameter[24]
{
new SqlParameter("@Name", SqlDbType.NVarChar, 1000)
{
Value = model.Name
},
new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1)
{
Value = model.Type
},
new SqlParameter("@CreateTime", SqlDbType.DateTime, 8)
{
Value = model.CreateTime
},
(!model.PublishTime.HasValue) ? new SqlParameter("@PublishTime", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@PublishTime", SqlDbType.DateTime, 8)
{
Value = model.PublishTime
},
new SqlParameter("@CreateUser", SqlDbType.UniqueIdentifier, -1)
{
Value = model.CreateUser
},
new SqlParameter("@SQL", SqlDbType.VarChar, -1)
{
Value = model.SQL
},
new SqlParameter("@IsAdd", SqlDbType.Int, -1)
{
Value = model.IsAdd
},
new SqlParameter("@DBConnID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.DBConnID
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
(model.FormID == null) ? new SqlParameter("@FormID", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@FormID", SqlDbType.VarChar, 500)
{
Value = model.FormID
},
(!model.EditModel.HasValue) ? new SqlParameter("@EditModel", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@EditModel", SqlDbType.Int, -1)
{
Value = model.EditModel
},
(model.Width == null) ? new SqlParameter("@Width", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@Width", SqlDbType.VarChar, 50)
{
Value = model.Width
},
(model.Height == null) ? new SqlParameter("@Height", SqlDbType.VarChar, 50)
{
Value = DBNull.Value
} : new SqlParameter("@Height", SqlDbType.VarChar, 50)
{
Value = model.Height
},
(!model.ButtonLocation.HasValue) ? new SqlParameter("@ButtonLocation", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@ButtonLocation", SqlDbType.Int, -1)
{
Value = model.ButtonLocation
},
(!model.IsPager.HasValue) ? new SqlParameter("@IsPager", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@IsPager", SqlDbType.Int, -1)
{
Value = model.IsPager
},
(model.ClientScript == null) ? new SqlParameter("@ClientScript", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@ClientScript", SqlDbType.VarChar, -1)
{
Value = model.ClientScript
},
(model.ExportTemplate == null) ? new SqlParameter("@ExportTemplate", SqlDbType.VarChar, 4000)
{
Value = DBNull.Value
} : new SqlParameter("@ExportTemplate", SqlDbType.VarChar, 4000)
{
Value = model.ExportTemplate
},
(model.ExportHeaderText == null) ? new SqlParameter("@ExportHeaderText", SqlDbType.NVarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@ExportHeaderText", SqlDbType.NVarChar, 1000)
{
Value = model.ExportHeaderText
},
(model.ExportFileName == null) ? new SqlParameter("@ExportFileName", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@ExportFileName", SqlDbType.VarChar, 500)
{
Value = model.ExportFileName
},
(model.TableStyle == null) ? new SqlParameter("@TableStyle", SqlDbType.VarChar, 255)
{
Value = DBNull.Value
} : new SqlParameter("@TableStyle", SqlDbType.VarChar, 255)
{
Value = model.TableStyle
},
(model.TableHead == null) ? new SqlParameter("@TableHead", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@TableHead", SqlDbType.VarChar, -1)
{
Value = model.TableHead
},
(model.TableName == null) ? new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = model.TableName
},
(model.InDataNumberFiledName == null) ? new SqlParameter("@InDataNumberFiledName", SqlDbType.VarChar, 500)
{
Value = DBNull.Value
} : new SqlParameter("@InDataNumberFiledName", SqlDbType.VarChar, 500)
{
Value = model.InDataNumberFiledName
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameter));
}
public int InDataFormExcel(Guid programID, string table, string file, out string msg, string numberFiled = "")
{
int result = 0;
msg = "";
if (table.IsNullOrEmpty())
{
msg = "没有选择表";
return(result);
}
DBConnection dBConnection = new DBConnection();
RoadFlow.Data.Model.ProgramBuilder programBuilder = Get(programID);
if (programBuilder == null)
{
msg = "未找到应用程序设计";
return(result);
}
RoadFlow.Data.Model.DBConnection dBConnection2 = dBConnection.Get(programBuilder.DBConnID);
if (dBConnection2 == null)
{
msg = "未找到相应的数据库连接";
return(result);
}
List <RoadFlow.Data.Model.ProgramBuilderFields> all = new ProgramBuilderFields().GetAll(programID);
if (all.Count != 0)
{
try
{
DataTable dataTable = NPOIHelper.ReadToDataTable(file);
if (dataTable.Rows.Count == 0)
{
msg = "未发现要导入的数据";
return(result);
}
List <string> fieldsBySQL = dBConnection.GetFieldsBySQL(programBuilder.DBConnID, "select * from " + table + " where 1=0");
DataTable dataTable2 = new DataTable(table);
string text = DateTimeNew.Now.ToString("yyyyMMddHHmmssfffff");
foreach (RoadFlow.Data.Model.ProgramBuilderFields item in all)
{
if (!item.Field.IsNullOrEmpty() && fieldsBySQL.Find((string p) => p.Equals(item.Field, StringComparison.CurrentCultureIgnoreCase)) != null)
{
dataTable2.Columns.Add(item.Field);
}
}
if (!numberFiled.IsNullOrEmpty())
{
dataTable2.Columns.Add(numberFiled);
}
foreach (DataRow row in dataTable.Rows)
{
DataRow dataRow2 = dataTable2.NewRow();
foreach (DataColumn column in dataTable2.Columns)
{
RoadFlow.Data.Model.ProgramBuilderFields programBuilderFields = all.Find((RoadFlow.Data.Model.ProgramBuilderFields p) => p.Field.Equals(column.ColumnName));
if (programBuilderFields != null)
{
dataRow2[column.ColumnName] = row[programBuilderFields.ShowTitle];
}
}
if (!numberFiled.IsNullOrEmpty())
{
dataRow2[numberFiled] = text;
}
dataTable2.Rows.Add(dataRow2);
}
result = dBConnection.DataTableToDB(dBConnection2, dataTable2);
Log.Add("通过应用程序导入了数据-表(" + table + ")标识(" + text + ")", file);
return(result);
}
catch (Exception ex)
{
msg = ex.Message;
return(result);
}
}
msg = "应用程序未设置列表字段";
return(result);
}
public bool Publish(Guid id, bool isMvc = false)
{
RoadFlow.Data.Model.ProgramBuilder programBuilder = Get(id);
if (programBuilder == null || programBuilder.Name.IsNullOrEmpty() || programBuilder.SQL.IsNullOrEmpty())
{
return(false);
}
AppLibrary appLibrary = new AppLibrary();
RoadFlow.Data.Model.AppLibrary appLibrary2 = appLibrary.GetByCode(id.ToString());
bool flag = false;
using (TransactionScope transactionScope = new TransactionScope())
{
if (appLibrary2 == null)
{
flag = true;
appLibrary2 = new RoadFlow.Data.Model.AppLibrary();
appLibrary2.ID = Guid.NewGuid();
}
appLibrary2.Address = ((!isMvc) ? ("/Platform/ProgramBuilder/Run.aspx?programid=" + id.ToString()) : ("/ProgramBuilder/Run?programid=" + id.ToString()));
appLibrary2.Code = id.ToString();
appLibrary2.OpenMode = 0;
appLibrary2.Title = programBuilder.Name;
appLibrary2.Type = programBuilder.Type;
if (flag)
{
appLibrary.Add(appLibrary2);
}
else
{
appLibrary.Update(appLibrary2);
}
programBuilder.Status = 1;
Update(programBuilder);
List <RoadFlow.Data.Model.ProgramBuilderButtons> all = new ProgramBuilderButtons().GetAll(programBuilder.ID);
AppLibraryButtons1 appLibraryButtons = new AppLibraryButtons1();
List <RoadFlow.Data.Model.AppLibraryButtons1> allByAppID = appLibraryButtons.GetAllByAppID(appLibrary2.ID);
List <RoadFlow.Data.Model.AppLibraryButtons1> list = new List <RoadFlow.Data.Model.AppLibraryButtons1>();
foreach (RoadFlow.Data.Model.ProgramBuilderButtons item in all)
{
RoadFlow.Data.Model.AppLibraryButtons1 appLibraryButtons2 = allByAppID.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == item.ID);
bool flag2 = false;
if (appLibraryButtons2 == null)
{
appLibraryButtons2 = new RoadFlow.Data.Model.AppLibraryButtons1();
flag2 = true;
}
appLibraryButtons2.AppLibraryID = appLibrary2.ID;
appLibraryButtons2.ButtonID = item.ButtonID;
appLibraryButtons2.Events = item.ClientScript;
appLibraryButtons2.Ico = (item.Ico ?? "");
appLibraryButtons2.ID = item.ID;
appLibraryButtons2.Name = item.ButtonName;
appLibraryButtons2.ShowType = item.ShowType;
appLibraryButtons2.Sort = item.Sort;
appLibraryButtons2.Type = 0;
appLibraryButtons2.IsValidateShow = item.IsValidateShow;
if (flag2)
{
appLibraryButtons.Add(appLibraryButtons2);
}
else
{
appLibraryButtons.Update(appLibraryButtons2);
}
list.Add(appLibraryButtons2);
}
foreach (RoadFlow.Data.Model.AppLibraryButtons1 item2 in allByAppID)
{
if (list.Find((RoadFlow.Data.Model.AppLibraryButtons1 p) => p.ID == item2.ID) == null)
{
appLibraryButtons.Delete(item2.ID);
}
}
transactionScope.Complete();
}
new AppLibrary().ClearCache();
new Menu().ClearAllDataTableCache();
new AppLibraryButtons1().ClearCache();
new AppLibrarySubPages().ClearCache();
ProgramBuilderCache programBuilderCache = new ProgramBuilderCache();
programBuilderCache.Program = programBuilder;
programBuilderCache.Fields = (from p in new ProgramBuilderFields().GetAll(programBuilder.ID)
orderby p.Sort
select p).ToList();
programBuilderCache.Querys = (from p in new ProgramBuilderQuerys().GetAll(programBuilder.ID)
orderby p.Sort
select p).ToList();
programBuilderCache.Buttons = (from p in new ProgramBuilderButtons().GetAll(id)
orderby p.Sort
select p).ToList();
programBuilderCache.Validates = new ProgramBuilderValidates().GetAll(id);
programBuilderCache.Export = (from p in new ProgramBuilderExport().GetAll(id)
orderby p.Sort
select p).ToList();
AddToCache(programBuilderCache);
return(true);
}
public int Update(RoadFlow.Data.Model.ProgramBuilder model)
{
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_001f: Unknown result type (might be due to invalid IL or missing references)
//IL_002b: Expected O, but got Unknown
//IL_002c: Expected O, but got Unknown
//IL_003a: Unknown result type (might be due to invalid IL or missing references)
//IL_003f: Unknown result type (might be due to invalid IL or missing references)
//IL_0050: Expected O, but got Unknown
//IL_0051: Expected O, but got Unknown
//IL_005b: Unknown result type (might be due to invalid IL or missing references)
//IL_0060: Unknown result type (might be due to invalid IL or missing references)
//IL_0071: Expected O, but got Unknown
//IL_0072: Expected O, but got Unknown
//IL_008c: Unknown result type (might be due to invalid IL or missing references)
//IL_0091: Unknown result type (might be due to invalid IL or missing references)
//IL_00a2: Expected O, but got Unknown
//IL_00ac: Unknown result type (might be due to invalid IL or missing references)
//IL_00b1: Unknown result type (might be due to invalid IL or missing references)
//IL_00bc: Expected O, but got Unknown
//IL_00bd: Expected O, but got Unknown
//IL_00cb: Unknown result type (might be due to invalid IL or missing references)
//IL_00d0: Unknown result type (might be due to invalid IL or missing references)
//IL_00e1: Expected O, but got Unknown
//IL_00e2: Expected O, but got Unknown
//IL_00ef: Unknown result type (might be due to invalid IL or missing references)
//IL_00f4: Unknown result type (might be due to invalid IL or missing references)
//IL_0100: Expected O, but got Unknown
//IL_0101: Expected O, but got Unknown
//IL_010b: Unknown result type (might be due to invalid IL or missing references)
//IL_0110: Unknown result type (might be due to invalid IL or missing references)
//IL_0121: Expected O, but got Unknown
//IL_0122: Expected O, but got Unknown
//IL_0130: Unknown result type (might be due to invalid IL or missing references)
//IL_0135: Unknown result type (might be due to invalid IL or missing references)
//IL_0146: Expected O, but got Unknown
//IL_0147: Expected O, but got Unknown
//IL_0151: Unknown result type (might be due to invalid IL or missing references)
//IL_0156: Unknown result type (might be due to invalid IL or missing references)
//IL_0167: Expected O, but got Unknown
//IL_0168: Expected O, but got Unknown
//IL_017e: Unknown result type (might be due to invalid IL or missing references)
//IL_0183: Unknown result type (might be due to invalid IL or missing references)
//IL_018f: Expected O, but got Unknown
//IL_019c: Unknown result type (might be due to invalid IL or missing references)
//IL_01a1: Unknown result type (might be due to invalid IL or missing references)
//IL_01ac: Expected O, but got Unknown
//IL_01ad: Expected O, but got Unknown
//IL_01c8: Unknown result type (might be due to invalid IL or missing references)
//IL_01cd: Unknown result type (might be due to invalid IL or missing references)
//IL_01de: Expected O, but got Unknown
//IL_01e8: Unknown result type (might be due to invalid IL or missing references)
//IL_01ed: Unknown result type (might be due to invalid IL or missing references)
//IL_01f8: Expected O, but got Unknown
//IL_01f9: Expected O, but got Unknown
//IL_0210: Unknown result type (might be due to invalid IL or missing references)
//IL_0215: Unknown result type (might be due to invalid IL or missing references)
//IL_0221: Expected O, but got Unknown
//IL_022f: Unknown result type (might be due to invalid IL or missing references)
//IL_0234: Unknown result type (might be due to invalid IL or missing references)
//IL_023f: Expected O, but got Unknown
//IL_0240: Expected O, but got Unknown
//IL_0257: Unknown result type (might be due to invalid IL or missing references)
//IL_025c: Unknown result type (might be due to invalid IL or missing references)
//IL_0268: Expected O, but got Unknown
//IL_0276: Unknown result type (might be due to invalid IL or missing references)
//IL_027b: Unknown result type (might be due to invalid IL or missing references)
//IL_0286: Expected O, but got Unknown
//IL_0287: Expected O, but got Unknown
//IL_02a2: Unknown result type (might be due to invalid IL or missing references)
//IL_02a7: Unknown result type (might be due to invalid IL or missing references)
//IL_02b8: Expected O, but got Unknown
//IL_02c2: Unknown result type (might be due to invalid IL or missing references)
//IL_02c7: Unknown result type (might be due to invalid IL or missing references)
//IL_02d2: Expected O, but got Unknown
//IL_02d3: Expected O, but got Unknown
//IL_02ee: Unknown result type (might be due to invalid IL or missing references)
//IL_02f3: Unknown result type (might be due to invalid IL or missing references)
//IL_0304: Expected O, but got Unknown
//IL_030e: Unknown result type (might be due to invalid IL or missing references)
//IL_0313: Unknown result type (might be due to invalid IL or missing references)
//IL_031e: Expected O, but got Unknown
//IL_031f: Expected O, but got Unknown
//IL_0335: Unknown result type (might be due to invalid IL or missing references)
//IL_033a: Unknown result type (might be due to invalid IL or missing references)
//IL_0346: Expected O, but got Unknown
//IL_0353: Unknown result type (might be due to invalid IL or missing references)
//IL_0358: Unknown result type (might be due to invalid IL or missing references)
//IL_0363: Expected O, but got Unknown
//IL_0364: Expected O, but got Unknown
//IL_037a: Unknown result type (might be due to invalid IL or missing references)
//IL_037f: Unknown result type (might be due to invalid IL or missing references)
//IL_038b: Expected O, but got Unknown
//IL_0398: Unknown result type (might be due to invalid IL or missing references)
//IL_039d: Unknown result type (might be due to invalid IL or missing references)
//IL_03a8: Expected O, but got Unknown
//IL_03a9: Expected O, but got Unknown
//IL_03bf: Unknown result type (might be due to invalid IL or missing references)
//IL_03c4: Unknown result type (might be due to invalid IL or missing references)
//IL_03d0: Expected O, but got Unknown
//IL_03dd: Unknown result type (might be due to invalid IL or missing references)
//IL_03e2: Unknown result type (might be due to invalid IL or missing references)
//IL_03ed: Expected O, but got Unknown
//IL_03ee: Expected O, but got Unknown
//IL_0404: Unknown result type (might be due to invalid IL or missing references)
//IL_0409: Unknown result type (might be due to invalid IL or missing references)
//IL_0415: Expected O, but got Unknown
//IL_0422: Unknown result type (might be due to invalid IL or missing references)
//IL_0427: Unknown result type (might be due to invalid IL or missing references)
//IL_0432: Expected O, but got Unknown
//IL_0433: Expected O, but got Unknown
//IL_044d: Unknown result type (might be due to invalid IL or missing references)
//IL_0452: Unknown result type (might be due to invalid IL or missing references)
//IL_045e: Expected O, but got Unknown
//IL_046f: Unknown result type (might be due to invalid IL or missing references)
//IL_0474: Unknown result type (might be due to invalid IL or missing references)
//IL_047f: Expected O, but got Unknown
//IL_0480: Expected O, but got Unknown
//IL_0496: Unknown result type (might be due to invalid IL or missing references)
//IL_049b: Unknown result type (might be due to invalid IL or missing references)
//IL_04a7: Expected O, but got Unknown
//IL_04b4: Unknown result type (might be due to invalid IL or missing references)
//IL_04b9: Unknown result type (might be due to invalid IL or missing references)
//IL_04c4: Expected O, but got Unknown
//IL_04c5: Expected O, but got Unknown
//IL_04df: Unknown result type (might be due to invalid IL or missing references)
//IL_04e4: Unknown result type (might be due to invalid IL or missing references)
//IL_04f0: Expected O, but got Unknown
//IL_0501: Unknown result type (might be due to invalid IL or missing references)
//IL_0506: Unknown result type (might be due to invalid IL or missing references)
//IL_0511: Expected O, but got Unknown
//IL_0512: Expected O, but got Unknown
//IL_052c: Unknown result type (might be due to invalid IL or missing references)
//IL_0531: Unknown result type (might be due to invalid IL or missing references)
//IL_053d: Expected O, but got Unknown
//IL_054e: Unknown result type (might be due to invalid IL or missing references)
//IL_0553: Unknown result type (might be due to invalid IL or missing references)
//IL_055e: Expected O, but got Unknown
//IL_055f: Expected O, but got Unknown
//IL_056e: Unknown result type (might be due to invalid IL or missing references)
//IL_0573: Unknown result type (might be due to invalid IL or missing references)
//IL_0584: Expected O, but got Unknown
//IL_0585: Expected O, but got Unknown
string sql = "UPDATE programbuilder SET \r\n\t\t\t\tName=@Name,Type=@Type,CreateTime=@CreateTime,PublishTime=@PublishTime,CreateUser=@CreateUser,`SQL`=@SQL,IsAdd=@IsAdd,DBConnID=@DBConnID,Status=@Status,FormID=@FormID,EditModel=@EditModel,Width=@Width,Height=@Height,ButtonLocation=@ButtonLocation,IsPager=@IsPager,ClientScript=@ClientScript,ExportTemplate=@ExportTemplate,ExportHeaderText=@ExportHeaderText,ExportFileName=@ExportFileName,TableStyle=@TableStyle,TableHead=@TableHead,TableName=@TableName,InDataNumberFiledName=@InDataNumberFiledName \r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] obj = new MySqlParameter[24];
MySqlParameter val = new MySqlParameter("@Name", 752, -1);
((DbParameter)val).Value = model.Name;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@Type", 253, 36);
((DbParameter)val2).Value = model.Type;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@CreateTime", 12, -1);
((DbParameter)val3).Value = model.CreateTime;
obj[2] = val3;
_003F val4;
if (model.PublishTime.HasValue)
{
val4 = new MySqlParameter("@PublishTime", 12, -1);
((DbParameter)val4).Value = model.PublishTime;
}
else
{
val4 = new MySqlParameter("@PublishTime", 12, -1);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@CreateUser", 253, 36);
((DbParameter)val5).Value = model.CreateUser;
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@SQL", 751, -1);
((DbParameter)val6).Value = model.SQL;
obj[5] = val6;
MySqlParameter val7 = new MySqlParameter("@IsAdd", 3, 11);
((DbParameter)val7).Value = model.IsAdd;
obj[6] = val7;
MySqlParameter val8 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val8).Value = model.DBConnID;
obj[7] = val8;
MySqlParameter val9 = new MySqlParameter("@Status", 3, 11);
((DbParameter)val9).Value = model.Status;
obj[8] = val9;
_003F val10;
if (model.FormID != null)
{
val10 = new MySqlParameter("@FormID", 752, -1);
((DbParameter)val10).Value = model.FormID;
}
else
{
val10 = new MySqlParameter("@FormID", 752, -1);
((DbParameter)val10).Value = DBNull.Value;
}
obj[9] = val10;
_003F val11;
if (model.EditModel.HasValue)
{
val11 = new MySqlParameter("@EditModel", 3, 11);
((DbParameter)val11).Value = model.EditModel;
}
else
{
val11 = new MySqlParameter("@EditModel", 3, 11);
((DbParameter)val11).Value = DBNull.Value;
}
obj[10] = val11;
_003F val12;
if (model.Width != null)
{
val12 = new MySqlParameter("@Width", 253, 50);
((DbParameter)val12).Value = model.Width;
}
else
{
val12 = new MySqlParameter("@Width", 253, 50);
((DbParameter)val12).Value = DBNull.Value;
}
obj[11] = val12;
_003F val13;
if (model.Height != null)
{
val13 = new MySqlParameter("@Height", 253, 50);
((DbParameter)val13).Value = model.Height;
}
else
{
val13 = new MySqlParameter("@Height", 253, 50);
((DbParameter)val13).Value = DBNull.Value;
}
obj[12] = val13;
_003F val14;
if (model.ButtonLocation.HasValue)
{
val14 = new MySqlParameter("@ButtonLocation", 3, 11);
((DbParameter)val14).Value = model.ButtonLocation;
}
else
{
val14 = new MySqlParameter("@ButtonLocation", 3, 11);
((DbParameter)val14).Value = DBNull.Value;
}
obj[13] = val14;
_003F val15;
if (model.IsPager.HasValue)
{
val15 = new MySqlParameter("@IsPager", 3, 11);
((DbParameter)val15).Value = model.IsPager;
}
else
{
val15 = new MySqlParameter("@IsPager", 3, 11);
((DbParameter)val15).Value = DBNull.Value;
}
obj[14] = val15;
_003F val16;
if (model.ClientScript != null)
{
val16 = new MySqlParameter("@ClientScript", 751, -1);
((DbParameter)val16).Value = model.ClientScript;
}
else
{
val16 = new MySqlParameter("@ClientScript", 751, -1);
((DbParameter)val16).Value = DBNull.Value;
}
obj[15] = val16;
_003F val17;
if (model.ExportTemplate != null)
{
val17 = new MySqlParameter("@ExportTemplate", 752, -1);
((DbParameter)val17).Value = model.ExportTemplate;
}
else
{
val17 = new MySqlParameter("@ExportTemplate", 752, -1);
((DbParameter)val17).Value = DBNull.Value;
}
obj[16] = val17;
_003F val18;
if (model.ExportHeaderText != null)
{
val18 = new MySqlParameter("@ExportHeaderText", 752, -1);
((DbParameter)val18).Value = model.ExportHeaderText;
}
else
{
val18 = new MySqlParameter("@ExportHeaderText", 752, -1);
((DbParameter)val18).Value = DBNull.Value;
}
obj[17] = val18;
_003F val19;
if (model.ExportFileName != null)
{
val19 = new MySqlParameter("@ExportFileName", 752, -1);
((DbParameter)val19).Value = model.ExportFileName;
}
else
{
val19 = new MySqlParameter("@ExportFileName", 752, -1);
((DbParameter)val19).Value = DBNull.Value;
}
obj[18] = val19;
_003F val20;
if (model.TableStyle != null)
{
val20 = new MySqlParameter("@TableStyle", 253, 255);
((DbParameter)val20).Value = model.TableStyle;
}
else
{
val20 = new MySqlParameter("@TableStyle", 253, 255);
((DbParameter)val20).Value = DBNull.Value;
}
obj[19] = val20;
_003F val21;
if (model.TableHead != null)
{
val21 = new MySqlParameter("@TableHead", 752, -1);
((DbParameter)val21).Value = model.TableHead;
}
else
{
val21 = new MySqlParameter("@TableHead", 752, -1);
((DbParameter)val21).Value = DBNull.Value;
}
obj[20] = val21;
_003F val22;
if (model.TableName != null)
{
val22 = new MySqlParameter("@TableName", 253, 255);
((DbParameter)val22).Value = model.TableName;
}
else
{
val22 = new MySqlParameter("@TableName", 253, 255);
((DbParameter)val22).Value = DBNull.Value;
}
obj[21] = val22;
_003F val23;
if (model.InDataNumberFiledName != null)
{
val23 = new MySqlParameter("@InDataNumberFiledName", 253, 255);
((DbParameter)val23).Value = model.InDataNumberFiledName;
}
else
{
val23 = new MySqlParameter("@InDataNumberFiledName", 253, 255);
((DbParameter)val23).Value = DBNull.Value;
}
obj[22] = val23;
MySqlParameter val24 = new MySqlParameter("@ID", 253, 36);
((DbParameter)val24).Value = model.ID;
obj[23] = val24;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilder model)
{
//IL_001b: Unknown result type (might be due to invalid IL or missing references)
//IL_0020: Unknown result type (might be due to invalid IL or missing references)
//IL_0031: Expected O, but got Unknown
//IL_0032: Expected O, but got Unknown
//IL_003f: Unknown result type (might be due to invalid IL or missing references)
//IL_0044: Unknown result type (might be due to invalid IL or missing references)
//IL_0050: Expected O, but got Unknown
//IL_0051: Expected O, but got Unknown
//IL_005f: Unknown result type (might be due to invalid IL or missing references)
//IL_0064: Unknown result type (might be due to invalid IL or missing references)
//IL_0075: Expected O, but got Unknown
//IL_0076: Expected O, but got Unknown
//IL_0080: Unknown result type (might be due to invalid IL or missing references)
//IL_0085: Unknown result type (might be due to invalid IL or missing references)
//IL_0096: Expected O, but got Unknown
//IL_0097: Expected O, but got Unknown
//IL_00b1: Unknown result type (might be due to invalid IL or missing references)
//IL_00b6: Unknown result type (might be due to invalid IL or missing references)
//IL_00c7: Expected O, but got Unknown
//IL_00d1: Unknown result type (might be due to invalid IL or missing references)
//IL_00d6: Unknown result type (might be due to invalid IL or missing references)
//IL_00e1: Expected O, but got Unknown
//IL_00e2: Expected O, but got Unknown
//IL_00f0: Unknown result type (might be due to invalid IL or missing references)
//IL_00f5: Unknown result type (might be due to invalid IL or missing references)
//IL_0106: Expected O, but got Unknown
//IL_0107: Expected O, but got Unknown
//IL_0114: Unknown result type (might be due to invalid IL or missing references)
//IL_0119: Unknown result type (might be due to invalid IL or missing references)
//IL_0125: Expected O, but got Unknown
//IL_0126: Expected O, but got Unknown
//IL_0130: Unknown result type (might be due to invalid IL or missing references)
//IL_0135: Unknown result type (might be due to invalid IL or missing references)
//IL_0146: Expected O, but got Unknown
//IL_0147: Expected O, but got Unknown
//IL_0155: Unknown result type (might be due to invalid IL or missing references)
//IL_015a: Unknown result type (might be due to invalid IL or missing references)
//IL_016b: Expected O, but got Unknown
//IL_016c: Expected O, but got Unknown
//IL_0177: Unknown result type (might be due to invalid IL or missing references)
//IL_017c: Unknown result type (might be due to invalid IL or missing references)
//IL_018d: Expected O, but got Unknown
//IL_018e: Expected O, but got Unknown
//IL_01a4: Unknown result type (might be due to invalid IL or missing references)
//IL_01a9: Unknown result type (might be due to invalid IL or missing references)
//IL_01b5: Expected O, but got Unknown
//IL_01c2: Unknown result type (might be due to invalid IL or missing references)
//IL_01c7: Unknown result type (might be due to invalid IL or missing references)
//IL_01d2: Expected O, but got Unknown
//IL_01d3: Expected O, but got Unknown
//IL_01ee: Unknown result type (might be due to invalid IL or missing references)
//IL_01f3: Unknown result type (might be due to invalid IL or missing references)
//IL_0204: Expected O, but got Unknown
//IL_020e: Unknown result type (might be due to invalid IL or missing references)
//IL_0213: Unknown result type (might be due to invalid IL or missing references)
//IL_021e: Expected O, but got Unknown
//IL_021f: Expected O, but got Unknown
//IL_0236: Unknown result type (might be due to invalid IL or missing references)
//IL_023b: Unknown result type (might be due to invalid IL or missing references)
//IL_0247: Expected O, but got Unknown
//IL_0255: Unknown result type (might be due to invalid IL or missing references)
//IL_025a: Unknown result type (might be due to invalid IL or missing references)
//IL_0265: Expected O, but got Unknown
//IL_0266: Expected O, but got Unknown
//IL_027d: Unknown result type (might be due to invalid IL or missing references)
//IL_0282: Unknown result type (might be due to invalid IL or missing references)
//IL_028e: Expected O, but got Unknown
//IL_029c: Unknown result type (might be due to invalid IL or missing references)
//IL_02a1: Unknown result type (might be due to invalid IL or missing references)
//IL_02ac: Expected O, but got Unknown
//IL_02ad: Expected O, but got Unknown
//IL_02c8: Unknown result type (might be due to invalid IL or missing references)
//IL_02cd: Unknown result type (might be due to invalid IL or missing references)
//IL_02de: Expected O, but got Unknown
//IL_02e8: Unknown result type (might be due to invalid IL or missing references)
//IL_02ed: Unknown result type (might be due to invalid IL or missing references)
//IL_02f8: Expected O, but got Unknown
//IL_02f9: Expected O, but got Unknown
//IL_0314: Unknown result type (might be due to invalid IL or missing references)
//IL_0319: Unknown result type (might be due to invalid IL or missing references)
//IL_032a: Expected O, but got Unknown
//IL_0334: Unknown result type (might be due to invalid IL or missing references)
//IL_0339: Unknown result type (might be due to invalid IL or missing references)
//IL_0344: Expected O, but got Unknown
//IL_0345: Expected O, but got Unknown
//IL_035b: Unknown result type (might be due to invalid IL or missing references)
//IL_0360: Unknown result type (might be due to invalid IL or missing references)
//IL_036c: Expected O, but got Unknown
//IL_0379: Unknown result type (might be due to invalid IL or missing references)
//IL_037e: Unknown result type (might be due to invalid IL or missing references)
//IL_0389: Expected O, but got Unknown
//IL_038a: Expected O, but got Unknown
//IL_03a0: Unknown result type (might be due to invalid IL or missing references)
//IL_03a5: Unknown result type (might be due to invalid IL or missing references)
//IL_03b1: Expected O, but got Unknown
//IL_03be: Unknown result type (might be due to invalid IL or missing references)
//IL_03c3: Unknown result type (might be due to invalid IL or missing references)
//IL_03ce: Expected O, but got Unknown
//IL_03cf: Expected O, but got Unknown
//IL_03e5: Unknown result type (might be due to invalid IL or missing references)
//IL_03ea: Unknown result type (might be due to invalid IL or missing references)
//IL_03f6: Expected O, but got Unknown
//IL_0403: Unknown result type (might be due to invalid IL or missing references)
//IL_0408: Unknown result type (might be due to invalid IL or missing references)
//IL_0413: Expected O, but got Unknown
//IL_0414: Expected O, but got Unknown
//IL_042a: Unknown result type (might be due to invalid IL or missing references)
//IL_042f: Unknown result type (might be due to invalid IL or missing references)
//IL_043b: Expected O, but got Unknown
//IL_0448: Unknown result type (might be due to invalid IL or missing references)
//IL_044d: Unknown result type (might be due to invalid IL or missing references)
//IL_0458: Expected O, but got Unknown
//IL_0459: Expected O, but got Unknown
//IL_0473: Unknown result type (might be due to invalid IL or missing references)
//IL_0478: Unknown result type (might be due to invalid IL or missing references)
//IL_0484: Expected O, but got Unknown
//IL_0495: Unknown result type (might be due to invalid IL or missing references)
//IL_049a: Unknown result type (might be due to invalid IL or missing references)
//IL_04a5: Expected O, but got Unknown
//IL_04a6: Expected O, but got Unknown
//IL_04bc: Unknown result type (might be due to invalid IL or missing references)
//IL_04c1: Unknown result type (might be due to invalid IL or missing references)
//IL_04cd: Expected O, but got Unknown
//IL_04da: Unknown result type (might be due to invalid IL or missing references)
//IL_04df: Unknown result type (might be due to invalid IL or missing references)
//IL_04ea: Expected O, but got Unknown
//IL_04eb: Expected O, but got Unknown
//IL_0505: Unknown result type (might be due to invalid IL or missing references)
//IL_050a: Unknown result type (might be due to invalid IL or missing references)
//IL_0516: Expected O, but got Unknown
//IL_0527: Unknown result type (might be due to invalid IL or missing references)
//IL_052c: Unknown result type (might be due to invalid IL or missing references)
//IL_0537: Expected O, but got Unknown
//IL_0538: Expected O, but got Unknown
//IL_0552: Unknown result type (might be due to invalid IL or missing references)
//IL_0557: Unknown result type (might be due to invalid IL or missing references)
//IL_0563: Expected O, but got Unknown
//IL_0574: Unknown result type (might be due to invalid IL or missing references)
//IL_0579: Unknown result type (might be due to invalid IL or missing references)
//IL_0584: Expected O, but got Unknown
//IL_0585: Expected O, but got Unknown
string sql = "INSERT INTO programbuilder\r\n\t\t\t\t(ID,Name,Type,CreateTime,PublishTime,CreateUser,`SQL`,IsAdd,DBConnID,Status,FormID,EditModel,Width,Height,ButtonLocation,IsPager,ClientScript,ExportTemplate,ExportHeaderText,ExportFileName,TableStyle,TableHead,`TableName`,InDataNumberFiledName) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@CreateTime,@PublishTime,@CreateUser,@SQL,@IsAdd,@DBConnID,@Status,@FormID,@EditModel,@Width,@Height,@ButtonLocation,@IsPager,@ClientScript,@ExportTemplate,@ExportHeaderText,@ExportFileName,@TableStyle,@TableHead,@TableName,@InDataNumberFiledName)";
MySqlParameter[] obj = new MySqlParameter[24];
MySqlParameter val = new MySqlParameter("@ID", 253, 36);
((DbParameter)val).Value = model.ID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@Name", 752, -1);
((DbParameter)val2).Value = model.Name;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@Type", 253, 36);
((DbParameter)val3).Value = model.Type;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@CreateTime", 12, -1);
((DbParameter)val4).Value = model.CreateTime;
obj[3] = val4;
_003F val5;
if (model.PublishTime.HasValue)
{
val5 = new MySqlParameter("@PublishTime", 12, -1);
((DbParameter)val5).Value = model.PublishTime;
}
else
{
val5 = new MySqlParameter("@PublishTime", 12, -1);
((DbParameter)val5).Value = DBNull.Value;
}
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@CreateUser", 253, 36);
((DbParameter)val6).Value = model.CreateUser;
obj[5] = val6;
MySqlParameter val7 = new MySqlParameter("@SQL", 751, -1);
((DbParameter)val7).Value = model.SQL;
obj[6] = val7;
MySqlParameter val8 = new MySqlParameter("@IsAdd", 3, 11);
((DbParameter)val8).Value = model.IsAdd;
obj[7] = val8;
MySqlParameter val9 = new MySqlParameter("@DBConnID", 253, 36);
((DbParameter)val9).Value = model.DBConnID;
obj[8] = val9;
MySqlParameter val10 = new MySqlParameter("@Status", 3, 11);
((DbParameter)val10).Value = model.Status;
obj[9] = val10;
_003F val11;
if (model.FormID != null)
{
val11 = new MySqlParameter("@FormID", 752, -1);
((DbParameter)val11).Value = model.FormID;
}
else
{
val11 = new MySqlParameter("@FormID", 752, -1);
((DbParameter)val11).Value = DBNull.Value;
}
obj[10] = val11;
_003F val12;
if (model.EditModel.HasValue)
{
val12 = new MySqlParameter("@EditModel", 3, 11);
((DbParameter)val12).Value = model.EditModel;
}
else
{
val12 = new MySqlParameter("@EditModel", 3, 11);
((DbParameter)val12).Value = DBNull.Value;
}
obj[11] = val12;
_003F val13;
if (model.Width != null)
{
val13 = new MySqlParameter("@Width", 253, 50);
((DbParameter)val13).Value = model.Width;
}
else
{
val13 = new MySqlParameter("@Width", 253, 50);
((DbParameter)val13).Value = DBNull.Value;
}
obj[12] = val13;
_003F val14;
if (model.Height != null)
{
val14 = new MySqlParameter("@Height", 253, 50);
((DbParameter)val14).Value = model.Height;
}
else
{
val14 = new MySqlParameter("@Height", 253, 50);
((DbParameter)val14).Value = DBNull.Value;
}
obj[13] = val14;
_003F val15;
if (model.ButtonLocation.HasValue)
{
val15 = new MySqlParameter("@ButtonLocation", 3, 11);
((DbParameter)val15).Value = model.ButtonLocation;
}
else
{
val15 = new MySqlParameter("@ButtonLocation", 3, 11);
((DbParameter)val15).Value = DBNull.Value;
}
obj[14] = val15;
_003F val16;
if (model.IsPager.HasValue)
{
val16 = new MySqlParameter("@IsPager", 3, 11);
((DbParameter)val16).Value = model.IsPager;
}
else
{
val16 = new MySqlParameter("@IsPager", 3, 11);
((DbParameter)val16).Value = DBNull.Value;
}
obj[15] = val16;
_003F val17;
if (model.ClientScript != null)
{
val17 = new MySqlParameter("@ClientScript", 751, -1);
((DbParameter)val17).Value = model.ClientScript;
}
else
{
val17 = new MySqlParameter("@ClientScript", 751, -1);
((DbParameter)val17).Value = DBNull.Value;
}
obj[16] = val17;
_003F val18;
if (model.ExportTemplate != null)
{
val18 = new MySqlParameter("@ExportTemplate", 752, -1);
((DbParameter)val18).Value = model.ExportTemplate;
}
else
{
val18 = new MySqlParameter("@ExportTemplate", 752, -1);
((DbParameter)val18).Value = DBNull.Value;
}
obj[17] = val18;
_003F val19;
if (model.ExportHeaderText != null)
{
val19 = new MySqlParameter("@ExportHeaderText", 752, -1);
((DbParameter)val19).Value = model.ExportHeaderText;
}
else
{
val19 = new MySqlParameter("@ExportHeaderText", 752, -1);
((DbParameter)val19).Value = DBNull.Value;
}
obj[18] = val19;
_003F val20;
if (model.ExportFileName != null)
{
val20 = new MySqlParameter("@ExportFileName", 752, -1);
((DbParameter)val20).Value = model.ExportFileName;
}
else
{
val20 = new MySqlParameter("@ExportFileName", 752, -1);
((DbParameter)val20).Value = DBNull.Value;
}
obj[19] = val20;
_003F val21;
if (model.TableStyle != null)
{
val21 = new MySqlParameter("@TableStyle", 253, 255);
((DbParameter)val21).Value = model.TableStyle;
}
else
{
val21 = new MySqlParameter("@TableStyle", 253, 255);
((DbParameter)val21).Value = DBNull.Value;
}
obj[20] = val21;
_003F val22;
if (model.TableHead != null)
{
val22 = new MySqlParameter("@TableHead", 752, -1);
((DbParameter)val22).Value = model.TableHead;
}
else
{
val22 = new MySqlParameter("@TableHead", 752, -1);
((DbParameter)val22).Value = DBNull.Value;
}
obj[21] = val22;
_003F val23;
if (model.TableName != null)
{
val23 = new MySqlParameter("@TableName", 253, 255);
((DbParameter)val23).Value = model.TableName;
}
else
{
val23 = new MySqlParameter("@TableName", 253, 255);
((DbParameter)val23).Value = DBNull.Value;
}
obj[22] = val23;
_003F val24;
if (model.InDataNumberFiledName != null)
{
val24 = new MySqlParameter("@InDataNumberFiledName", 253, 255);
((DbParameter)val24).Value = model.InDataNumberFiledName;
}
else
{
val24 = new MySqlParameter("@InDataNumberFiledName", 253, 255);
((DbParameter)val24).Value = DBNull.Value;
}
obj[23] = val24;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
