public List <WarehouseOutDetail> LoadWarehouseOutDetailsByLocationID(Guid locationID) { string sql = @"SELECT [DetailID] , [OutID] , [MaterialID] , [Qty] , [LocationID] FROM [BE_WarehouseOutDetail] 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 <WarehouseOutDetail> ret = new List <WarehouseOutDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { WarehouseOutDetail iret = new WarehouseOutDetail(); if (!Convert.IsDBNull(dr["DetailID"])) { iret.DetailID = (Guid)dr["DetailID"]; } if (!Convert.IsDBNull(dr["OutID"])) { iret.OutID = (Guid)dr["OutID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { iret.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { iret.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["LocationID"])) { iret.LocationID = (Guid)dr["LocationID"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int LoadWarehouseOutDetailByDetailID(WarehouseOutDetail obj) { string sql = @"SELECT [DetailID] , [OutID] , [MaterialID] , [Qty] , [LocationID] FROM [BE_WarehouseOutDetail] 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["OutID"])) { obj.OutID = (Guid)dr["OutID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { obj.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { obj.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["LocationID"])) { obj.LocationID = (Guid)dr["LocationID"]; } ret += 1; } } finally { dr.Close(); } return(ret); }
public List <WarehouseOutDetail> LoadWarehouseOutDetails() { string sql = @"SELECT [DetailID] , [OutID] , [MaterialID] , [Qty] , [LocationID] FROM [BE_WarehouseOutDetail]" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); List <WarehouseOutDetail> ret = new List <WarehouseOutDetail>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { WarehouseOutDetail iret = new WarehouseOutDetail(); if (!Convert.IsDBNull(dr["DetailID"])) { iret.DetailID = (Guid)dr["DetailID"]; } if (!Convert.IsDBNull(dr["OutID"])) { iret.OutID = (Guid)dr["OutID"]; } if (!Convert.IsDBNull(dr["MaterialID"])) { iret.MaterialID = (Guid)dr["MaterialID"]; } if (!Convert.IsDBNull(dr["Qty"])) { iret.Qty = (decimal)dr["Qty"]; } if (!Convert.IsDBNull(dr["LocationID"])) { iret.LocationID = (Guid)dr["LocationID"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int InsertWarehouseOutDetail(WarehouseOutDetail obj) { string sql = @"INSERT INTO[BE_WarehouseOutDetail]([DetailID] , [OutID] , [MaterialID] , [Qty] , [LocationID] ) VALUES(@DetailID , @OutID , @MaterialID , @Qty , @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 pOutID = new SqlParameter("OutID", Convert2DBnull(obj.OutID)); pOutID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pOutID); 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 pLocationID = new SqlParameter("LocationID", Convert2DBnull(obj.LocationID)); pLocationID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pLocationID); return(cmd.ExecuteNonQuery()); }
public int UpdateWarehouseOutDetailByDetailID(WarehouseOutDetail obj) { string sql = @"UPDATE [BE_WarehouseOutDetail] SET [OutID]=@OutID , [MaterialID]=@MaterialID , [Qty]=@Qty , [LocationID]=@LocationID WHERE [DetailID]=@DetailID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pOutID = new SqlParameter("OutID", Convert2DBnull(obj.OutID)); pOutID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pOutID); 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 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()); }