public List <WorkOrderComponent> LoadWorkOrderComponents()
{
string sql = @"Select
[WorkOrderID]
,[ComponentID]
From [BE_WorkOrderComponent] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <WorkOrderComponent> ret = new List <WorkOrderComponent>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
WorkOrderComponent iret = new WorkOrderComponent();
if (!Convert.IsDBNull(dr["WorkOrderID"]))
{
iret.WorkOrderID = (Guid)dr["WorkOrderID"];
}
if (!Convert.IsDBNull(dr["ComponentID"]))
{
iret.ComponentID = (int)dr["ComponentID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int UpdateWorkOrderComponentByWorkOrderID(WorkOrderComponent obj)
{
string sql = @"Update [BE_WorkOrderComponent] Set
[ComponentID]=@ComponentID
Where WorkOrderID=@WorkOrderID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pWorkOrderID = new SqlParameter("WorkOrderID", Convert2DBnull(obj.WorkOrderID));
pWorkOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pWorkOrderID);
SqlParameter pComponentID = new SqlParameter("ComponentID", Convert2DBnull(obj.ComponentID));
pComponentID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentID);
return(cmd.ExecuteNonQuery());
}
public List <WorkOrderComponent> LoadWorkOrderComponentByWorkOrderID(WorkOrderComponent obj)
{
string sql = @"Select
[WorkOrderID]
,[ComponentID]
From [BE_WorkOrderComponent] With(NoLock) Where WorkOrderID=@WorkOrderID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pWorkOrderID = new SqlParameter("WorkOrderID", Convert2DBnull(obj.WorkOrderID));
pWorkOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pWorkOrderID);
List <WorkOrderComponent> ret = new List <WorkOrderComponent>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
WorkOrderComponent iret = new WorkOrderComponent();
if (!Convert.IsDBNull(dr["WorkOrderID"]))
{
iret.WorkOrderID = (Guid)dr["WorkOrderID"];
}
if (!Convert.IsDBNull(dr["ComponentID"]))
{
iret.ComponentID = (int)dr["ComponentID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertWorkOrderComponent(WorkOrderComponent obj)
{
string sql = @"Insert Into [BE_WorkOrderComponent](
[WorkOrderID]
,[ComponentID]
)Values (
@WorkOrderID
,@ComponentID
)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pWorkOrderID = new SqlParameter("WorkOrderID", Convert2DBnull(obj.WorkOrderID));
pWorkOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pWorkOrderID);
SqlParameter pComponentID = new SqlParameter("ComponentID", Convert2DBnull(obj.ComponentID));
pComponentID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentID);
return(cmd.ExecuteNonQuery());
}
