/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <Data.Model.WorkFlow> DataReaderToList(SqlDataReader dataReader)
{
List <Data.Model.WorkFlow> List = new List <Data.Model.WorkFlow>();
Data.Model.WorkFlow model = null;
while (dataReader.Read())
{
model = new Data.Model.WorkFlow();
model.ID = dataReader.GetGuid(0);
model.Name = dataReader.GetString(1);
model.Type = dataReader.GetString(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">Data.Model.WorkFlow实体类</param>
public int Update(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.NVarChar, 1000)
{
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">Data.Model.WorkFlow实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(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.NVarChar, 1000)
{
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));
}
