private List <RoadFlow.Data.Model.WorkFlow> DataReaderToList(MySqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlow> workFlowList = new List <RoadFlow.Data.Model.WorkFlow>();
while (dataReader.Read())
{
RoadFlow.Data.Model.WorkFlow workFlow = new RoadFlow.Data.Model.WorkFlow();
workFlow.ID = dataReader.GetString(0).ToGuid();
workFlow.Name = dataReader.GetString(1);
workFlow.Type = dataReader.GetString(2).ToGuid();
workFlow.Manager = dataReader.GetString(3);
workFlow.InstanceManager = dataReader.GetString(4);
workFlow.CreateDate = dataReader.GetDateTime(5);
workFlow.CreateUserID = dataReader.GetString(6).ToGuid();
if (!dataReader.IsDBNull(7))
{
workFlow.DesignJSON = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
workFlow.InstallDate = new DateTime?(dataReader.GetDateTime(8));
}
if (!dataReader.IsDBNull(9))
{
workFlow.InstallUserID = new Guid?(dataReader.GetString(9).ToGuid());
}
if (!dataReader.IsDBNull(10))
{
workFlow.RunJSON = dataReader.GetString(10);
}
workFlow.Status = dataReader.GetInt32(11);
workFlowList.Add(workFlow);
}
return(workFlowList);
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <RoadFlow.Data.Model.WorkFlow> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlow> List = new List <RoadFlow.Data.Model.WorkFlow>();
RoadFlow.Data.Model.WorkFlow model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.WorkFlow();
model.ID = dataReader.GetGuid(0);
model.Name = dataReader.GetString(1);
model.Type = dataReader.GetGuid(2);
model.Manager = dataReader.GetString(3);
model.InstanceManager = dataReader.GetString(4);
model.CreateDate = dataReader.GetDateTime(5);
model.CreateUserID = dataReader.GetGuid(6);
if (!dataReader.IsDBNull(7))
{
model.DesignJSON = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
model.InstallDate = dataReader.GetDateTime(8);
}
if (!dataReader.IsDBNull(9))
{
model.InstallUserID = dataReader.GetGuid(9);
}
if (!dataReader.IsDBNull(10))
{
model.RunJSON = dataReader.GetString(10);
}
model.Status = dataReader.GetInt32(11);
List.Add(model);
}
return(List);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlow实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlow model)
{
string sql = @"UPDATE WorkFlow SET
Name=@Name,Type=@Type,Manager=@Manager,InstanceManager=@InstanceManager,CreateDate=@CreateDate,CreateUserID=@CreateUserID,DesignJSON=@DesignJSON,InstallDate=@InstallDate,InstallUserID=@InstallUserID,RunJSON=@RunJSON,Status=@Status
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Name", SqlDbType.NVarChar, 1000)
{
Value = model.Name
},
new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1)
{
Value = model.Type
},
new SqlParameter("@Manager", SqlDbType.VarChar, 5000)
{
Value = model.Manager
},
new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000)
{
Value = model.InstanceManager
},
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8)
{
Value = model.CreateDate
},
new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1)
{
Value = model.RunJSON
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlow实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlow model)
{
string sql = @"INSERT INTO WorkFlow
(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status)
VALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Name", SqlDbType.NVarChar, 1000)
{
Value = model.Name
},
new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1)
{
Value = model.Type
},
new SqlParameter("@Manager", SqlDbType.VarChar, 5000)
{
Value = model.Manager
},
new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000)
{
Value = model.InstanceManager
},
new SqlParameter("@CreateDate", SqlDbType.DateTime, 8)
{
Value = model.CreateDate
},
new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1)
{
Value = model.RunJSON
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlow实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlow model)
{
string sql = @"UPDATE WorkFlow SET
Name=:Name,Type=:Type,Manager=:Manager,InstanceManager=:InstanceManager,CreateDate=:CreateDate,CreateUserID=:CreateUserID,DesignJSON=:DesignJSON,InstallDate=:InstallDate,InstallUserID=:InstallUserID,RunJSON=:RunJSON,Status=:Status
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":Name", OracleDbType.NVarchar2, 1000)
{
Value = model.Name
},
new OracleParameter(":Type", OracleDbType.Varchar2, 40)
{
Value = model.Type
},
new OracleParameter(":Manager", OracleDbType.Varchar2, 5000)
{
Value = model.Manager
},
new OracleParameter(":InstanceManager", OracleDbType.Varchar2, 5000)
{
Value = model.InstanceManager
},
new OracleParameter(":CreateDate", OracleDbType.Date, 8)
{
Value = model.CreateDate
},
new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":DesignJSON", OracleDbType.Clob)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new OracleParameter(":InstallDate", OracleDbType.Date, 8)
{
Value = DBNull.Value
} : new OracleParameter(":InstallDate", OracleDbType.Date, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new OracleParameter(":RunJSON", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":RunJSON", OracleDbType.Clob)
{
Value = model.RunJSON
},
new OracleParameter(":Status", OracleDbType.Int32)
{
Value = model.Status
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlow实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlow model)
{
string sql = @"INSERT INTO WorkFlow
(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status)
VALUES(:ID,:Name,:Type,:Manager,:InstanceManager,:CreateDate,:CreateUserID,:DesignJSON,:InstallDate,:InstallUserID,:RunJSON,:Status)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":Name", OracleDbType.NVarchar2, 1000)
{
Value = model.Name
},
new OracleParameter(":Type", OracleDbType.Varchar2, 40)
{
Value = model.Type
},
new OracleParameter(":Manager", OracleDbType.Varchar2, 5000)
{
Value = model.Manager
},
new OracleParameter(":InstanceManager", OracleDbType.Varchar2, 5000)
{
Value = model.InstanceManager
},
new OracleParameter(":CreateDate", OracleDbType.Date, 8)
{
Value = model.CreateDate
},
new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40)
{
Value = model.CreateUserID
},
model.DesignJSON == null ? new OracleParameter(":DesignJSON", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":DesignJSON", OracleDbType.Clob)
{
Value = model.DesignJSON
},
model.InstallDate == null ? new OracleParameter(":InstallDate", OracleDbType.Date, 8)
{
Value = DBNull.Value
} : new OracleParameter(":InstallDate", OracleDbType.Date, 8)
{
Value = model.InstallDate
},
model.InstallUserID == null ? new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40)
{
Value = DBNull.Value
} : new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40)
{
Value = model.InstallUserID
},
model.RunJSON == null ? new OracleParameter(":RunJSON", OracleDbType.Clob)
{
Value = DBNull.Value
} : new OracleParameter(":RunJSON", OracleDbType.Clob)
{
Value = model.RunJSON
},
new OracleParameter(":Status", OracleDbType.Int32)
{
Value = model.Status
}
};
return(dbHelper.Execute(sql, parameters));
}
public int Add(RoadFlow.Data.Model.WorkFlow model)
{
string sql = "INSERT INTO workflow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[12];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Name", MySqlDbType.Text, -1);
mySqlParameter2.Value = (object)model.Name;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Type", MySqlDbType.VarChar, 36);
mySqlParameter3.Value = (object)model.Type;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@Manager", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Manager;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@InstanceManager", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.InstanceManager;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6 = new MySqlParameter("@CreateDate", MySqlDbType.DateTime, -1);
mySqlParameter6.Value = (object)model.CreateDate;
mySqlParameterArray[index6] = mySqlParameter6;
int index7 = 6;
MySqlParameter mySqlParameter7 = new MySqlParameter("@CreateUserID", MySqlDbType.VarChar, 36);
mySqlParameter7.Value = (object)model.CreateUserID;
mySqlParameterArray[index7] = mySqlParameter7;
int index8 = 7;
MySqlParameter mySqlParameter8;
if (model.DesignJSON != null)
{
MySqlParameter mySqlParameter9 = new MySqlParameter("@DesignJSON", MySqlDbType.LongText, -1);
mySqlParameter9.Value = (object)model.DesignJSON;
mySqlParameter8 = mySqlParameter9;
}
else
{
mySqlParameter8 = new MySqlParameter("@DesignJSON", MySqlDbType.LongText, -1);
mySqlParameter8.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter8;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.InstallDate.HasValue)
{
MySqlParameter mySqlParameter9 = new MySqlParameter("@InstallDate", MySqlDbType.DateTime, -1);
mySqlParameter9.Value = (object)model.InstallDate;
mySqlParameter10 = mySqlParameter9;
}
else
{
mySqlParameter10 = new MySqlParameter("@InstallDate", MySqlDbType.DateTime, -1);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11;
if (model.InstallUserID.HasValue)
{
MySqlParameter mySqlParameter9 = new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, 36);
mySqlParameter9.Value = (object)model.InstallUserID;
mySqlParameter11 = mySqlParameter9;
}
else
{
mySqlParameter11 = new MySqlParameter("@InstallUserID", MySqlDbType.VarChar, 36);
mySqlParameter11.Value = (object)DBNull.Value;
}
mySqlParameterArray[index10] = mySqlParameter11;
int index11 = 10;
MySqlParameter mySqlParameter12;
if (model.RunJSON != null)
{
MySqlParameter mySqlParameter9 = new MySqlParameter("@RunJSON", MySqlDbType.LongText, -1);
mySqlParameter9.Value = (object)model.RunJSON;
mySqlParameter12 = mySqlParameter9;
}
else
{
mySqlParameter12 = new MySqlParameter("@RunJSON", MySqlDbType.LongText, -1);
mySqlParameter12.Value = (object)DBNull.Value;
}
mySqlParameterArray[index11] = mySqlParameter12;
int index12 = 11;
MySqlParameter mySqlParameter13 = new MySqlParameter("@Status", MySqlDbType.Int32, 11);
mySqlParameter13.Value = (object)model.Status;
mySqlParameterArray[index12] = mySqlParameter13;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.WorkFlow model)
{
string sql = "INSERT INTO WorkFlow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(:ID,:Name,:Type,:Manager,:InstanceManager,:CreateDate,:CreateUserID,:DesignJSON,:InstallDate,:InstallUserID,:RunJSON,:Status)";
OracleParameter[] oracleParameterArray = new OracleParameter[12];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":Name", OracleDbType.NVarchar2, 1000);
oracleParameter2.Value = (object)model.Name;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Type", OracleDbType.Varchar2, 40);
oracleParameter3.Value = (object)model.Type;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Manager", OracleDbType.Varchar2, 5000);
oracleParameter4.Value = (object)model.Manager;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":InstanceManager", OracleDbType.Varchar2, 5000);
oracleParameter5.Value = (object)model.InstanceManager;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":CreateDate", OracleDbType.Date, 8);
oracleParameter6.Value = (object)model.CreateDate;
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter7 = new OracleParameter(":CreateUserID", OracleDbType.Varchar2, 40);
oracleParameter7.Value = (object)model.CreateUserID;
oracleParameterArray[index7] = oracleParameter7;
int index8 = 7;
OracleParameter oracleParameter8;
if (model.DesignJSON != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":DesignJSON", OracleDbType.Clob);
oracleParameter9.Value = (object)model.DesignJSON;
oracleParameter8 = oracleParameter9;
}
else
{
oracleParameter8 = new OracleParameter(":DesignJSON", OracleDbType.Clob);
oracleParameter8.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter8;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.InstallDate.HasValue)
{
OracleParameter oracleParameter9 = new OracleParameter(":InstallDate", OracleDbType.Date, 8);
oracleParameter9.Value = (object)model.InstallDate;
oracleParameter10 = oracleParameter9;
}
else
{
oracleParameter10 = new OracleParameter(":InstallDate", OracleDbType.Date, 8);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11;
if (model.InstallUserID.HasValue)
{
OracleParameter oracleParameter9 = new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40);
oracleParameter9.Value = (object)model.InstallUserID;
oracleParameter11 = oracleParameter9;
}
else
{
oracleParameter11 = new OracleParameter(":InstallUserID", OracleDbType.Varchar2, 40);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12;
if (model.RunJSON != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":RunJSON", OracleDbType.Clob);
oracleParameter9.Value = (object)model.RunJSON;
oracleParameter12 = oracleParameter9;
}
else
{
oracleParameter12 = new OracleParameter(":RunJSON", OracleDbType.Clob);
oracleParameter12.Value = (object)DBNull.Value;
}
oracleParameterArray[index11] = oracleParameter12;
int index12 = 11;
OracleParameter oracleParameter13 = new OracleParameter(":Status", OracleDbType.Int32);
oracleParameter13.Value = (object)model.Status;
oracleParameterArray[index12] = oracleParameter13;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.WorkFlow model)
{
string sql = "INSERT INTO WorkFlow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)";
SqlParameter[] sqlParameterArray = new SqlParameter[12];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.ID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Name", SqlDbType.NVarChar, 1000);
sqlParameter2.Value = (object)model.Name;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1);
sqlParameter3.Value = (object)model.Type;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Manager", SqlDbType.VarChar, 5000);
sqlParameter4.Value = (object)model.Manager;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000);
sqlParameter5.Value = (object)model.InstanceManager;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6 = new SqlParameter("@CreateDate", SqlDbType.DateTime, 8);
sqlParameter6.Value = (object)model.CreateDate;
sqlParameterArray[index6] = sqlParameter6;
int index7 = 6;
SqlParameter sqlParameter7 = new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter7.Value = (object)model.CreateUserID;
sqlParameterArray[index7] = sqlParameter7;
int index8 = 7;
SqlParameter sqlParameter8;
if (model.DesignJSON != null)
{
SqlParameter sqlParameter9 = new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1);
sqlParameter9.Value = (object)model.DesignJSON;
sqlParameter8 = sqlParameter9;
}
else
{
sqlParameter8 = new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1);
sqlParameter8.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter8;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.InstallDate.HasValue)
{
SqlParameter sqlParameter9 = new SqlParameter("@InstallDate", SqlDbType.DateTime, 8);
sqlParameter9.Value = (object)model.InstallDate;
sqlParameter10 = sqlParameter9;
}
else
{
sqlParameter10 = new SqlParameter("@InstallDate", SqlDbType.DateTime, 8);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11;
if (model.InstallUserID.HasValue)
{
SqlParameter sqlParameter9 = new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter9.Value = (object)model.InstallUserID;
sqlParameter11 = sqlParameter9;
}
else
{
sqlParameter11 = new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1);
sqlParameter11.Value = (object)DBNull.Value;
}
sqlParameterArray[index10] = sqlParameter11;
int index11 = 10;
SqlParameter sqlParameter12;
if (model.RunJSON != null)
{
SqlParameter sqlParameter9 = new SqlParameter("@RunJSON", SqlDbType.VarChar, -1);
sqlParameter9.Value = (object)model.RunJSON;
sqlParameter12 = sqlParameter9;
}
else
{
sqlParameter12 = new SqlParameter("@RunJSON", SqlDbType.VarChar, -1);
sqlParameter12.Value = (object)DBNull.Value;
}
sqlParameterArray[index11] = sqlParameter12;
int index12 = 11;
SqlParameter sqlParameter13 = new SqlParameter("@Status", SqlDbType.Int, -1);
sqlParameter13.Value = (object)model.Status;
sqlParameterArray[index12] = sqlParameter13;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}