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()); }