public List <ProductionOrderComponent> LoadProductionOrderComponents()
{
string sql = @"Select
[ProductionID]
,[ComponentID]
From [BE_ProductionOrderComponent] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <ProductionOrderComponent> ret = new List <ProductionOrderComponent>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ProductionOrderComponent iret = new ProductionOrderComponent();
if (!Convert.IsDBNull(dr["ProductionID"]))
{
iret.ProductionID = (Guid)dr["ProductionID"];
}
if (!Convert.IsDBNull(dr["ComponentID"]))
{
iret.ComponentID = (int)dr["ComponentID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int UpdateProductionOrderComponentByProductionID(ProductionOrderComponent obj)
{
string sql = @"Update [BE_ProductionOrderComponent] Set
[ComponentID]=@ComponentID
Where ProductionID=@ProductionID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pProductionID = new SqlParameter("ProductionID", Convert2DBnull(obj.ProductionID));
pProductionID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pProductionID);
SqlParameter pComponentID = new SqlParameter("ComponentID", Convert2DBnull(obj.ComponentID));
pComponentID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentID);
return(cmd.ExecuteNonQuery());
}
public List <ProductionOrderComponent> LoadProductionOrderComponentByProductionID(ProductionOrderComponent obj)
{
string sql = @"Select
[ProductionID]
,[ComponentID]
From [BE_ProductionOrderComponent] With(NoLock) Where ProductionID=@ProductionID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pProductionID = new SqlParameter("ProductionID", Convert2DBnull(obj.ProductionID));
pProductionID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pProductionID);
List <ProductionOrderComponent> ret = new List <ProductionOrderComponent>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ProductionOrderComponent iret = new ProductionOrderComponent();
if (!Convert.IsDBNull(dr["ProductionID"]))
{
iret.ProductionID = (Guid)dr["ProductionID"];
}
if (!Convert.IsDBNull(dr["ComponentID"]))
{
iret.ComponentID = (int)dr["ComponentID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertProductionOrderComponent(ProductionOrderComponent obj)
{
string sql = @"Insert Into [BE_ProductionOrderComponent](
[ProductionID]
,[ComponentID]
)Values (
@ProductionID
,@ComponentID
)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pProductionID = new SqlParameter("ProductionID", Convert2DBnull(obj.ProductionID));
pProductionID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pProductionID);
SqlParameter pComponentID = new SqlParameter("ComponentID", Convert2DBnull(obj.ComponentID));
pComponentID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentID);
return(cmd.ExecuteNonQuery());
}