public List <WarehouseInDetail> LoadWarehouseInDetailsByLocationID(Guid locationID) { string sql = @"SELECT [DetailID] , [InID] , [MaterialID] , [Qty] , [Price] , [LocationID] FROM [BE_WarehouseInDetail] WHERE [LocationID]=@LocationID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pLocationID = new SqlParameter("LocationID", locationID); pLocationID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pLocationID); List <WarehouseInDetail> ret = new List <WarehouseInDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { WarehouseInDetail iret = new WarehouseInDetail(); if (!Convert.IsDBNull(dr["DetailID"])) { iret.DetailID = (Guid)dr["DetailID"]; } if (!Convert.IsDBNull(dr["InID"])) { iret.InID = (Guid)dr["InID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { iret.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { iret.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["Price"])) { iret.Price = (decimal)dr["Price"]; } if (!Convert.IsDBNull(dr["LocationID"])) { iret.LocationID = (Guid)dr["LocationID"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int LoadWarehouseInDetailByDetailID(WarehouseInDetail obj) { string sql = @"SELECT [DetailID] , [InID] , [MaterialID] , [Qty] , [Price] , [LocationID] FROM [BE_WarehouseInDetail] WITH(NOLOCK) WHERE [DetailID]=@DetailID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID)); pDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pDetailID); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { if (!Convert.IsDBNull(dr["DetailID"])) { obj.DetailID = (Guid)dr["DetailID"]; } if (!Convert.IsDBNull(dr["InID"])) { obj.InID = (Guid)dr["InID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { obj.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { obj.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["Price"])) { obj.Price = (decimal)dr["Price"]; } if (!Convert.IsDBNull(dr["LocationID"])) { obj.LocationID = (Guid)dr["LocationID"]; } ret += 1; } } finally { dr.Close(); } return(ret); }
public List <WarehouseInDetail> LoadWarehouseInDetails() { string sql = @"SELECT [DetailID] , [InID] , [MaterialID] , [Qty] , [Price] , [LocationID] FROM [BE_WarehouseInDetail]" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); List <WarehouseInDetail> ret = new List <WarehouseInDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { WarehouseInDetail iret = new WarehouseInDetail(); if (!Convert.IsDBNull(dr["DetailID"])) { iret.DetailID = (Guid)dr["DetailID"]; } if (!Convert.IsDBNull(dr["InID"])) { iret.InID = (Guid)dr["InID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { iret.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { iret.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["Price"])) { iret.Price = (decimal)dr["Price"]; } if (!Convert.IsDBNull(dr["LocationID"])) { iret.LocationID = (Guid)dr["LocationID"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int InsertWarehouseInDetail(WarehouseInDetail obj) { string sql = @"INSERT INTO[BE_WarehouseInDetail]([DetailID] , [InID] , [MaterialID] , [Qty] , [Price] , [LocationID] ) VALUES(@DetailID , @InID , @MaterialID , @Qty , @Price , @LocationID )" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID)); pDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pDetailID); SqlParameter pInID = new SqlParameter("InID", Convert2DBnull(obj.InID)); pInID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pInID); SqlParameter pMaterialID = new SqlParameter("MaterialID", Convert2DBnull(obj.MaterialID)); pMaterialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pMaterialID); SqlParameter pQty = new SqlParameter("Qty", Convert2DBnull(obj.Qty)); pQty.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pQty); SqlParameter pPrice = new SqlParameter("Price", Convert2DBnull(obj.Price)); pPrice.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pPrice); SqlParameter pLocationID = new SqlParameter("LocationID", Convert2DBnull(obj.LocationID)); pLocationID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pLocationID); return(cmd.ExecuteNonQuery()); }
public int UpdateWarehouseInDetailByDetailID(WarehouseInDetail obj) { string sql = @"UPDATE [BE_WarehouseInDetail] SET [InID]=@InID , [MaterialID]=@MaterialID , [Qty]=@Qty , [Price]=@Price , [LocationID]=@LocationID WHERE [DetailID]=@DetailID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pInID = new SqlParameter("InID", Convert2DBnull(obj.InID)); pInID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pInID); SqlParameter pMaterialID = new SqlParameter("MaterialID", Convert2DBnull(obj.MaterialID)); pMaterialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pMaterialID); SqlParameter pQty = new SqlParameter("Qty", Convert2DBnull(obj.Qty)); pQty.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pQty); SqlParameter pPrice = new SqlParameter("Price", Convert2DBnull(obj.Price)); pPrice.SqlDbType = SqlDbType.Decimal; cmd.Parameters.Add(pPrice); SqlParameter pLocationID = new SqlParameter("LocationID", Convert2DBnull(obj.LocationID)); pLocationID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pLocationID); SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID)); pDetailID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pDetailID); return(cmd.ExecuteNonQuery()); }