public List <ProductionOrder> LoadProductionOrders()
{
string sql = @"Select
[ProductionID]
,[ProduceNo]
,[OrderID]
,[OrderNo]
,[FinishDate]
,[Created]
,[CreatedBy]
From [BE_ProductionOrder] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <ProductionOrder> ret = new List <ProductionOrder>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ProductionOrder iret = new ProductionOrder();
if (!Convert.IsDBNull(dr["ProductionID"]))
{
iret.ProductionID = (Guid)dr["ProductionID"];
}
if (!Convert.IsDBNull(dr["ProduceNo"]))
{
iret.ProduceNo = (string)dr["ProduceNo"];
}
if (!Convert.IsDBNull(dr["OrderID"]))
{
iret.OrderID = (Guid)dr["OrderID"];
}
if (!Convert.IsDBNull(dr["OrderNo"]))
{
iret.OrderNo = (string)dr["OrderNo"];
}
if (!Convert.IsDBNull(dr["FinishDate"]))
{
iret.FinishDate = (DateTime)dr["FinishDate"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
iret.CreatedBy = (string)dr["CreatedBy"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int UpdateProductionOrderByProductionID(ProductionOrder obj)
{
string sql = @"Update [BE_ProductionOrder] Set
[ProduceNo]=@ProduceNo
,[OrderID]=@OrderID
,[OrderNo]=@OrderNo
,[FinishDate]=@FinishDate
,[Created]=@Created
,[CreatedBy]=@CreatedBy
,[Status]=@Status
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 pProduceNo = new SqlParameter("ProduceNo", Convert2DBnull(obj.ProduceNo));
pProduceNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pProduceNo);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
SqlParameter pOrderNo = new SqlParameter("OrderNo", Convert2DBnull(obj.OrderNo));
pOrderNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pOrderNo);
SqlParameter pFinishDate = new SqlParameter("FinishDate", Convert2DBnull(obj.FinishDate));
pFinishDate.SqlDbType = SqlDbType.SmallDateTime;
cmd.Parameters.Add(pFinishDate);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pStatus = new SqlParameter("Status", Convert2DBnull(obj.Status));
pStatus.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pStatus);
return(cmd.ExecuteNonQuery());
}
public int LoadProductionOrder(ProductionOrder obj)
{
string sql = @"Select
[ProductionID]
,[ProduceNo]
,[OrderID]
,[OrderNo]
,[FinishDate]
,[Created]
,[CreatedBy]
,[Status]
From [BE_ProductionOrder] 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);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["ProductionID"]))
{
obj.ProductionID = (Guid)dr["ProductionID"];
}
if (!Convert.IsDBNull(dr["ProduceNo"]))
{
obj.ProduceNo = (string)dr["ProduceNo"];
}
if (!Convert.IsDBNull(dr["OrderID"]))
{
obj.OrderID = (Guid)dr["OrderID"];
}
if (!Convert.IsDBNull(dr["OrderNo"]))
{
obj.OrderNo = (string)dr["OrderNo"];
}
if (!Convert.IsDBNull(dr["FinishDate"]))
{
obj.FinishDate = (DateTime)dr["FinishDate"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
obj.CreatedBy = (string)dr["CreatedBy"];
}
if (!Convert.IsDBNull(dr["Status"]))
{
obj.Status = (string)dr["Status"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertProductionOrder(ProductionOrder obj)
{
string sql = @"Insert Into [BE_ProductionOrder](
[ProductionID]
,[ProduceNo]
,[OrderID]
,[OrderNo]
,[FinishDate]
,[Created]
,[CreatedBy]
,[Status]
)Values (
@ProductionID
,@ProduceNo
,@OrderID
,@OrderNo
,@FinishDate
,@Created
,@CreatedBy
,@Status
)";
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 pProduceNo = new SqlParameter("ProduceNo", Convert2DBnull(obj.ProduceNo));
pProduceNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pProduceNo);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
SqlParameter pOrderNo = new SqlParameter("OrderNo", Convert2DBnull(obj.OrderNo));
pOrderNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pOrderNo);
SqlParameter pFinishDate = new SqlParameter("FinishDate", Convert2DBnull(obj.FinishDate));
pFinishDate.SqlDbType = SqlDbType.SmallDateTime;
cmd.Parameters.Add(pFinishDate);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pStatus = new SqlParameter("Status", Convert2DBnull(obj.Status));
pStatus.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pStatus);
return(cmd.ExecuteNonQuery());
}
